What is happening

When opening a company file in multi-user mode, an error occurs indicating one of the following:

  • You are trying to work with a company file that is located on another computer, and this copy of QuickBooks cannot reach the server on that computer. (H202)
     
  • You are trying to work with a company file that is 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.
Why is this happening

QuickBooks is trying to establish a connection to the company file and is unable to communicate with the server. Several issues can cause these errors:

  • Hosting configuration settings are incorrect.
  • The firewall is blocking incoming or 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)
  • The QuickBooksDBXX service is not started
  • The file is located in none native installed server, such as Virtual Machine (VMWare, VirtualBox, Microsoft Virtual Server..etc)
  • QBDataServiceuserXX permissions doesn't have READ/Write permission and did not set to "Include Inheritable permissions from the objects parent"
  • Did not scan Quickbooks files folder with QuickBooks Database server on the server. 
Detailed Instructions

Estimated Time: 30 minutes

Intuit recommends several solutions for this problem. 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.

QuickBooks 2012 and later

In QuickBooks 2012 and Enterprise Solutions 12.0 changes to the H202, H303 and H505 messages have been implemented with the r5 release. You will now see a Connection Information section.

 The IP address of the hosting computer and the port QuickBooks is trying to communicate with are listed in this section. Make sure the IP address is correct for the hosting computer and the ports are configured for firewall and Internet security settings for updates and network access. If using a third party software for your firewall, you may need to contact them directly to assist you in configuing the ports.

 

Note: If the port number displayed is not between the range of 55348 through 55352 for your QuickBooks 2012 products (55353through 55357 for QuickBooks 2013)you may have ports blocked. Refer to Solution 3: Open the network ports QuickBooks uses to transmit data.

Solution 1: Test network connectivity

  1. Turn hosting off on all workstations.

    1. 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.

              
      Don't change anything if you see Host Multi_User Access at your workstation. 
       
    3. If you see Stop Hosting Multi-User Access, select that option.



      1. Click Yes to confirm.
      2. In the Company File Must Be Closed window, click Yes.
    4. Restart this computer while you repeat this process at the next workstation.
       
  2. Ping the server name from your workstation.

    Important: Ping the server using its name, not its IP address.

    1. Identify the name of your server if you don't already know it.
    • Identify the server using the ipconfig /all command from the server
      1. Open a Windows Command Prompt:
        • Windows 7, Vista, Server 2008: Click the Windows Start button, enter cmd and press the Enterkey.
        • Windows XP, Server 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.
    • Identify the server name using the Windows properties of your data file.
      1. From a workstation, in Windows Explorer, browse to My Computer.
      2. Right-click the drive your company file is in, and select Properties.
      3. Look at the Title bar of the Properties window.
      4. The text to the left of the first backslash "\" is the server name.
    1. Open a Windows Command Prompt:
        • Windows 7, Vista, Server 2008: Click the Windows Start button, enter cmd and press the Enter key.
        • Windows XP, Server 2003: Click the Windows Start button and choose Run. Enter cmd and press theEnter key.
    2. Enter ping [servername], and press the Enter key.
      For Example: If your server name is Server1, you would enter ping Sever1 and press the Enter key.
    3. You should see a reply for each packet with none lost.
      Important: If you see packet loss or a slow reply, your network should be repaired.
  3. Navigate to the server shared folder via UNC from client PC. (ex: //server/QBData/)
    1. If the path to your data file is on your network and begins with a drive letter, that's a mapped drive.
    2. Find that drive in My Computer.
    3. Use the UNC path, found in the Title bar, to navigate to your company file.
  4. If you still see the error, try the next solution.

    Solution 2: Download and use the Network Diagnostic Tool on the host

      1. Download and install the tool.
      2. Scan the folder your data file is in.
        1. Click the Scan Folders tab.
        2. Click the Add Folder button.
        3. Navigate to the folder containing the data file.
        4. Click the Scan Now button.
           
      3. Make note of the number of IP addresses and Network Interfaces.
      4. If the Firewall Status section has an Open Ports button, click the button to enable those ports for QuickBooks.
        Note: If there is no Open Ports button, you can open the ports manually in the next step.
      5. Test for data file connectivity

        1. In the Test connectivity section, click the Browse button next to Company File.
        2. Navigate to the location of your data file and select it.
        3. Click the Test Connectivity button.
      6. Make note of the File Open Status and Advance Status.
      7. Try opening your company data file.

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

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

      1. Add exceptions to the Windows Firewall Exceptions list if Windows Firewall is enabled. 
        Note: For Windows 7, Windows Server Standard FE 2007 and Server 2008, add the exceptions for both inbound and outbound rules.
      2. Configure any other firewall or antivirus software to allow these ports.
        Note: For a temporary solution, you may disable the software to identify it as a problem. Be sure to re-enable it and configure the ports properly when you're done with the test.

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

    Solution 4: Set access permissions for QuickBooks services

      1. Make sure QBDataServiceUserXX is a Windows administrator account or member of the admin group.
      2. Set the required access permissions for QBDataServiceUserXX.
      3. Try opening your QuickBooks company file.
      4. Check startup options on the QuickBooks service and restart it.
        1. Click the Windows Start button:
          • Windows 7 or Windows Vista:
            In the Search field, enter services.msc and press Enter.
          • Windows XP:
            Click Run and type services.msc in the Run field and click OK.
        2. Right-click QuickBooksDBXX in the list, and select properties.
        3. Change the Startup type to Automatic.
        4. In the Service status section, click the Stop button.
        5. In the same section, click the Start button.
      5. Re-scan the folder your company file is in again (Solution 2, Step 2).

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

    Solution 5: Add your server to the Windows hosts file
    Important: Use the IP address and Computer name from Solution 1, Step 2.

    Note: If the following resolves the issue, this may indicate your server is using a Dynanmic IP address or there is an issue in the DNS settings of the network. Intuit recommends you notify your IT person of the changes made so they can investigate the DNS and IP settings of the network.

      1. On the workstation where you see the error, open the Windows hosts file.
        • (C:\Windows\System32\Drivers\Etc\) using Notepad.
        • Open Notepad as Windows Admin if necessary.
      2. Place the insertion point after the last IP address listed and type the server’s IP address.
      3. Press the TAB key once, and type the server name.
      4. From the File menu, choose Save. From the same menu, choose Exit.
      5. Try opening your company file.

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

    Solution 6: Create a new folder for your company file

      1. Create a new shared folder on the host.
      2. Set the access permissions from Solution 4.
      3. Copy the .qbw file to the new folder.
      4. Rescan the folder your company file is in again (Solution 2, Step 2).
      5. Try opening your company file.