QuickBooks: Error H101, H202, H303, or H505 when opening your company file


When you open a company file in multi-user mode, you see an error:

  • You’re trying to work with a company file located on another computer, and this copy of QuickBooks can’t reach the server on that computer (H202).
  • You’re trying to work with a company file located on another computer, and that computer needs additional installation and setup. (H101, H303, and H505).
  • It appears that the QuickBooks software on computer [server name] is set up to allow shared connections to the company file, but the QuickBooks software on your computer is unable to communicate with it. (H202).

Note: Intuit does not support firewall or anti-virus programs. You may need to consult the program provider for assistance with installing and setting up your program.

 

Why this is happening

QuickBooks is trying to establish a connection to the company file and can’t communicate with the server (computer hosting the QuickBooks files). Several issues can cause these errors:

  • Hosting configuration settings are incorrect.
  • The firewall is blocking incoming/outgoing communication to the company file.
  • The .ND file is damaged or incorrect.
  • QuickBooks can’t obtain the IP address of the system or server hosting the company file.
  • Workstations are configured to open the file through the hosts Full Qualified Domain Name (ex. computername.domain.com) or DNS settings are incorrect.
  • The QuickBooksDBXX or QBCFMonitor services are not started.

 

How to fix it

Before you attempt to fix any of these issues, you need to know which computer is the host computer. This will depend on the type of set up you have.

Use these diagrams to help identify your host computer and workstation(s):

Dedicated hosting diagram

Hosting Diagram

 

Peer to peer hosting diagram

Peer to Peer Server: The peer to peer server is a workstation computer in the network that acts as the QuickBooks host. In other words, physically stores the QuickBooks company files.

Hosting Diagram-peer2peer

 

Resolve QuickBooks H101, H202, H303, and H505 errors

Important: If you are receiving errors: H101, H303 or H505, please follow Solution 2 only.

Intuit recommends several solutions for resolving H202 errors. The first solution may solve your problem, or you may need to try all of them to resolve the issue. For best results, perform the solutions in the order shown.

h202errorfinal

Solution 1: Download and use the QuickBooks File Doctor

Download and run the QuickBooks File Doctor which will attempt to automatically resolve the multi-user error (H202, H303, H505, or H101).

If you still see the error, try the next solution.

 

Solution 2: Check hosting and services

  1. Verify hosting

    In a multi-user environment, hosting should only be enabled on the hosting computer (server).

    1. On each workstation (not the server or hosting computer), open QuickBooks and choose File > Utilities.
    2. If you see Host Multi-User Access on the list, this computer is not hosting the company file and you can go to the next computer. Note: Don’t change anything if you see Host Multi User Access at your workstation.
      SLN40493-04
    3. If you see Stop Hosting Multi-User Access, select that option.
      SLN40493-05
  1. Click Yes to confirm.
  2. In the Company File Must Be Closed window, click Yes.
  • Repeat steps 1-3 on each computer.
  • Verify QuickBooks services

    When working with QuickBooks in a multi-user mode, QuickBooks services need to be running on the server computer.

    1. Make sure the QuickBooksDBXX (XX represents the year of QuickBooks) and QBCFMonitorService services are started.
      1. Click the Windows Start button.
      2. Press the Windows key + R to bring up the run box.
      3. Type services.msc and press Enter.
    2. In the services window, scroll down and look for the QuickBooksDBXX service. Note: XX represents the year of QuickBooks you are troubleshooting.
      1. If you do not see the QuickBooksDBXX service:
        1. If you only use the Database Server Manager (the entire program itself is not run on the server) make sure that the Database Server Manager is installed on the server. Note: Each year of QuickBooks you have on the workstations will need to have its Database Server Manager installed to use multi-user mode.
        2. If you run the entire program on the server, open QuickBooks, go to File-> Utilities-> and make sure hosting is enabled (it should say Stop Hosting Multi User access. If it says Host Multi User mode, click it to enable hosting on the server).
    3. Double-click the QuickBooksDBXX service and make sure the Startup Type is set to Automatic and service status is Started.
      h202servicestarted
    4. Repeat steps 1-3 above for the QBCFMonitorService.
    5. Open QuickBooks in multi-user mode on each affected workstation. If the issue persists, try to make sure the QuickBooksDBXX service is a member of the administrator group and has the appropriate permissions.

 

  • If you still see the error, try the next solution.

 

Solution 3: Open the network ports QuickBooks uses to transmit data

For Windows 8

