Users frequently report receiving error number H202 in QuickBooks while switching to multi-user mode. This error typically indicates that multi-user access to your server computer, which is used to store QuickBooks company files (QBW), has been disabled. You will be unable to access the QuickBooks company file if you are unable to communicate with the server computer.
What is the meaning of QuickBooks Error H202?
The QuickBooks company files (QBW) are saved on a server computer on a multi-user network. Workstations are any other computers connected to the network that do not host QBW files. The H202 QuickBooks issue occurs when a workstation is unable to access a corporate file stored on another computer. The following is the error message:
H202 is the error code.
This company’s file is located on a different computer, and QuickBooks requires assistance in connecting it.
QuickBooks Database Server Manager
Open the start menu on the machine where the company file is saved, then QuickBooks Database Server Manager. Your files will be scanned by the Database Server Manager, and the connection will be restored.
What Causes Error H202 in QuickBooks?
When QuickBooks Desktop tries to connect to the company file but can’t communicate with the server for one of the following reasons, the error code H202 appears.
- The hosting setup parameters are incorrect.
- Incoming and outgoing communication is blocked by the server computer’s firewall.
- The DNS servers are in conflict.
- The IP address of the host system or server holding the corporate file is unavailable to QuickBooks.
- On the server machine, some internal QuickBooks services, such as QuickBooksDBXX and QBCFMonitor, aren’t running.
- The network data file (.ND) has been damaged or corrupted.
How to Fix QuickBooks Error Code H202?
NOTE: Make a backup of your QBW file before attempting the remedies described in this section. You’ll be able to restore the original data if you do it this way.
To repair the error, Intuit advises using the QuickBooks Database Server Manager. If you’ve already tried that and are still getting the H202 problem, try the following:
NOTE: Implement the solutions in the sequence listed below for best results.
Solution 1: Perform a network connectivity test.
- To test your network connection, ping your server from a workstation with error H202.
NOTE: If you don’t know your server name, you’ll need to enable “Network Discovery” on both your server and any workstations that are experiencing the problem.
To ping your server, follow these steps:
- To open the Run window, type run into the Windows search bar.
- Type cmd into the search box in the Run window and press Enter.
- To ping the server name from your workstation, type ping [servername] and press Enter.
NOTE: Make sure there is a space between ping and the name of your server. Also, when doing this step, don’t use brackets around the server name.
- If you notice packet loss or a delayed response, it’s a sign that the network needs to be fixed. If that’s the case, move on to Solution 2.
Solutions 2: Use the QuickBooks File Doctor Tool as a second option.
Run the QuickBooks File Doctor Tool to fix any network problems that are preventing multiple users from connecting to the server.
If the QuickBooks problem H202 persists, move on to the next step.
Solution 3 – Configure your QuickBooks Desktop Firewall Settings
Make sure QuickBooks isn’t being blocked by the server computer’s firewall settings. For complete information on adding QuickBooks port exceptions to the firewall, see the post ‘Configure Firewall and Internet security settings for QuickBooks Desktop.’
After you’ve set the firewall permissions, try running QuickBooks in multi-user mode on your workstation. If the issue persists, look into the next solutions.
Solution 4: Verify that QuickBooks Services are up and running.
Check to see if the QuickBooks services are running on the server. Check if the QuickBooks services are operating by following the procedures below, then repeat for QBCFMonitorService.
- Enter the word “search” into the Windows search bar.
- Type services. MSc into the Run box and press Enter.
- Browse the list in the Services pane and double-click QuickBooksDBXX.
NOTE: XX notes refer to the QuickBooks version you’re using.
- The Properties box for QuickBooksDBXX appears. As the Startup Type, choose Automatic.
- The status of the service must be either running or started. Otherwise, choose Start.
Figure 5: The Services Window in QuickBooks
- Then select the Recovery tab.
- From the drop-down boxes for First failure, second failure, and Subsequent failures, select Restart the Service.
Figure 6: Go to the Recovery Tab.
- To save the changes, click Apply and then OK.
- The steps for QBCFMonitorService are the same as for QBCFMonitorService. Open QuickBooks on each workstation once you’ve finished the procedures. Select the Switch to Multi-user Mode option from the File menu. If you can open everything correctly, the issue is resolved.
Solutions 5: Add your server to the Windows Hosts File
You will need to change the Windows hosts file in order to add your PC server. To do so, take the following steps:
- To open the Windows hosts file (on the PC that is causing the problem), go to any of the following locations:
- C: Windows System32DriversEtc.
- C: Windows Syswow64DriversEtc.
(Figure 7): Windows Hosts File
- To open the hosts file, double-click it.
- Choose Notepad when prompted with “How do you wish to open this file?”
Figure 8: Open the Hosts File with a Program
- Exit should be selected.
- Try opening the company file in multi-user mode after completing the preceding procedures. If this does not solve the problem, move on to the next option.
- After the last I in the hosts file,
- Enter the server’s IP address followed by the server name after the final IP address in the hosts file.
NOTE: Instead of using the space bar to separate the IP address and server name, use the TAB key.
Figure 9: Update your Hosts File with Server Information
- Choose Save from the File menu.
- Exit should be selected.
Try opening the company file in multi-user mode after completing the preceding procedures. If this does not solve the problem, move on to the next option.
(Solution 6) Create a New Folder for Your QBW File
- Create a new folder for your QBW file using the following method:
- Create a new folder on the server machine.
- To share company files, share the folder and set up folder and Windows access permissions.
- To the new folder, copy the QuickBooks Database (QBW) file.
- Return to multi-user mode and open your company file.
(Solution 7) Set Hosting to Local Files
Following these procedures will ensure that the same corporate file is not being hosted by another client system.
- Press F2 to bring up the Product Information screen in QuickBooks.
- Select Hosting to reflect ‘local files only’ under Local Server Information in the lower left corner.
(Solution 8) – Open QuickBooks Database Server Manager and restart it.
Many QuickBooks users have reported that restarting the Database Server Manager was helpful in resolving the H202 problem. Here’s how to do it:
- Click OK after typing services. MSc in the Run window.
- Stop QuickBooksDB19 (2009), QuickBooksDB18 (2008), or QuickBooksDB17 (2007) by right-clicking them.
- Select Start with a right-click. After that, they shut the window.
- Extensions for commonly used file types are displayed.
- Select Explore > Tools > Folder Options from the right-click menu on the Windows Start button.
- Clear the Hide extensions for known file types box on the View tab.
- Click the View tab again, then Show hidden files and folders, then uncheck the box next to Hide protected operating system files.
- Click Yes in the warning window, then OK.
- Windows Explorer should be closed.
Solution 9-Delete the. ND file and recreate it.
To fix the problem, try removing and rebuilding the corrupt.ND file:
- Type *.ND into the Windows search box and press Enter.
- Right-click the.ND file in the Results window and select Delete.
- When prompted, confirm deletion.
- After that, press the Windows Start button.
- Choose All Programs > QuickBooks > QuickBooks Database Server Manager from the drop-down menu.
- Select the Scan Folder option from the drop-down menu.
- Select Add Folder from the drop-down menu and navigate to the corporate file folder.
- Click the OK button after selecting the company file. In the Folder with QuickBooks company files field, type the path to the company file.
- To begin the scanning process, click Scan.
- When the scan is finished, click Close.
Is There Anything Else You Can Do?
If the problem remains after attempting all of the above alternatives, you can seek assistance from the QuickBooks customer service team.
It’s important to remember that implementing the above solutions improperly can result in data loss. As a result, it is strongly advised that you back up your corporate files. However, if you believe your company file is seriously damaged or corrupt, Stellar Repair for QuickBooks® Software can assist you. The software can also assist you with removing all problems from your QuickBooks application and QBW file.
What Are the Benefits of Using Xpertech Accounting Advisors for QuickBooks® Software?
- Without making changes to the original file, the sophisticated QuickBooks File Fix Software can repair severely damaged and corrupted QuickBooks (QBW) files.
- can aid in the elimination of repeated mistakes, programme freezes, and the risk of data loss.
- It recovers the company’s data, as well as those of its customers, vendors, and workers.
- The user interface reads the QBW file quickly and gives a preview of the data that can be recovered.
- Is it possible to restore data from a QuickBooks backup file? (QBB)
Final Thoughts QuickBooks issue number H202 is a difficult one to fix. However, with the appropriate solutions on your side, you can overcome this and other similar issues so that you can continue working on your QuickBooks financial transactions without interruption. This article will go over all of the options for resolving the QuickBooks problem H202. However, make a backup of your QuickBooks company files and keep Stellar Restore for QuickBooks® software on hand to repair and recover the QBW file’s data.