This article shows you how to fix ‘QuickBooks Hosting Mode is Off’. In QuickBooks, the File Doctor recovers damaged company files and also resolves network issues. The network issues can be resolved based on the File Doctor test results.
One of these results is ‘Hosting Mode Is Off’.
For accessing QuickBooks files over a network, hosting must be turned on.
NOTE: This warning can be ignored if users are on the workstation.
Table of Contents
Steps for QuickBooks Turning on Hosting Mode
Hosting QB company data files in multi-user mode
Hosting allows other computers access to files stored in the main computer, which is the host computer. One of the files that can be accessed is the QuickBooks company file.
QuickBooks Desktop manages access to the company file via a service:
- QuickBooks Desktop 2018 uses QuickBooksDB28
- QuickBooks Desktop 2017 uses QuickBooksDB27
- QuickBooks Desktop 2016 uses QuickBooksDB26
Users can find this service by going to the Windows Control Panel, followed by User Accounts that is under Users for the computer. Users must look for the service that matches with their version of QuickBooks.
Accessing Company Files
These conditions have to be met for accessing the company file:
- Windows file permissions: The logged in user must have permissions for Full Control. This includes permission to view, open and change the file.
- Database server mode: The company file should open the company file.
- QuickBooks user log-in: Every QuickBooks users must have a QB user login and password.
Hosting mode is set for every QB version and every computer, but not for the company file or the QB installation. If several versions of QB 2016 and later are used together, each version has its own hosting mode settings.
The 3 hosting modes are: Not Hosting (Hosting Off), Hosting Local Files and Hosting Local And Remote Files.
Not Hosting Mode:
- In this mode, the QB Database Manager runs as normal process in the form of Windows user running QuickBooks
- This mode doesn’t support multi-user mode and uses shared memory for communicating with QuickBooks. Only the user running the QB on the local computer can access a file by using a database server.
Hosting Local Files Only mode:
- In this mode, the QB Database Server Manager runs in the form of a Windows service called QuickBooksDBXX (XX is any number between 17 and 28 that’s determined by the QB version).
- The Databases Server Manager also runs as the Windows user QBDataServiceUserXX (XX is the same two-digit number between 17 and 28 that is used by the Windows service).
- The QuickBooksDBXX service runs till the computer is switched on.
- The multi-user receives support by using TCP/IP for communicating with QuickBooks. QB users that are on remotely located computers can access company files via a database server that runs in Hosting Local Files Only mode.
- A computer that’s in this mode can only host files that are on that computer.
Hosting Local And Remote Files Mode:
- In this mode the QB Database Manger runs normally in the form of the Windows user that’s logged in currently. The process begins when the user logs into Windows and ends when the user logs out.
- A computer that’s in this mode supports multi-user mode by using TCP/IP for communicating with QuickBooks. QB users that are on remote computers can access company files stored in this computer via a database server.
- A local computer that’s in this mode can host files that are stored in it and also files stored in remote computers that are opened in this local computer.
QuickBooks Method of Determining which Database Server to Communicate
- First, QB searches for the .nd file, which is a small text file that has the same name as the company file but with the .nd file extension. The file is located in the same folder as the company file that has the .qbw extension. This folder also stores information that’s required for contacting the server: the IP address and port.
- Next, QB figures out if the .qbw file is being used.
- If QB locates the .nd file and finds that the company file is being used, it attempts to communicate with the server:
- If it can communicate with the server, QB opens the company file.
- If it can’t communicate with the server, an error message is shown that explains the steps to be taken for fixing the error.