What we do
Tools
Industries
Department
How we workLet's talk →
Home/QuickBooks Desktop Multi-User Mode
QuickBooks Desktop

QuickBooks Desktop Multi-User Mode: Set It Up, and Stop the H202 Errors

Multi-user mode needs three things: the company file on one computer that hosts it, Database Server Manager running on that computer, and each user switching the file to multi-user. Most errors come from the first two. Here's the setup in order, then what each error is telling you.

The short version

On the computer that stores the file: install QuickBooks Database Server Manager and scan the folder the company file sits in.

Windows Start QuickBooks Database Server Manager Scan Folders

On each workstation: open the file from the shared folder, then switch it over.

File Switch to Multi-user Mode

Only one computer hosts. On every workstation, check that hosting is off. If the menu offers Stop Hosting Multi-User Access, that workstation is hosting and shouldn't be.

File Utilities

Setting up a multi-user network, in order

Do these on the server first, then on each person's computer. Skipping the server half is the most common reason the mode switch works for one user and fails for the next.

  1. 1

    Pick the host computer

    Choose the machine that will store the company file and stay switched on while anyone works. A wired network connection matters more than raw speed. Running the host over wifi is a common cause of slowness and dropped sessions.

    Watch for: a host that sleeps or restarts for updates during the day. Every user loses the file when it does.

  2. 2

    Install Database Server Manager on it

    Run the QuickBooks installer on the host and choose the network options. If nobody will work in QuickBooks on that machine, pick the option that only stores and shares the file. If someone will, pick the one that does both.

  3. 3

    Put the file in a shared folder and scan it

    QuickBooks Database Server Manager Scan Folders Add Folder Scan

    Keep the company file in a folder on the host's own drive, share that folder on the network, and give each user's Windows account full read and write access to it. Then add the folder in Database Server Manager and scan, so the file shows up under the list of company files found.

    Watch for: a file stored on a NAS or a synced cloud folder. QuickBooks needs the database server on the same machine as the file.

  4. 4

    Turn hosting off on every workstation

    File Utilities Stop Hosting Multi-User Access

    On each workstation, open QuickBooks and look under Utilities. If it says Stop Hosting Multi-User Access, select it. If it says Host Multi-User Access, that machine is already set right, so leave it.

  5. 5

    Open the file and switch modes

    File Switch to Multi-user Mode

    From each workstation, open the company file by browsing to the shared folder on the host, then switch to multi-user. The title bar shows which mode you're in. Some tasks, like verifying data or deleting list items, still need single-user mode, so you'll switch back for those.

  6. 6

    Give each person their own login

    Company Users

    Set up a QuickBooks user for each person, with only the access they need. Each person working at the same time also needs a seat on your license: Pro allows up to 3 users, Premier up to 5, Enterprise up to 40.

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.

Fix the local setup, or stop hosting it yourself?

Fix it locally

When the office server can still cope

  • Errors trace to the service, the firewall or a second host, not the file size.
  • Everyone who uses the file works in the office, on the wired network.
  • You're on a Desktop version that's still supported, and you plan to stay on it.
Move off local hosting

When the setup itself is the ceiling

  • The file keeps growing and the slowdowns come back after every fix.
  • People need the file from home, which local hosting doesn't do on its own.
  • Intuit no longer sells new Pro Plus, Premier Plus or Mac Plus subscriptions to new US customers. Existing subscribers can renew and Enterprise is still sold, but each release loses payroll, bank feeds and support at its discontinuation date.

If you're on the right side, the choice is hosted Desktop with an Intuit-authorized provider, or a move to QuickBooks Online, where every user logs in through the browser and there's no server to host. Our QuickBooks migration page covers what that move involves.

What this looks like in practice

Shopify retailer

Shopify to QuickBooks sync

A retailer's Shopify sales synced into QuickBooks as one number a day, and every month someone spent half a day working out why a payout didn't match. We rebuilt the sync to itemize by product category, use real product costs, and match each payout to the orders, fees and refunds behind it. The half-day reconciliation became a five-minute check.

Questions people ask

What causes an H202 or H505 error in multi-user mode?

The workstation can't reach the database server on the computer that hosts the file. Usually the QuickBooksDB service has stopped on the host, a firewall is blocking its ports, the folder was never scanned in Database Server Manager, or a second computer is also trying to host. The checks above go through each one.

How big can a QuickBooks Desktop company file get before multi-user mode breaks down?

There's no hard limit. Performance problems commonly start as a file approaches a gigabyte, and they get worse with more people working in it at the same time.

Is hosted QuickBooks a better option than local multi-user mode?

Sometimes. Hosted Desktop with an Intuit-authorized provider removes the office server and lets people work from anywhere, at a monthly cost. It makes most sense when local hosting keeps failing or your team isn't all in one place. If the fault is just a stopped service or a firewall rule, fixing it locally is cheaper.

How many people can use QuickBooks Desktop in multi-user mode?

Pro allows up to 3 users, Premier up to 5 and Enterprise up to 40. Each person working at the same time needs a seat on the license, and their own QuickBooks login.

Do workstations need QuickBooks Database Server Manager too?

No. It runs on the computer that stores and hosts the company file. Workstations only need QuickBooks itself, with hosting turned off.

Who can fix multi-user mode for us?

n-frames works through the host, the network and the file: the service, the firewall rules, the folder permissions and the file size. If local hosting has hit its limit, we set up hosted Desktop or plan the move to QuickBooks Online instead.

Is the quote for fixing multi-user mode really free, with no obligation?

Yes. We look at what's happening, explain the cause and what the fix costs. Whether you go ahead is up to you.

Let's talk

Tell us the one thing your team does manually that eats up time. We read every message and reply within a day.