Fact-CheckedMaster Level

QuickBooks Desktop Multi-User (Client–Server) on a LAN

Updated: October 26, 2025
35 minutes read
15 sections
QuickBooks Desktop 2024QuickBooks Desktop 2023QuickBooks Desktop 2022

Scope

This guide covers the classic office deployment of QuickBooks Desktop in multi-user mode over a local network (LAN) without Remote Desktop Services. One Windows server (or designated host PC) stores the company file; multiple Windows workstations open it concurrently across the network.

What "Client–Server Multi-User" Really Means

In QuickBooks Desktop multi-user mode, you have one machine acting as the host (the server) and several client PCs. The host stores the live company file (.QBW) and runs the QuickBooks Database Server Manager (QBDBMgrN), which coordinates safe, simultaneous access. The clients run the QuickBooks application and open the same .QBW file via a network path. Only the host should be "hosting." Workstations must not host; this "one host, many clients" rule prevents the common H-series errors (H101/H202/H505). [1]

Why This Model Works Best on a LAN

Keeping the live .QBW on a Windows host's local NTFS drive, then sharing it to workstations, gives predictable file locking and performance. Storing the live file on a generic NAS or non-Windows network share is discouraged because it leads to intermittent disconnects, lockups, and H-errors. [1]

A Typical Small-Office Scenario

Host:
Windows Server 2016/2019/2022, fully patched, with a data folder like D:\QBData.
Clients:
Windows 11 (or Windows 10 while still supported by Microsoft), each running the same QuickBooks year as the host. Intuit's current tech specs provide practical RAM guidance (e.g., ≈ 8 GB for ~5 users, 12 GB for ~10, 16 GB for ~15, 20 GB for 20+). [5]
Network:
Gigabit Ethernet recommended, reliable DNS, and users sign into Windows with named accounts that have permissions to the shared data folder.

Plain-English Network Picture

Imagine a labeled filing cabinet (D:\QBData on the host) in a locked room (Windows permissions). Each employee has a key (their Windows account). QuickBooks' Database Server Manager is the librarian who ensures two people don't grab the same folder at once.

Terminology You'll See Once (So Everything Else is Easy)

.QBW – your live company file. Treat like a database: fast local disk, regular backups.
.TLG – transaction log. This grows during the day and helps with recovery. Back it up with the .QBW.
.NDNetwork Data file created next to the .QBW. It tells workstations which host and port to use for that company. If it goes bad, you can safely delete/regen it by rescanning or opening the file once on the host. [1,2]
Hosting – QuickBooks setting that turns the host into the "traffic controller." It must be ON only on the host and OFF on every workstation. [1]
Database Server Manager (DBSM) – the Windows service(s) (QBDBMgrN) that manage multi-user access.

What You'll Need (At a Glance)

A supported Windows host (Server 2016/2019/2022) and client PCs (Windows 11/10 64-bit). [4,5]
QuickBooks Desktop installed on the host and clients (same year on every machine).
Admin rights on the host to set share and NTFS permissions.
The Database Server Manager installed on the host and pointed (scanned) at your data folder. [2]
Windows Firewall rules opened for the year-specific dynamic port and for QBCFMonitorService (TCP 8019). [3]

Step-by-Step on the Host (Do This Once)

  1. 1
    Create a clean data path and share it
    1. Create D:\QBData.
    2. Share it as \\HOST\QBData.
    3. Grant your accounting users/groups Modify on the share.
    4. On NTFS, grant those same users Modify and ensure the QuickBooks service account (e.g., QBDataServiceUserXX) has access. Using Full Control for that service account is acceptable when in doubt. [1]

    Share vs NTFS in Plain English

    The share permission is the "front door lock." NTFS is the lock on the filing cabinet inside. Users need keys to both.
  2. 2
    Install the Database Server Manager (DBSM)

    Run the QuickBooks installer on the host → choose Custom or Network Options → pick the option that matches your plan:

    "I'll be using QuickBooks Desktop on this computer, and I'll be storing our company file here …" (host + occasional admin use), or
    "I will NOT be using QuickBooks Desktop on this computer." (pure database host).

    This installs the QBDBMgrN services and the tools you need for LAN hosting. [2]

  3. 3
    Scan the data folder (creates/maintains the .ND)

    Open QuickBooks Database Server ManagerScan Folders → add D:\QBData and scan. This seeds or refreshes the .ND file with the host name and port for each company file. [2]

  4. 4
    Open the right firewall rules once (and be done)
    In DBSM → Port Monitor, note the dynamic TCP port for your QuickBooks year (2019+ uses a unique port per year). Create inbound (and, if needed, outbound) Windows Firewall rules for that port.
    Also allow QBCFMonitorService, which uses TCP 8019. If you run multiple QuickBooks years on the same host, you'll have one dynamic port per year (and one .ND per company/year). [3]

    Don't Guess Ports

    Always read them from Port Monitor so you open exactly what QuickBooks needs, no more, no less. [3]
  5. 5
    Place the company file and seed the .ND

    Copy Company.qbw (and its .tlg, etc.) into D:\QBData. Launch QuickBooks on the host, open the company in multi-user mode once, then close it. This puts a fresh .ND next to the file that points clients to the correct host/port. [1,2]

  6. 6
    Turn hosting ON only on the host

    In QuickBooks on the host, go to File → Utilities. The menu should show "Stop Hosting Multi-User Access" (meaning hosting is enabled). If you see "Host Multi-User Access", click it to turn hosting on. [1]

