Multi-User Fix: How to Turn Off Hosting on All QuickBooks Workstations

In a QuickBooks Desktop multi-user environment, only one single computer can host company files: the central server where the database files physically reside. When individual workstations inadvertently turn on hosting, they launch competing database processes that lock other users out and cause multi-user network errors like H101, H202, H303, and 6189.

Turning off hosting on every client workstation is the fundamental first step in troubleshooting any QuickBooks network failure. This guide explains how to audit your workstations, stop rogue hosting services, and configure your network so only the primary server coordinates multi-user access.

Fast-Fix: The 45-Second Solution

To disable hosting on any workstation, open QuickBooks Desktop without opening a company file. Click File > Utilities on the top menu. If the menu reads “Stop Hosting Multi-User Access,” click it, select Yes to confirm, and let QuickBooks restart. If the menu reads “Host Multi-User Access,” hosting is already turned off—leave it alone. Repeat this on every workstation in the office.

---

Quick Status & Triage Snapshot

• Data Risk Tier: Low. Modifying workstation hosting settings changes local program behavior; it does not delete or alter your underlying accounting records.
• Multi-User Impact: High. A single workstation with hosting turned on can lock the entire office out of multi-user mode.
• Common Trigger: A user clicking “Switch to Multi-User Mode” when prompted during an update, peer-to-peer file sharing misconfigurations, or improper terminal setup.
• Estimated Fix Time: 2–3 minutes per workstation.

---

Understanding Hosting: The Crucial Difference

Many users confuse these two menu options in QuickBooks Desktop:

1. “Switch to Multi-User Mode” (Safe for Workstations): This tells the local QuickBooks program: “I want to open this file alongside other people.” Every user who shares a company file must use this setting.
2. “Host Multi-User Access” (Server Only): This tells the computer: “I am the database server for the entire office.” When enabled on a workstation, it starts background database services (QBDBMgrN.exe) and attempts to take ownership of the shared .ND file.

To explore the operational differences between these two commands in depth, consult Hosting Guide: “Host Multi-User Access” vs. “Switch to Multi-User Mode”.

---

Diagnostic Flowchart: Workstation Hosting Audit

[Start: Performing Multi-User Hosting Audit on Workstation]
       |
       v
Open QuickBooks Desktop (No Company Open screen).
Navigate to: File > Utilities
       |
       v
What does the menu option display?
  |
  |-- "Stop Hosting Multi-User Access"
  |     \--> Hosting is currently ON (INCORRECT for a workstation).
  |          Action: Click "Stop Hosting Multi-User Access" > Confirm "Yes."
  |
  \-- "Host Multi-User Access"
        \--> Hosting is currently OFF (CORRECT for a workstation).
             Action: Do not click it. Move to the next workstation.

---

Step-by-Step Procedure: Disabling Hosting on Workstations

Step 1: Perform the Workstation Audit

Go to every computer in your office that runs QuickBooks, excluding the dedicated server.

1. Close any open company files to return to the No Company Open screen.
2. Click File on the top menu bar.
3. Hover over Utilities.
4. Carefully read the text displayed:
   • If you see Stop Hosting Multi-User Access:
     • Click it.
     • A dialog box will state: “Stop hosting multi-user access closes the company file and turns off multi-user access on this computer. Are you sure…?”
     • Click Yes.
     • QuickBooks will briefly close and re-open background processes.
   • If you see Host Multi-User Access:
     • This means hosting is already disabled on this machine.
     • Do not click it. Leave the menu untouched.
5. Exit QuickBooks on that workstation and proceed to the next machine.

For scenarios where an individual machine continues to revert to hosting mode, see QuickBooks Error H101: How to Fix “Workstation is Hosting the File”.

---

Step 2: Stop and Disable Stray Windows Services on Workstations

Sometimes a workstation’s Windows background services continue trying to host the database even after hosting is turned off in the application menus.

1. Press Windows Key + R, type services.msc, and press Enter.
2. Scroll through the services list and look for the QuickBooks Database service corresponding to your installed version:
   • QuickBooks 2024: QuickBooksDB34
   • QuickBooks 2025: QuickBooksDB35
   • QuickBooks 2026: QuickBooksDB36
3. If this service is present and says Running on a workstation:
   • Right-click the service and select Properties.
   • Click the Stop button.
   • Change the Startup type drop-down to Disabled (or Manual).
   • Click Apply and then OK.
4. Locate the service named QBCFMonitorService:
   • Right-click it and select Properties.
   • Ensure its Startup type is set to Automatic so the machine can still find the server over the network, but verify that it is not actively hosting local files.

---

Step 3: Re-Verify the Dedicated Server

Once all workstations are confirmed to have hosting turned off, verify that the central server has hosting turned on.

1. Go to the primary host computer or dedicated server holding the .QBW file.
2. If full QuickBooks Desktop is installed on the server:
   • Open QuickBooks and check File > Utilities.
   • It must read Stop Hosting Multi-User Access (confirming that hosting is turned on).
   • If it reads Host Multi-User Access, click it to activate server-side hosting.
3. If the server only runs the QuickBooks Database Server Manager:
   • Open services.msc on the server.
   • Ensure the QuickBooksDBXX service is Running and set to Automatic.
   • Restart the database service using the steps in Manual Reset: How to Restart QuickBooks Database Services (dbmgr.exe).

---

Step 4: Refresh the Network Data (.ND) Files

If multiple workstations were previously hosting the file, the .ND file in the company folder is likely corrupted with conflicting IP addresses.

1. On the server, navigate to the folder where the company file is stored.
2. Locate the .ND file matching your company name (e.g., MyCompany.qbw.nd).
3. Right-click the .ND file and choose Delete.
4. Open the QuickBooks Database Server Manager from the Windows Start menu on the server.
5. On the Scan Folders tab, add your company folder and click Start Scan.
6. The Database Server Manager will scan the folder and generate a clean .ND file configured strictly with the server’s network parameters.

---

When Multiple PCs Still Try to Act as the Server

In peer-to-peer setups (where there is no dedicated server, and one user’s desktop computer doubles as the host), users often turn on hosting when opening the file in the morning, which breaks access for everyone else.

If this happens regularly in your office:

• Set up a dedicated machine or virtual server running only the QuickBooks Database Server Manager.
• Set Windows folder permissions so workstation users have Read/Write access to the company file directory, but lack permission to modify local registry hosting keys.
• If hosting conflicts continue to recur across multiple computers, review the network repair strategies in Hosting Conflicts: Resolving Errors When Multiple PCs Act as the Server.

---

Closing the Books

Multi-user QuickBooks environments require a single, clear source of hosting authority. By turning off hosting on all workstations and letting only the central server manage the database, you eliminate the competing services that cause H-series errors. Following these steps restores clean, stable connections across your network while keeping your underlying company files protected.