Quick answer

QuickBooks multi-user setup means one computer hosts the company file and the others connect to it over your local network. Install QuickBooks in Custom and Network mode, share the company-file folder with full permissions, scan it in QuickBooks Database Server Manager, enable hosting on the server only, then set up each workstation and test the connection. Do the steps in order — most multi-user failures come from skipping the scan or letting a second computer host.

What QuickBooks multi-user mode requires

Three conditions must be true before a workstation can open the company file: Windows file permissions give the logged-in user full control of the folder, the database server can open the file, and every user has a QuickBooks login and password. If any one of the three fails, the file will not open in multi-user mode even when the network itself looks healthy.

QuickBooks also depends on a small helper file. The .ND file (the network data file QuickBooks creates next to the company file) stores the host address and port. Database Server Manager writes it when it scans the folder, and workstations read it to locate the host. That is why a server that changes IP address overnight breaks multi-user access even though the shared folder still opens in File Explorer.

Pre-flight checklist

  • Administrator rights on the server and every workstation.
  • The same QuickBooks version and year on the server and all workstations, activated and updated to the same release.
  • One computer chosen as host, with agreement that it stays on during working hours.
  • A wired network for the host and any busy workstation; Wi-Fi drops long database sessions.
  • A plain local or server folder for the company file — not a NAS device, not OneDrive, Dropbox or Google Drive. Database Server Manager does not support NAS, and cloud-sync folders lock the file intermittently.
  • Free disk space for the company file and its backups, plus a tested copy of the file saved off the machine.
  • The product and license number ready for installation.
  • A maintenance window of roughly two hours for the server and a few minutes per workstation.

Choosing the server and sizing it

For two to five users, the fastest workstation can host in a peer-to-peer setup, but it must stay on and stay awake. For six or more users, or any QuickBooks Desktop Enterprise file, use a dedicated computer that only stores and shares data. Intuit's guidance for a peer-to-peer host is plain: it should be the fastest machine on the network.

Match the hardware to the published system requirements for your version, then spend on the parts that matter. The bottleneck in daily use is disk and network, not the processor: an SSD and a wired gigabit connection do more for responsiveness than extra memory. Intuit's own network test copies a 150 MB file and expects at least 40 Mbps of throughput. Reach the share with the UNC path (\\ServerName\ShareName) instead of a mapped drive letter, because Windows can reassign letters after a restart.

Keep one host per version of QuickBooks. Hosting is configured per computer and per QuickBooks version, so a server running two years side by side hosts each independently — and each needs its own scan and firewall rules.

Back up before you change anything. Copy the entire company-file folder — .QBW, .TLG, .ND and .DSN together — to an external drive. Installations, permission changes and scans are safe when done correctly, but the folder copy is your recovery point if a step goes wrong. Also write down the exact version and file path; you will need both later.

How to set up QuickBooks multi-user mode

1

Back up and record the current state

Copy the whole company-file folder to an external drive. Open the company file on the current computer, press F2 and write down the exact product name, year, release and file location. Note whether the file currently opens in single-user or multi-user mode, because that tells you what is already configured.

2

Install the server in the correct order

On the computer that will host, run the QuickBooks installer and choose Custom and Network Options, then the option that installs QuickBooks and stores the company file on this computer. Do not choose Express — that overwrites a previous version you may need for troubleshooting. If the network runs more than one year of QuickBooks, install the oldest version first and finish with the newest.

3

Create and share the company-file folder

Create a dedicated folder such as C:\QBData and move the company file into it. Right-click the folder, open Properties, and on the Sharing tab use Advanced Sharing to share the folder with a short, clear name. On the Security tab, grant the Windows accounts that open QuickBooks Modify or Full control, and mirror those rights on the share permissions screen.

Test from a workstation by opening \\ServerName\ShareName in File Explorer before you touch QuickBooks. A share that fails here will fail for Database Server Manager too.

4

Give the QuickBooks service accounts access

Database Server Manager runs as a Windows service named QuickBooksDBXX and a Windows user named QBDataServiceUserXX, where XX matches the release (QuickBooks 2024 uses QuickBooksDB34 and QBDataServiceUser34). QBCFMonitorService is a separate service with its own account. Add these accounts to the folder's permissions with Modify rights; without them, the next step scans a folder and finds nothing.

5

Scan the folders with Database Server Manager

On the server, open QuickBooks Database Server Manager from the Start menu. On the Scan Folders tab, browse to the folder holding the .QBW file and select Start Scan. When it finishes, the file appears under QuickBooks company files found, and a companion .qbw.nd file appears in the folder.

