The Hosting feature in QuickBooks allows workstations to use files saved on the host system. The host system includes the company file. When the hosting feature is deactivated or configured incorrectly, QuickBooks displays the following error:
Hosting Mode is Off
This issue often arises when QuickBooks fails to respond in multi-user mode. Consequently, workstations fail to use or change the company file.
Usually, the message, “Hosting Mode is Off,” is displayed on the window. This happens when the user tries to access the multi-user setup. Due to this error, access is blocked for users, triggering confusion.
In this guide, the reasons and solutions for the error are explained. Follow the steps outlined in this guide to activate multi-user mode and resolve the issue.
Understanding QuickBooks Hosting Modes
Before diving into troubleshooting, it’s essential to understand QuickBooks Hosting-the process that allows multiple users to access a company file simultaneously over a network.
What Does Hosting Mode Off Mean?
The error message “QuickBooks Hosting Mode is Off” appears when a workstation attempts to access the company file in a multi-user environment, but the dedicated server or host computer is not properly configured to share the file, or a network service has failed.2
In simple terms, it means the server that holds the main QuickBooks company file is currently refusing or unable to act as the “host,” thereby blocking all other users (workstations) from connecting to the data file (.QBW).
- Impact: This issue prevents users from switching to Multi-User Mode, leading to workflow disruption and the inability for teams to collaborate on the financial data.
The Three Hosting Modes in QuickBooks Desktop
Hosting is a setting tied to the QuickBooks Database Server Manager installed on each computer.3 A system can be in one of three distinct modes, but only one computer (the server) should be set to host the file:
| Hosting Mode | Purpose and Function | Appropriate Computer |
| 1. Not Hosting | The computer runs QuickBooks but cannot serve the company file to other users on the network. This is the default and correct setting for all client workstations. | Workstations |
| 2. Hosting Local Files Only | The computer acts as the server, hosting the company file, but only for files stored physically on its own hard drive. | Dedicated Server |
| 3. Hosting Local and Remote Files | This is the most complex mode, allowing the computer to host files stored on itself and files stored on another network device (though this setup is rare and discouraged). | Dedicated Server |
The Goal: To resolve the “Hosting Mode is Off” error, you must ensure that only the server is set to either “Hosting Local Files Only” or “Hosting Local and Remote Files,” and that all other client computers are correctly set to “Not Hosting.”
🚫 Causes of the QuickBooks Hosting Mode Error
The error typically arises from misconfigurations or interruptions that block network communication between the server and the workstations:
Sudden erasing of crucial QuickBooks files.
- Incorrect Hosting Settings: The hosting mode is set incorrectly on either the server (where it should be active) or on the client workstations (where it should be off).
- QuickBooks Installation Issues: QuickBooks is either unavailable or wrongly configured on the host system, failing to properly initiate the necessary services.
- Security Restrictions: Your Antivirus or Firewall software is actively restricting QuickBooks’ ability to communicate over the network.
- Corrupted Network Descriptor File: The
.ND file(network data file), which helps QuickBooks locate the company file, is corrupted. - Service Failure: The QuickBooks DBXX service (QuickBooks Database Server Manager service) required for hosting multi-user access failed to start or is not running.
- Missing Database Manager: The QuickBooks Database Server Manager is not installed on the system that is supposed to act as the host.
- Permissions Problems: Inadequate Windows file permissions prevent the QuickBooks Database Server Manager user (
QBDataServiceUserXX) from accessing the company file folder. - Network/IP Resolution: The IP address of the host system cannot be detected by multi-user hosting across the network.
- Company File Access: The database server cannot access the company file itself.
- System Corruption:
- Sudden system shutdown (like an abrupt power failure).
- Wrong Windows registry entries due to unsuccessful installation or software modifications.
🛠️ Step-by-Step Solutions to Enable Hosting Mode: Overview
The process of fixing the “QuickBooks Hosting Mode is Off” error involves a systematic troubleshooting approach, moving from the simplest checks to the most complex system and network repairs. Since the error is usually caused by network permissions or service failures, you should follow these phases in order until the issue is resolved:
- Phase 1: Verify Initial Settings (Quick Fixes): Start by confirming that the hosting mode is correctly set (ON for the server, OFF for all client workstations) and that essential QuickBooks and Windows services are running.
- Phase 2: Use Official Troubleshooting Tools: Employ Intuit’s dedicated utilities, such as the QuickBooks File Doctor and the QuickBooks Database Server Manager, to automatically scan, diagnose, and repair network or file-related issues.
- Phase 3: Deep System and Network Checks: If the tools fail, the problem is deeper. This phase involves manually adjusting restrictive settings, including Windows Folder Permissions, Firewall Exceptions, and critical Windows Hosts File network configurations.
- Phase 4: Advanced/Final Steps: Reserve the most disruptive solutions, like assigning Admin rights to service users or performing a clean reinstallation of QuickBooks, for when all other steps have been exhausted.
By proceeding sequentially, you minimize the risk of unnecessary system changes and maximize the chances of quickly restoring multi-user access.
🚀 Phase 1: Verify Initial Settings (Quick Fixes)
These steps are the fastest and least disruptive ways to resolve the “Hosting Mode is Off” error.
1. Check Hosting on Server and Workstations
The primary cause of this error is having the wrong computer designated as the host. Hosting must be ON only on the server/host computer and OFF on all workstations.
A. Verify Hosting Status on the Server (Host Computer)
- Sign in to the server computer using your Admin login details.
- Open the QuickBooks program.
- Go to the File tab, hover over Utilities.
- If you see the option Host Multi-User Access, click it to enable hosting.
- If you see Stop Hosting Multi-User Access, DO NOT click it, as hosting is already active (which is correct for the server).
B. Verify Hosting Status on Workstations (Client Computers)
- Open QuickBooks on the client workstation.
- Go to the File tab, hover over Utilities.
- If the option Stop Hosting Multi-User Access is displayed, click it to disable hosting on that workstation.
- If the option Host Multi-User Access is displayed, DO NOT click it, as hosting is already off (which is correct for the workstation).
- Repeat this process for all workstations.
2. Verify QuickBooksDBXX and QBCFMonitor Services
QuickBooks relies on two core Windows services to manage multi-user access. If these services aren’t running or are misconfigured, hosting will fail.
- Open the Run window by pressing Windows key + R.
- Type
Services.mscand press Enter. - In the Services list, find the QuickBooksDBXX service (where XX corresponds to your QuickBooks version, e.g., QuickBooksDB34 for 2024).
- Double-click the service to open its properties.
- On the General tab, ensure the Startup Type is set to Automatic.
- Ensure the Service Status is set to Running. If it’s not, click the Start button.
- Go to the Recovery tab and set the actions for First failure, Second failure, and Subsequent failures to Restart the Service.
- Click Apply, then OK.
- Perform the exact same steps (1-8) for the QBCFMonitorService.
- Restart QuickBooks on all systems and try switching to Multi-User Mode.
3. Enable Network Discovery and File Sharing
To ensure seamless communication between the host and clients, the network must be configured to allow device detection and file access.
- Open the Control Panel and navigate to the Network and Sharing Center.
- Click Change Advanced Sharing Settings.
- Expand your current network profile (usually Private or Domain).
- Under the Network Discovery section, select Turn on network discovery.
- Under the File and printer sharing section, select Turn on file and printer sharing.
- (Optional but Recommended) Under Password Protected Sharing, select Turn off password protected sharing (if this is feasible for your network security policy).
- Click Save Changes.
- Verify that the folder containing your company file (
.QBW) is properly shared and has the necessary permissions (this is covered in a later step, but the network must be enabled first).
🛠️ Phase 2: Use Official Troubleshooting Tools
This phase utilizes Intuit’s built-in utilities to diagnose and correct common network and file-related problems.
4. Run the QuickBooks File Doctor (QBFD)
This tool is designed to diagnose and fix network errors (H-series) and data corruption, making it the most likely fix.
- Download and install the latest version of QBFD from the Intuit site.
- Open the tool and choose the option “Both Client and Server” or “Network Connectivity Only” (if the file is local).
- Enter the Admin password when prompted.
- Allow the tool to run its repair and diagnosis.
5. Scan Folders via QuickBooks Database Server Manager
The Database Server Manager tool is responsible for maintaining the multi-user environment. Running a scan ensures the server detects and properly registers the company file, clearing any temporary network errors.
- Close QuickBooks on all server and client systems.
- Open the QuickBooks Database Server Manager (search for it in the Windows Start menu).
- Click the Scan Folders tab.
- If your folder is not listed, click Browse and select the folder that contains your QuickBooks company files (
.QBW). - Click the Start Scan button.
- Allow the scan process to finish completely.
- Once done, review the QuickBooks Company Files Found section to confirm your file is correctly registered.
- Attempt to open the company file on a workstation to verify that the files can now be accessed in multi-user mode.
💻 Phase 3: Deep System and Network Checks
If the quick fixes did not resolve the issue, the problem likely lies in restricted Windows permissions or firewall settings on the host computer.
6. Review Folder and Windows Access Permissions
QuickBooks multi-user hosting requires that the dedicated QuickBooks service user (QBDataServiceUserXX) has the correct security permissions to read, write, and modify the company file.
- Open the File Explorer (Windows icon + E) and navigate to the folder where the QuickBooks company file (
.QBW) is stored. - Right-click on the folder and select Properties.
- Go to the Security tab, then click the Advanced option.
- In the Permissions window, locate the QBDataServiceUserXX (where XX is your QuickBooks version year) and click Edit.
- Crucially, ensure this user has Full Control over the folder. If not, check the box for Full Control under the “Allow” column.
- Click Apply and then OK to save the changes.
- Reboot the server system to ensure the new permissions are fully registered before attempting to open QuickBooks again.
7. Configure Windows Firewall Exceptions
If the Windows Firewall is blocking the necessary communication ports, hosting will be disabled. You must ensure QuickBooks executable files and its specific ports are allowed.
- Open the Windows Firewall (search for “Windows Defender Firewall” in the Start menu).
- Select the option Allow an app or feature through Windows Defender Firewall.
- Click the Change settings button (requires admin rights).
- Scroll down the list and verify that the primary QuickBooks executable files are enabled:
- QuickBooks (
QBW32.exe) - QuickBooks Database Manager (
QBDBMgrN.exe)
- QuickBooks (
- Ensure both the Private and Public checkboxes are ticked for these applications.
- Note: In network environments, the Public exception is often required for seamless multi-user access.
- Click OK to save the new firewall configuration.
- If the error persists, you may need to manually add the QuickBooks ports (a more advanced step often found under Advanced Settings $\rightarrow$ Inbound Rules).
8. Modify the Windows Hosts File
This is for users who have tried everything and still have connection issues because the computer cannot resolve the server name to an IP address.
- Navigate to
C:\Windows\System32\drivers\etc. - Right-click the hosts file and open it with Notepad (Run as Administrator).
- At the very bottom, add a new line in the format:
[Server IP Address] [Server Name](e.g.,192.168.1.10 QBServer). - Save the file and try opening QuickBooks.
🛑 Phase 4: Advanced/Final Steps
If the simpler network and permissions checks failed, the issue may be rooted in deeper system conflicts or a corrupted installation. These steps should be performed last.
9. Add a Windows User and Assign Admin Rights
QuickBooks multi-user functionality often performs better when its core services run under a dedicated Windows user with elevated administrative privileges. This ensures the services can override any restrictive security policies.
A. Prepare a Windows User with Admin Rights (If one doesn’t exist)
This process ensures the host has a dedicated administrative account for QuickBooks services.
- Click the Start button and open Settings.
- Go to Accounts, then select Family & other users.
- Click Add someone else to this PC.
- Follow the prompts to create a local user: Select I don’t have this person’s sign-in information, then Add a user without a Microsoft account.
- Add a username (e.g.,
QBAdmin) and password, then click Next. - Locate the new account under Family & other users, select it, and click Change Account Type.
- Change the account type from Standard to Administrator, and click OK.
B. Provide Admin Rights to QuickBooks Services
- Close QuickBooks Desktop entirely.
- Open the Control Panel and go to User Accounts.
- Find the dedicated QuickBooks service user profile, typically named QBDataServiceUserXX (where XX is your version year).
- Choose Change Account Type and set it to Administrator, then click Apply.
- Repeat this step for the other essential QuickBooks service, QBCFMonitorService, if it has a separate user account assigned.
- Once completed, reboot the server system and attempt to switch to multi-user mode.
10. Reinstall QuickBooks (Clean Install)
If all troubleshooting fails, the underlying QuickBooks program files or registry entries are likely corrupted. A clean reinstallation ensures all hosting services and components are correctly installed and registered.
- Click the Start button and open the Control Panel.
- Go to Programs and Features (or Add or Remove Programs).
- Select QuickBooks from the list and click Uninstall.
- (Crucial Step – Clean Install): Manually delete any remaining QuickBooks folders and files left behind, as specified in Intuit’s official “Clean Install” guide.
- Go to Intuit’s official website (or your reliable download source) and download the installer for your specific QuickBooks version.
- Run the installer. During the setup process, ensure you select the Multi-User/Server Install option and allow multi-user mode hosting to be configured.
Conclusion
Once the solutions stated in this guide are shared, It will fix the Hosting issue in QuickBooks. In case the issue persists, kindly hire the services of a professional.
FAQs about Hosting Mode
How to Set up the QuickBooks Database Server Manager?
Set up the QuickBooks Database Server Manager in two ways:
- The second option installs only Database Server Manager to host company files.
- The first option comprises installing the program, including Database Server Manager and QuickBooks Desktop.
Why is my QuickBooks Automatically Opening in Single-user Mode?
This happens due to a wrong network setup. To fix this, download and run the QuickBooks File Doctor. The tool analyzes and resolves corrupted company files, network connection issues, and wrong configurations in QuickBooks Desktop.
What are the Three Hosting Modes of QuickBooks?
QuickBooks provides three hosting modes that include:
- Hosting Off- implies that files are not shared.
- Hosting Local Files- implies that only local files can be shared.
- Hosting Local and Remote files- indicates both types can be shared for multi-user use.