Overview
QuickBooks Desktop won't open the company file in multi-user mode and reports “QuickBooks is unable to open this company file… (H202)”.
H202 means the workstation can see the file but cannot talk to the QuickBooks database service on the computer hosting it. It's a networking problem, not a damaged company file.
Likely cause
- The QuickBooksDBXX database service isn't running on the host computer.
- Windows Firewall is blocking QuickBooks ports on the host.
- Hosting is switched off on the host, or switched on in the wrong place.
- The workstation can't resolve the host computer's name.
- Different QuickBooks Desktop years or releases across machines.
Before you begin
- Know which computer hosts the company file — the one where the .QBW file physically lives.
- Have every user close QuickBooks before you start.
- Confirm all machines run the same QuickBooks Desktop year and release.
Always have a current backup of the company file before changing multi-user settings.
Create one from the host with File → Back Up Company → Create Local Backup.
Step-by-step
Step 1 — Check hosting is on — on the host only
On the host computer, open QuickBooks and check File → Utilities. It should read Stop Hosting Multi-User Access (meaning hosting is currently on).
On every workstation, the same menu should read Host Multi-User Access — hosting must be off there. Two hosts is a classic cause of H202.
Step 2 — Confirm the database service is running
On the host, press Windows + R and run:
services.mscFind QuickBooksDB32 (or DB33/DB34 for your version), set Startup type to Automatic, and start or restart it.
Step 3 — Run the QuickBooks Database Server Manager
On the host, open QuickBooks Tool Hub → Network Issues → QuickBooks Database Server Manager, and scan the folder containing the company file. Rescan after any change to the folder location.
Step 4 — Test name resolution from the workstation
From the workstation's Command Prompt, using the host's computer name:
ping SERVERNAMENo reply, or a reply from an unexpected address, means the workstation can't reliably find the host. Continue to Step 5.
Step 5 — Add the host to the workstation's hosts file
Editing the hosts file affects all name lookups on that PC.
Change only the line you add, and keep a copy of the original file.
Open Notepad as Administrator and edit this file, adding the host's IP address and computer name on a new line:
C:\Windows\System32\drivers\etc\hosts192.168.1.20 SERVERNAMEStep 6 — Allow QuickBooks through the firewall on the host
Add inbound rules for the QuickBooks ports for your version, plus the QuickBooks programs themselves.
| QuickBooks Desktop | Ports |
|---|---|
| 2024 | 8019, XXXXX (dynamic) |
| 2023 | 8019, XXXXX (dynamic) |
| 2022 | 8019, XXXXX (dynamic) |
| Programs to allow | QBDBMgrN.exe, QBW32.exe, QBGDSPlugin.exe, QBCFMonitorService.exe |
The Database Server Manager's Port Monitor tab shows the dynamic port your installation actually uses.
Step 7 — Retest from a workstation
Open QuickBooks on a workstation and browse to the company file using the host's IP address rather than its name — for example \\192.168.1.20\QBData. If that works but the name doesn't, the fault is name resolution, not QuickBooks.
Expected result
Every workstation opens the company file in multi-user mode, and File → Utilities on the host still reads Stop Hosting Multi-User Access.
Troubleshooting
Still stuck?
If you'd rather not work through this yourself, CYBER904 can take it from here. Reach the team directly during business hours and we'll get it sorted.