QuickBooks Desktop Error H202: Meaning, Causes, and How to Fix It
Fix QuickBooks Desktop multi-user Error H202 without Intuit support. Learn how to check hosting settings, Database Server Manager, firewall ports, and serv
When you try to open a company file in multi-user mode and see QuickBooks Desktop Error H202, it means your workstation is trying to reach the file over the network but cannot establish a connection to the server. This is almost always a network, firewall, or hosting configuration issue—not a problem with the company file itself. Fortunately, you can resolve this on your own without Intuit support or upgrading your software.
Understanding the H-Series Multi-User Family
Error H202 belongs to a family of multi-user connection errors (the H-series) that trigger when QuickBooks Desktop loses communication with the server hosting the company file. If you are seeing nearby codes like H505 or H303, the underlying causes and troubleshooting steps are largely the same. These errors indicate that your computer is blocked from switching into multi-user mode.
Common Causes of Error H202
The error typically stems from one of the following breakdowns in your local network setup:
- Incorrect Hosting Configuration: Hosting is turned on for your workstation but turned off for the server.
- Blocked Firewall Ports: Your computer's firewall or antivirus software is actively blocking QuickBooks from communicating over the network.
- Stopped Database Services: The QuickBooks Database Server Manager service on the host machine has crashed or is not running.
- Damaged Network Data File: The
.ND(Network Data) configuration file that allows multi-user access has become corrupted.
How to Fix Error H202 Yourself
Follow these steps to restore your multi-user connection. These steps apply to QuickBooks Desktop Pro, Premier, and Enterprise, whether you are on a current or discontinued version.
1. Verify Hosting Mode on Every Machine Multi-user mode requires exactly one computer to act as the host.
- On your server computer, go to File > Utilities. If you see Stop Hosting Multi-User Access, hosting is already on—leave it alone.
- If you see Host Multi-User Access, click it to turn hosting on.
- Go to every workstation (the computers accessing the file remotely) and ensure Host Multi-User Access is NOT selected. Only the server should host.
2. Restart the QuickBooks Database Services
The server machine runs a background service (labeled QuickBooksDBxx, where "xx" corresponds to your version year, such as QuickBooksDB33) to route the file.
- Open the Windows Start menu, type Services, and open the app.
- Scroll down to find QuickBooksDBxx (or QBCFMonitorService).
- Right-click the service and select Restart (or Start if it was stopped).
3. Configure Your Firewall Ports
If the services are running but you still get H202, your firewall is likely blocking the connection. You need to configure your firewall to allow specific inbound and outbound ports for QuickBooks. The exact port numbers depend on your version year (for example, Enterprise 2023 uses port 8019 and dynamic ports). You will need to consult your firewall software's rules section to add these exceptions for the QBW32.exe and QBW32Premier.exe (or Enterprise equivalent) executable files.
4. Recreate the Network Data (.ND) File
If the network settings are correct but the connection still fails, a damaged .ND file is usually to blame.
- Navigate to the folder on your server where your company file (the
.qbwfile) is stored. - Look for a file with the same name as your company file but ending in .ND.
- Right-click the
.NDfile and rename it (e.g., add.OLDto the end of the name). Do not delete it. - Open QuickBooks Database Server Manager on the server, and run a scan on the folder containing your company file. This forces QuickBooks to generate a fresh, uncorrupted
.NDfile.
How to Prevent H202 from Recurring
To keep multi-user mode running smoothly, avoid mapping network drives to access the company file. Instead, always browse to the file using the universal naming convention (UNC) path (e.g., \\ServerName\QuickBooks\CompanyFile.qbw). Additionally, ensure your server computer is set to stay awake and that Windows updates do not automatically restart the machine during working hours, which can abruptly sever the database connection for other users.
When the Company File Itself Is Damaged
Error H202 is strictly a network routing error. However, if you successfully resolve the H202 error but QuickBooks still refuses to open the file—or if you start receiving unrecoverable error codes, the H-series error may have been masking actual data corruption. If your .qbw file is damaged or behaving erratically after fixing your network connection, you can repair a damaged QuickBooks company file to restore your data without needing to upgrade or migrate your accounting setup.