QuickBooks error H202: restoring multi-user access to a company file

Error H202 stops QuickBooks Desktop from opening a company file in multi-user mode; this guide restores access from every workstation on your network.

Error H202 appears when a workstation tries to open a company file that QuickBooks knows lives on another computer. The connection to the hosting service fails, and QuickBooks offers a recovery mode or stops entirely. Our engineers clear most cases in three moves: confirm the host, rescan the folder with Database Server Manager, and open the firewall ports.

Error H202, in plain terms

Multi-user access in QuickBooks Desktop is client-server. One computer, the host, runs the QuickBooks database service and serves the company file. Every other machine connects to that service across the network. H202 means the machine you are sitting at is not the host, and it cannot reach the one that is.

Three faults account for most cases. The host has lost track of the file, two machines each believe they are the host, or a firewall on the host is blocking the database service. Work through them in that order.

Before you start

Close QuickBooks on every machine, including the host. Take a fresh backup of the company file and store it away from the server. The scan does not alter your data, but network work of this kind deserves a recent backup anyway. Sign in to the host with a Windows administrator account. If someone keeps working during the fix, the results will mislead you.

Which computer should host the file?

The company file lives on one machine. That machine, and only that machine, should have hosting switched on. On each computer, open the File menu and choose Utilities. If Utilities offers Host Multi-User Access, hosting is off there. If it offers Stop Hosting Multi-User Access, hosting is on.

Exactly one computer should show the Stop option: the one holding the file. On any other machine, choose Stop Hosting and accept the restart prompt. A workstation that starts hosting by accident is a common trigger, because two competing hosts confuse every copy of QuickBooks on the network.

Rescan the folder with Database Server Manager

On the host, open the Start menu and type database server manager. Launch the QuickBooks Database Server Manager for your version. On the Scan Folders tab, choose Add Folder and select the folder that holds the .QBW file, or its parent if the file sits deeper down, then choose Scan.

The scan takes a few minutes. When it finishes, the results should list your company file with its full network path. The scan registers the file with the database service and rewrites the small .ND network descriptor files that sit beside it. If the list comes back empty, the folder is wrong or permissions are blocking the service account. Share the folder properly and run the scan again.

Find and open the firewall ports

The host firewall must let the database service through. The QuickBooks connection monitor uses TCP port 8019. The database service for your version listens on a second port that the installer assigns dynamically. That port differs between version years, so read it off the machine rather than guessing.

Open Task Manager on the host and switch to the Details tab. Find the database service program, usually named QBDBMgrN.exe, and note its process ID. Then open a command prompt as administrator and run netstat -ano. Match the process ID to a line marked LISTENING and note that TCP port. Resource Monitor works too: its Listening Ports table shows the program and the port in one row.

Now open Windows Defender Firewall with Advanced Security and create a new inbound rule. Choose Port, and allow TCP on 8019 plus the port you just found. Limit the rule to the Domain and Private profiles. A third-party antivirus with its own firewall ignores Windows rules, so add the same port there as well. Allowing the program itself, not just the port, is the sturdier arrangement in our experience.

Open the file across the network

From a workstation, reach the file by network path rather than a mapped drive. In QuickBooks, choose File, then Open or Restore Company, and open a company file. Type two backslashes, the host name, the share name, then the file name, for example \server\accounting\company.qbw. Mapped drive letters can fail quietly under different Windows credentials, and the direct network path removes that variable.

Signs the fix worked

The file opens with no H202 and no prompt to switch modes. Two machines hold it open at the same time. On a workstation, File then Utilities now offers Host Multi-User Access, which confirms that machine is not hosting. The Database Server Manager scan list on the host still shows the file. When all four hold, the repair is complete.

If H202 comes back

Some cases run deeper than this workaround reaches. Name resolution can fail even with ports open, so test by pinging the host by name from a workstation. Stale .ND files, mixed release levels between machines, or a host straddling several network segments can all reproduce the error. If the file now refuses to open on the host itself, the fault is no longer a network one. Our QuickBooks error code repair service handles that file-level work directly. Keep the backup you made, whatever comes next.