H202, H505 and the other ways multi-user mode breaks
The H-series errors (H101, H202, H303, H505) all mean the same thing in different words: the workstation found the file but can't reach the database server that hosts it.
Database Server Manager stopped, or never scanned the folder
How you'll know: H202 or H505 on every workstation at once, often after a server restart or a QuickBooks update.
Fix: On the host, open Windows Services and check that the QuickBooksDB service for your version (named QuickBooksDB plus a number) is running and set to start automatically. Then rescan the folder in Database Server Manager. After a QuickBooks update, update Database Server Manager on the host too.
A firewall is blocking the connection
How you'll know: Workstations can see the shared folder in Windows, but QuickBooks still throws H202.
Fix: Database Server Manager lists the ports it's using for your version. Allow those ports, and the QuickBooks programs, through Windows Firewall and any security software on the host. Check from a workstation that you can reach the host by its computer name, not just its IP address.
Two computers both think they host
How you'll know: The file opens for some users and not others, or locks people out at random.
Fix: Hosting should be on the server only. Check File, Utilities on every workstation and stop hosting anywhere it's on.
The file has outgrown the machine
How you'll know: No error, just slow. Reports crawl, saving an invoice takes seconds, and it gets worse as more people log in.
Fix: Slowdowns commonly start as a file nears a gigabyte, especially with several users at once. Check the host's memory and disk first, then look at condensing the file or moving it to a host built for the load. A file that also crashes or freezes needs the checks on our crashing and freezing page.