On the Monitored Drives tab, select the drive that holds your data so files stay shared after they move. The dedicated Database Server Manager setup and repair guide covers the service tuning: set QuickBooksDBXX to start automatically and set the Recovery tab to restart the service on failure.

6

Enable hosting on the server only

Open QuickBooks on the server, go to File → Utilities, and select Host Multi-User Access. Confirm when prompted, then close and reopen the company file. Press F2 and check Local Server Information at the bottom of the Product Information window — Hosting should read local files only.

On every other computer, open File → Utilities and select Stop Hosting Multi-User Access if that option appears. Only one computer may host; a second host causes the floating-host errors H101, H303 and H505, which surface as failed logins rather than network faults.

7

Install QuickBooks on each workstation

Install QuickBooks on every workstation with Custom and Network Options and choose the workstation option — the one that does not store the company file. Use the same version, year and release as the server; mixed years only work when each file is served by a matching database service. The QuickBooks Desktop installation guide covers activation and update order. Restart each workstation once after the install so Windows services settle.

8

Connect from a workstation and allow the firewall

On a workstation, open QuickBooks and browse to the file over the network using \\ServerName\ShareName\CompanyName.qbw, or map the share first. Sign in with the QuickBooks user account and switch to multi-user mode. If the connection is blocked, add the QuickBooks programs and ports to Windows Defender Firewall on the server using the firewall and ports guide. Database Server Manager also repairs firewall permissions automatically when it scans, so rerunning the scan is a fast first check.

Testing the setup before you go live

  1. Open the company file on the server, press F2, and confirm Local Server Information shows hosting local files only.
  2. Open the same file from one workstation, switch to multi-user mode, and confirm it opens without an error.
  3. Open the file from a second workstation at the same time to prove concurrent access.
  4. Post a small test invoice or bill, save it, then delete it and refresh the other computers to confirm the change appears everywhere.
  5. Create a backup from a workstation, which proves write access through the share.
  6. Leave the machines on overnight and reconnect in the morning. A host that sleeps or loses its IP address shows up here, not during the workday.

Ongoing rules that keep multi-user mode working

  • The server stays on and never sleeps or hibernates during working hours. Give it a static IP address or a DHCP reservation so the .ND file keeps pointing at the right place.
  • One host, always. After any reinstall, restore or migration, recheck hosting settings on every computer.
  • Back up nightly and test a restore each quarter. A shared folder is not a backup.
  • Keep versions matched. Update the server first, then the workstations, during a window when nobody is posting transactions.
  • Keep the data folder out of cloud sync and off NAS devices. If the business is outgrowing its network, review the Enterprise network performance guide before buying hardware.

If workstations still cannot connect

When one workstation fails while others work, check that computer first: its hosting setting, its mapped drive and its firewall profile are the usual culprits. Rename the .ND file on the server, rerun the scan and recheck hosting on every machine. Persistent connection failures with an H code point at the multi-user network rather than the file; the Error H202 fix guide and the Network Diagnostic tool both narrow the cause quickly. If errors follow a hosting change, start with the hosting mode guide.

Before you escalate, confirm the server's IP address has not changed, that the Windows user who configured QuickBooks is still logging in, and that no workstation is hosting. These three checks explain most repeat failures.

Frequently asked questions

Can the host computer also be used as a workstation?

Yes. A peer-to-peer setup lets the host run QuickBooks for one user while serving the file to others, provided the machine stays on and is fast enough. For six or more users, or for QuickBooks Desktop Enterprise files, a dedicated host gives more predictable performance.

Does QuickBooks need to stay open on the server?

No. In Hosting Local Files only mode, Database Server Manager runs as the Windows service QuickBooksDBXX, so the company file stays shared while QuickBooks itself is closed. The computer must stay powered on, and the Windows user who set up QuickBooks should remain logged in so the service account keeps working.

Why does multi-user mode turn off after a restart or update?

Hosting is set per computer and per QuickBooks version, and in Hosting Local & Remote files mode it runs under the logged-in user, so it stops at logoff. If the option disappears, restart QuickBooks, re-enable Host Multi-User Access on the server, and verify the service QuickBooksDBXX is running in services.msc.

Can I store the company file on a NAS or in OneDrive?

No. Intuit states that Database Server Manager does not support NAS devices, and consumer sync folders like OneDrive, Dropbox and Google Drive lock the file intermittently. Keep the .QBW file on a local disk or a properly shared server folder, and use the cloud only for backup copies.

Sources & further reading