Fixing QuickBooks Desktop Error H202: When Workstations Can't Reach the Server

QuickBooks Desktop users running in multi-user mode routinely hit Error H202 — sometimes alongside the closely related H101 — when a workstation can see the company file on the server computer but cannot establish a working connection to the database service running there. The result is an immediate block: the file will not open, and work grinds to a halt for everyone on that machine.

The important thing to understand upfront is that H202 is a network and hosting configuration problem, not company-file damage. The file itself is almost always intact. What is broken is the communication path between the workstation and the server, which means the fix lives in QuickBooks’ hosting settings, the Database Server Manager, Windows firewall rules, and DNS name resolution — not in file repair tools.

Confirm Hosting Is Set Correctly on Both Machines

QuickBooks only allows one computer to act as the host for multi-user access. That role belongs to the server — the machine physically storing the company file.

On the server computer:

1. Open QuickBooks Desktop.
2. Go to File → Utilities.
3. You should see Stop Hosting Multi-User Access listed (not “Host Multi-User Access”). If you see the option to start hosting, hosting is currently off — click Host Multi-User Access to turn it on.
4. Confirm the server is set to Host Multi-User Access mode.

On each workstation:

1. Open QuickBooks Desktop.
2. Go to File → Utilities.
3. You should see Host Multi-User Access listed as an available option (not “Stop Hosting”). If you see “Stop Hosting,” click it to turn hosting off.
4. Workstations must have hosting disabled. Only the server hosts.

When more than one computer has hosting turned on, QuickBooks gets conflicting signals and H202 is a common consequence.

Install and Run the Database Server Manager

The QuickBooks Database Server Manager is a separate component that must be installed on the server computer. It is what actually manages multi-user access to the company file.

1. On the server computer, open the Start menu and search for QuickBooks Database Server Manager.
2. If it is not installed, download it from Intuit’s website by searching for “QuickBooks Tool Hub” or the standalone Database Server Manager installer for your version.
3. Once open, go to the Folders tab.
4. Click Add Folder and browse to the folder containing your company file (the .qbw file).
5. Click Start Scan.
6. Wait for the scan to complete. The Database Server Manager will register the company file and configure the necessary sharing permissions on that folder.

If you have multiple versions of QuickBooks Desktop installed (for example, 2023 and 2024), make sure the Database Server Manager is running for the correct version — the one matching the company file you are trying to open. Each version installs its own Database Server Manager instance.

Open the Required Firewall Ports

Windows Firewall (and any third-party antivirus or security software with its own firewall) must allow QuickBooks programs and the database service through. The specific ports depend on your QuickBooks Desktop version:

Port 8019 is universal across all versions — it is how QuickBooks discovers the database service. The additional ports are version-specific and handle the actual data transfer.

To add exceptions in Windows Defender Firewall:

1. Press Windows + R, type firewall.cpl, and press Enter.
2. Click Advanced settings on the left.
3. Click Inbound Rules → New Rule.
4. Select Port, choose TCP, and enter the port number(s) for your version.
5. Select Allow the connection, apply it to all profiles (Domain, Private, Public), and name it something recognizable like “QuickBooks Ports.”
6. Repeat for each port your version requires.

Also ensure the following QuickBooks executables are allowed through the firewall: QuickBooks.exe, QBW32.exe, QBDBMgrN.exe, and QBDBMgr.exe. If you are using third-party antivirus software (Bitdefender, Norton, McAfee, Kaspersky, and others), add the same exceptions in that product’s firewall configuration panel.

Run File Doctor from the QuickBooks Tool Hub

The Tool Hub includes a diagnostic tool that can automatically detect and repair common network problems.

1. Download and install the QuickBooks Tool Hub from Intuit’s website.
2. Open the Tool Hub and click the Network Issues tab.
3. Click Run File Doctor.
4. Select your company file from the dropdown (or browse to it).
5. Choose “Both file damage and network connectivity” when prompted.
6. Enter the admin password for the company file when asked.
7. Let the scan run. File Doctor will test the network path, verify hosting configuration, and attempt to repair what it finds.

File Doctor is particularly useful because it checks multiple potential causes in a single pass rather than requiring you to test each one manually.

Fix Name Resolution with the Hosts File

A frequent but less obvious cause of H202 is DNS name resolution failure. The workstation knows the server by name, but Windows cannot translate that name into the correct IP address. When this happens, the connection fails even though the network path and firewall are properly configured.

You can test this quickly: open a Command Prompt on the workstation and type ping [servername], replacing [servername] with the actual name of the server computer. If the ping fails or returns the wrong IP address, name resolution is your problem.

To fix it, add the server directly to the workstation’s hosts file:

1. Press Windows + R, type ****, and press Enter.
2. Choose Notepad (or another plain text editor) to open the file.
3. At the bottom of the file, add a new line with the server’s IP address followed by the server’s name, separated by a space. Example: 192.168.1.10 OFFICESERVER
4. Save the file and close the editor.
5. Repeat on every workstation experiencing H202.

To find the server’s IP address, open a Command Prompt on the server computer and type ipconfig. Look for the IPv4 Address line under the active network adapter.

When H202 Persists

If you have confirmed hosting mode, scanned with the Database Server Manager, opened the correct firewall ports, run File Doctor, and verified name resolution — and workstations still cannot connect — the multi-user network setup has a deeper configuration problem. These can involve Windows network discovery settings, file-sharing permissions at the folder or drive level, conflicts with domain group policies, or issues with the network adapter configuration on the server. At that point, the setup requires hands-on network troubleshooting beyond what QuickBooks’ built-in tools can diagnose, and a qualified IT or network professional can resolve it so every user connects reliably.