Had a client with a simple peer-to-peer network of three machines that was using Quickbooks for their accounting and customer database. Their main bookkeeper’s workstation was the “file server” for their network with the rest as “client” workstations on their network. This allowed the secretary to access the customer data while scanning in contracts. Regularly these computers would become disconnected and their secretary was unable to connect properly. It would give a Quickbooks H202 error when trying to open across the network. This was causing multiple files to be created and their bookkeeper was often contacted to “fix” the problem. When I got an opportunity to work on their network there were several issues that needed addressing to properly fix the issue:
In a peer-to-peer environment, hosting should only be enabled on the hosting computer (file server).
- On each workstation (not the file server), open QuickBooks and choose File Utilities.
- 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.
- If you see Stop Hosting Multi-User Access, select that option.
- Click Yes to confirm. In the Company File Must Be Closed window, click Yes.
- Repeat steps 1-4 on each computer.
Verify QuickBooks Services
When working with QuickBooks in a multi-user mode, QuickBooks services need to be running on the file server computer.
- Make sure the QuickBooksDBXX (XX represents the year of QuickBooks) and QBCFMonitorService services are started.
- Click the Windows Start button.
- Press the Windows key + R to bring up the run box.
- Type services.msc and press Enter.
- In the services window, scroll down and look for the QuickBooksDBXX service. Note: XX represents the year of QuickBooks you are troubleshooting.
-
If you do not see the QuickBooksDBXX service, 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)
- Double-click the QuickBooksDBXX service and make sure the Startup Type is set to Automatic and service status is Started.
- Click the Recovery tab.
- Click the drop-down menu for First failure and select Restart the Service. This will automatically restart the QuickBooksDB service if it fails. Do the same for Second failure and Subsequent failures:
- Click OK to save the changes.
- Repeat steps 1-6 above for the QBCFMonitorService.
- 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.
Open the Network Ports QuickBooks Uses to Transmit Data
Perform the following on each computer:
- Access Windows Firewall Settings
- For Windows 8
- Hover the mouse in the upper or lower right-hand corners and select Settings
- Click on Control Panel and choose Windows Firewall
- On the left, click on Advanced Settings
- For Windows Vista/Windows 7/Windows Server 2008
- Click the Start menu and enter firewall.
- Click on Windows Firewall with Advanced Security.
- On the left, right-click on Outbound Rules, and choose New Rule
- Note (Windows Vista/Windows 7/Windows Server 2008): It’s a little tricky, you have to left-click Outbound Rules first to highlight it, then right-click on it.
- Choose Ports and click Next.
- Select TCP and in the specific local ports box, enter in the following ports:
- QuickBooks 2016: 8019, 56726, 55368-55372
- QuickBooks 2015: 8019, 56725, 55363-55367
- QuickBooks 2014: 8019, 56724, 55358-55362
- QuickBooks 2013: 8019, 56723, 55353-55357
- Click Next and select Allow the Connection.
- Click Next to enter a name in the name field (for example, “QuickBooks ports” ) and click Finish.
- Repeat steps 1-5 for the Inbound Rules.
- 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).
Once these three items are configured properly on each of the network workstations then there should be no problems with connectivity or get any further Quickbooks H202 errors – that is of course as long as the “file server” workstation is not turned off or allowed to go to sleep. Also the file cannot be switched to single user mode on any computer unless it is then set back to multi-user mode once advanced configuration is done. If your company is using Quickbooks for your accounting or customer database and need help getting the network connected to the file, then contact us for assistance.