Step-by-Step on Each Workstation (Clients)

  1. 1
    Install the same QuickBooks year

    [1]

  2. 2
    Ensure hosting is OFF

    In File → Utilities, ensure you see "Host Multi-User Access" (available). If you see "Stop Hosting …", click it—workstations must not host. [1]

  3. 3
    Open the company file from the network

    Open the company file from \\HOST\QBData\Company.qbw (or map a drive that points to the same share). Check "Open file in multi-user mode" the first time.

  4. 4
    Verify concurrent access works

    Verify two people can work at once (if you try to Switch to Single-User Mode, QuickBooks should warn others are connected—that's expected).

UNC vs Mapped Drive

UNC (\\HOST\QBData\…) is explicit and avoids letter conflicts. Mapped drives are fine if consistent, but they still resolve to UNC under the hood. If a workstation says "can't find the path," test with ping HOST and fix DNS or the mapping.

Deep-Dive: Permissions That Actually Work (and Why)

QuickBooks needs to read and write the .QBW, create/update the .TLG transaction log, and maintain the .ND network descriptor. That means Modify on both the share and NTFS is the safe default. If you do per-user permissions:

Put users in an Accounting Windows group and permit the group (easier to manage than individuals).
Avoid "Deny" ACEs; they override "Allow."
Confirm the QuickBooks service account (QBDataServiceUserXX) has access (Full Control is fine). [1]

How to Verify Quickly

From a workstation, create a test text file in \\HOST\QBData and delete it. If either action fails, fix share/NTFS permissions before you involve QuickBooks.

Firewalls and Ports (Why They Matter and How to Set Them Once)

QuickBooks Desktop (2019+) uses a year-specific dynamic port. The Database Server Manager publishes which port belongs to which year. Workstations contact the host using that port plus QBCFMonitorService on 8019. If firewalls block these, you'll see H-errors and connection timeouts.

Steps You'll Perform Only Once on the Host

  1. 1
    Check Port Monitor

    Open DBSM → Port Monitor → read the port for your year.

  2. 2
    Create firewall rules

    Create Windows Firewall rules for that port (TCP) and for 8019.

  3. 3
    Add program exceptions

    If you also run endpoint security/AV, add the QuickBooks executables from Intuit's list as program exceptions. [3]

Sanity Tests (No Tools Required)

From a workstation, ping HOST by name and then by IP. Name-fail but IP-success = DNS problem. Fix DNS or add a temporary HOSTS entry.
Use \\HOST\QBData in File Explorer. If browsing is slow or fails, fix networking before blaming QuickBooks.

Ten-Minute Go-Live Checklist

Use Literally at Cutover

Follow this checklist during your go-live to ensure everything is configured correctly.

  1. 1.Host patched; D:\QBData created and shared.
  2. 2.DBSM installed; Scan Folders completed for D:\QBData. [2]
  3. 3.Port Monitor checked; firewall rules for dynamic port and 8019 created. [3]
  4. 4.Company placed in D:\QBData; opened once on host in multi-user; .ND regenerated. [1,2]
  5. 5.Hosting ON on the host; OFF on all workstations. [1]
  6. 6.Two workstations open the same file concurrently via UNC.
  7. 7.Basic name/IP pings pass; file operations in \\HOST\QBData succeed from clients.

Troubleshooting H-Series (H101/H202/H505) Without Guesswork

Follow Intuit's current checklist and you'll resolve almost every case:

Hosting only on the host. If any workstation is hosting, turn it OFF. [1,4]
Services running. Ensure QuickBooksDBXX (XX = year) and QBCFMonitorService are present and running on the host. [4]
Open the right ports. Use Port Monitor (dynamic port per year) and allow 8019. Don't hard-code random ports. [3]
Name resolution. ping HOST must work by name; if not, fix DNS or mappings. [4]
Rebuild the .ND. Delete/rename it, rescan in DBSM, or open the file once on the host to regenerate. [2,4]
Automated help when stuck. Run QuickBooks Tool Hub → File Doctor on the host; it checks hosting, firewall, and name resolution and proposes fixes. [4]

Clue-Based Fixes

Error mentions H202/H505 immediately → usually hosting/ports/name resolution.

Can browse \\HOST\QBData but opening the company stalls → check .ND and DBSM service for the correct year.

Works by IP but not by name → DNS/WINS/hosts problem.

Ongoing Care and Feeding

The boring stuff that prevents outages:

Backups: Back up .QBW and .TLG nightly (after hours). Test a restore monthly.
Patching: Keep Windows and QuickBooks updated. After a QuickBooks year upgrade, reinstall or update DBSM on the host and rescan folders. [2]
Capacity: Watch free disk space and RAM on the host. If the .TLG grows very large, run a verified backup in QuickBooks to truncate it.
Change control: When changing antivirus, printers, or network settings, plan a small maintenance window and retest multi-user afterward.

Common Pitfalls and How to Avoid Them

NAS Temptation

Hosting the live .QBW on a NAS is a top cause of instability. Keep it on a Windows host's local NTFS disk. [1]

Random Ports

QuickBooks uses dynamic ports by year. Always read from Port Monitor; don't guess. [3]

Multiple QuickBooks Years

Each year has its own QuickBooksDBXX service and port. Make sure the correct year is installed on the host and the workstations that need it. [2,3]

"It Worked Yesterday!"

Check if someone toggled hosting on a workstation, a firewall/AV update tightened rules, or the .ND became stale. The five-step H-series flow above resolves most regressions. [4]

FAQ (Short and Practical)

Q: Do I really need the Database Server Manager if the file is on a Windows server?

A: Yes. DBSM manages locking, advertises the correct port, and maintains the .ND. Install it on the host and scan the folder. [2]

Q: Is a mapped drive required?

A: No. Use the UNC path (\\HOST\QBData\Company.qbw). Mapped drives are okay if consistent, but UNC avoids letter conflicts and clarifies which host you're using. [1]

Q: How do I know the right port?

A: Open DBSM → Port Monitor and read the year's dynamic port. Then create firewall rules for that port and for 8019 (QBCFMonitorService). [3]

Q: Which Windows versions are supported in 2025?

A: For QuickBooks Desktop 2024, Intuit lists Windows Server 2016/2019/2022 on the server side and 64-bit Windows on clients. Always check your exact year's system requirements. [4,5]

Q: What's the fastest way to prove multi-user is healthy?

A: Open the company on the host once (to refresh .ND), then open it from two workstations via UNC. Try to switch one workstation to Single-User; you should be warned another user is in the file.

Who Does What (Roles at a Glance)

IT/Server Admin

• Creates D:\QBData
• Sets share/NTFS permissions
• Installs DBSM
• Opens firewall ports
• Maintains backups and updates

Accounting Lead

• Confirms who needs access
• Validates concurrent users work
• Reports H-errors with screenshots

All Users

• Always open from same UNC path
• Never change hosting settings
• Report any access issues promptly

Final Cutover Script

Read Aloud on Go-Live Day

Follow this script step-by-step during your cutover to ensure everything is working correctly.
  1. 1."Host is ready and scanning D:\QBData. Hosting is ON on the host and OFF on all PCs."
  2. 2."Firewall is open for the year's dynamic port and for 8019."
  3. 3."We'll open the company on the host once, then close."
  4. 4."Now each workstation opens \\HOST\QBData\Company.qbw in multi-user."
  5. 5."We confirm two people can edit simultaneously and that switching to Single-User warns about other users."
  6. 6."We run a small test: create a dummy vendor bill and delete it—on both workstations—so we confirm write permissions."

References

Conclusion

This definitive, fact-checked guide provides everything you need to successfully set up QuickBooks Desktop in multi-user mode on a LAN. By following these documented, official procedures, you can deploy a robust QuickBooks environment that supports concurrent users reliably.

Key Takeaways

One host, many clients—hosting ON only on the server
Database Server Manager is essential—scan folders and check Port Monitor
Don't guess ports or host on NAS—follow official Intuit guidance
All procedures verified against current official documentation

Need Professional Implementation?

For complex deployments or enterprise implementations requiring expert assistance, GME Inc. provides professional QuickBooks consulting services.

Contact GME Inc. for Professional Services