Perform the following on each computer:

  1. Hover the mouse in the upper or lower right-hand corners and select Settings
  2. Click on Control Panel and choose Windows Firewall
  3. On the left, click on Advanced Settings
  4. On the left, right-click on Outbound Rules, and choose New Rule
  5. Choose Ports and click Next.
  6. Select TCP and in the specific local ports box, enter in the following ports:
    • QuickBooks 2017: 8019, 56725, 55373-55377
    • QuickBooks 2016: 8019, 56725, 55368-55372
    • QuickBooks 2015: 8019, 56725, 55363-55367
    • QuickBooks 2014: 8019, 56724, 55358-55362
    • QuickBooks 2013: 8019, 56723, 55353-55357
    • QuickBooks 2012: 8019, 56722, 55348-55352
    • QuickBooks 2011: 8019, 56721, 55343-55347
    • QuickBooks 2010: 8019, 56720, 55338-55342
  7. Click Next and select Allow the Connection.
  8. Click Next to enter a name in the name field (for example, “QuickBooks ports” ) and click Finish.
  9. Repeat steps 1-7 for the Inbound Rules.
  10. Open QuickBooks in multi-user mode.

    If you have a third party antivirus/firewall program, you may need to configure any other firewall or antivirus software. Note: For a temporary solution, you may disable the anti-virus/firewall program to identify it as a problem and make sure to re-enable it when you’re done with the test. If the error persists, continue to step 3 (Ping the Server Computer).

For Windows Vista/Windows 7/Windows Server 2008

Perform the following on all computers:

  1. Click the Start menu and enter firewall.
  2. Click on Windows Firewall with Advanced Security.
    advfirewallstartmenu
  3. On the left side, right-click on Outbound Rules, and choose New Rule. Note: It’s a little tricky, you have to left-click Outbound Rules first to highlight it, then right-click on it.
    advfirewallnewrule
  4. Choose Ports and click Next.
  5. Select TCP and in the specific local ports box, enter in the following ports:
    • QuickBooks 2017: 8019, 56727, 55373-55377
    • QuickBooks 2016: 8019, 56726, 55368-55372
    • QuickBooks 2015: 8019, 56725, 55363-55367
    • QuickBooks 2014: 8019, 56724, 55358-55362
    • QuickBooks 2013: 8019, 56723, 55353-55357advfirewallportsadd
    • QuickBooks 2012: 8019, 56722, 55348-55352
    • QuickBooks 2011: 8019, 56721, 55343-55347
    • QuickBooks 2010: 8019, 56720, 55338-55342
  6. Click Next and select Allow the Connection.
  7. Click Next to enter a name in the name field (for example, “QuickBooks ports” ) and click Finish.
  8. Repeat steps 1-7 for the Inbound Rules.
  9. Open QuickBooks in multi-user mode.
  10. If you have a third party antivirus/firewall program, you may need to configure any other firewall or antivirus software. Note: For a temporary solution, you may disable the anti-virus/firewall program to identify it as a problem and make sure to re-enable it when you’re done with the test. If the error persists, continue to step 3.

For Windows XP and Windows Server 2003

  1. Configure any other firewall or antivirus software to allow the QuickBooks ports access through the firewall. Note: For a temporary solution, you may disable the anti-virus/firewall program to identify it as a problem and make sure to re-enable it when you’re done with the test.
  • If the error persists, continue to step 3.

Ping the server computer

Important: These steps are highly technical in nature and may be best performed by a qualified IT professional present. The scope of this test is to see if QuickBooks can reach the server from the workstation(s).

  1. Identify the name of your server if you don’t already know it.
    1. Open a Windows Command Prompt:
      • Windows 8: Press the Windows Key + R to open a run command and type CMD and press the Enter key
      • Windows Vista/Windows 7/Windows Server 2008: Click the Windows Start button, enter cmd and press the Enter key.
      • Windows XP, Windows Sever 2003: Click the Windows Start button and choose Run. Enter cmd and press the Enter key.
    2. Enter ipconfig /all, and press the Enter key.
    3. Make note of the Host Name.
      SLN40493-06
  2. Open a Windows Command Prompt:
    • Windows 8: Press the Windows Key + R to open a run command and type CMD and press the Enter key
    • Windows Vista/Windows 7/Windows Server 2008: Click the Windows Start button, enter cmd and press the Enter key.
    • Windows XP, Windows Sever 2003: Click the Windows Start button and choose Run. Enter cmd and press the Enter key.
  3. Enter ping [servername], and press the Enter key. For Example: If your server name is Server1, you would enter ping Server1 and press the Enter key.
    SLN40493-08
  4. You should see a reply for each packet with none being lost. Important: If you see packet loss or a slow reply, your network should be diagnosed by a qualified IT professional.
  5. If using a mapped drive to connect to your company file on the server, bypass the mapped drive by navigating to the server shared folder via UNC (Universal Naming Convention) path from the workstation computer (ex: //server/QBData/).
    • If the path to your company file is on your network and begins with a drive letter, it’s a mapped drive.
      SLN40493-09
  6. Use the UNC path, found in the title bar, to navigate to your company file within QuickBooks.
    SLN40493-10
  • If the error persists, proceed to solution 4.

 

Solution 4: Add your server to the Windows hosts file

It may be necessary to edit the Windows hosts file.

If the error persists after editing the Windows hosts file, continue to solution 5.

Solution 5: Create a new folder for your company file

  1. On the hosting computer, create a new folder, share it, and set Windows access permissions to share company files. Note: If you do not have access to the QuickBooks file server, you will need to contact your IT professional.
  2. Copy the .qbw file to the new folder.
  3. Open your company file in multi-user mode.

Leave a Reply