Print Issue 

Error opening a company file on a QBi network
ID: 3626 Category: Accounts - Business Range - Desktop & Hosted (previously QuickBooks) Status: Resolved Views: 19172


Question:

Why am I receiving errors - "H101," "H202," "H303," "H505", -6077,0, -6123,0 -6000, -80, -82 when opening a company file on a networked Reckon Accounts Business?



Solution:

Accounts Business (formerly QuickBooks) is trying to establish a connection to the company file and can't communicate with the server. Several issues can cause these errors:

  1. Hosting configuration settings are incorrect.
  2. The firewall is blocking incoming or outgoing communication to the company file.
  3. The .ND file is damaged or incorrect.
  4. Accounts Business can't obtain the IP address of the system or server hosting the company file.
Solutions: 

Please Note that networking is supported only on Windows Pro versions and higher. Home Editions have different permission levels and simpler networking features that make it use unsuitable for an application like Accounts Business.

We suggest that users follow the following steps in rectifying this issue. Although your problem is due to one of these conditions, following all these steps will ensure that your network Accounts Business is properly configured.

As a preliminary step, users should:

  • Ensure mapped drives are using the UNC convention – the drive refers to a network share and then the folder.eg: server\Reckon Accounts. (in some instances, a DNS server name has been used)
  • Restart the computers and try again.
  • Ensure the Reckon Accounts Company file (data file) are not under the many layers of subfolders. We recommend you put the files on the main folder in the drive avoiding the subfolders.
If the problem persists, then continue with this document.

Step 1: Ensure that only one PC is hosting multi-user access

  • For a Client/Server network – only the File Server is hosting multi-user access through the Database Server Manager.
  • For Peer-to-Peer networks – only the host PC is hosting multi-user access.
To check hosting on workstations, click on File then Utilities:

  1. If you see Host multi-user access then the workstation is properly configured
  2. If you see Stop Hosting multi-user access, click on it to turn off hosting.
To check hosting on a Server:
  • Click on Start then enter services.msc in the search programs... or Run box;
  • Find Quickbooks Database Server Manager or QBCF Monitor Service and note whether it is set to Automatic and is Started. If not refer to Step 2 below.
  • Find QuickBooksDBxx (where xx is your QBi version:  2018: 27, 2017: 26, 2016: 25, 2015: 24, 2014: 23, 2013-22; 2012/13-21; etc.) and note whether it is set to Started.If not refer to Step 2 below.
Try opening your company file.

Step 2: Restart the QuickBooks Services on the Server.

  1. Click on Start then enter services.msc in the search programs... or Run box;
  2. Find the QuickBooks Database Server Manager or QBCF Monitor Service, right-click and select properties;
  3. Click on the Stop button;
  4. In the Startup Type box select Disabled and click on OK to close
  5. Find QuickBooksDBxx (where xx is your QBi version), right-click and select Properties;
  6. If the service was started, click on the Stop button;
  7. In the Startup Type box select Disabled and click OK to close
  8. Click on QuickBooks Database Server Manager or QBCF Monitor Service, right-click and select Properties;
  9. Click on the Start button and click Apply;
  10. In the Startup Type box select Automatic and click on OK to close;
  11. Click on QuickBooksDBxx (where xx is your QBi version), right-click and select Properties;
  12. In the Startup Type box select automatic and click onOKto close;
Try opening your company file.

Step 3: Delete the .ND files.

  1. Click on Start then Computer and browse to the folder containing your company files;
  2. Ensure that you can see all file extensions and find and delete the .ND files associated with your company files;
  3. On the File Server, launch the QuickBooks Database Server Manager, select your folders containing company files and scan; minimize when complete.
  4. Launch Reckon Accounts on one workstation and open a company file. Open the same file on a second workstation to confirm multi-user access.
  5. On a Peer-to-Peer network, launch Reckon Accounts on the Host PC and open a company file. Switch the file to multi-user mode and open it on a workstation to confirm multi-user access.

Update 06/09/2018

If you are still experiencing the issue, after deleting the .nd file and rescanning it, it is possible that you may have created mapped network drive using the fully qualified domain name.

When using a mapped network drive that was mapped using the fully qualified domain name, it can cause the .ND file to change, specifically the File Path.

It changes from the local path on the server (C:\SharedFolder) to the UNC path (\\ServerName\SharedFolder). And having a UNC path in the ND file can cause the error H202.

Solution:

1) Create a new mapped drive. Using just the host name. eg mapped using your host name. (eg: \\ServerName\SharedFolder\)

Please ensure your mapped network drive is not mapped using the fully qualified domain name (eg: \\ServerName.Domain.com.au\FolderName\). 

2) Rescan the folder so it creates a new .ND file.

3) Now try open the file and switch to multi user mode.


Step 4: Ensure the Reckon Accounts (formerly QuickBooks) System User has permissions to access the company files:
  1. Right-click & select Properties on the folder where the company files are stored.
  2. Go to the Security tab.
  3. Under the Groups or username list on Security tab – locate QBDataServiceUserxx (where xx is QBi version).
  4. If QBDataServiceUserxx is not in the Groups or user name list, click Add.
  5. On Select Users or Groups window, click on Advanced…
  6. On the second window of Select Users or Group window, click on Find Now.
  7. Locate QBDataServiceUserxx from the Search Result below then click Ok.
  8. QBDataServiceUserxx appears in the list of Security tab.
  9. Allow QBDataServiceUserxx full control to the folder by ticking the checkbox for Full Control. Then click Apply and OK.
Try opening your company file.

Step 5: Ensure that all Reckon Accounts (Formerly QuickBooks) processes are made exceptions in your firewall, anti-virus and other monitoring programmes:

Note: Reckon Accounts uses TCP/IP 

Files:

In C:\Program Files\Intuit\QuickBooks 200x-xx, where xx is your year version:

(Accounts Business: C:\Program Files\Intuit\ReckonAccounts 2013)

     FileManagement.exe

     QBDBMgr.exe
     QBDBMgrN.exe
     QBGDSPlugin.exe
     QBW32.exe
In C:\Program Files\Common Files\Intuit\QuickBooks:
(same directory for Accounts Business 2013)
     QBCFMonitorService.exe
     QBUpdate.exe



Ports:

Reckon Accounts 2019 use Port 10182
Reckon Accounts 2018 use Port 10181

Reckon Accounts 2017 use Port 10180

Reckon Accounts 2016 use Port 10179


Reckon Accounts 2015 use Port 10178
Reckon Accounts 2014 use Port 10177
Reckon Accounts 2013 use Port 10176;
.....
QuickBooks 2010/11 use Port 10173;
QuickBooks 2009/10 and 2008/09use Port 10172.

Your Accounts Business is now properly configured for multi-user access across a network.




Submitted: 25/06/2010


Modified: 24/04/2019 12:48:01 PM


Related Issues:
No related issue is available.

Generated by the Help Desk, Developed by Expinion.net