QuickBooks Desktop allows businesses to manage accounting records, track expenses, create invoices, and handle payroll efficiently. When several employees need to work with the same company file, QuickBooks Desktop Multi-User Mode makes it possible for multiple users to access the file over a shared network.
Setting up a multi-user network correctly helps teams work together without transferring company files between computers. However, the setup requires proper hosting configuration, Windows file permissions, and database server settings. If any of these components are incorrect, users may encounter connection problems or errors such as H101, H202, H303, and H505.
This guide explains QuickBooks Desktop hosting, the different hosting modes, company file access requirements, and how the software locates the database server.
What Is Hosting in QuickBooks Desktop?
Hosting refers to allowing other computers on a network to access a QuickBooks company file stored on a particular computer. The computer that stores and shares the file acts as the host, while other computers connect to it to work with the same financial data.
For example, a business may store its company file on a dedicated server and allow employees to access it from their workstations. This setup reduces the need to maintain separate copies of accounting records.
QuickBooks Desktop uses the QuickBooks Database Server Manager service to manage access to company files in a multi-user environment.
QuickBooks Database Services by Version
The database service name depends on the QuickBooks Desktop version.
- QuickBooks Desktop 2024: QuickBooksDB34
- QuickBooks Desktop 2023: QuickBooksDB33
- QuickBooks Desktop 2022: QuickBooksDB32
These services help manage company file access for the corresponding versions. To review Windows services, open the Windows Services console by searching for Services in the Start menu. Look for the database service associated with your installed QuickBooks version.
The exact service configuration may vary depending on the QuickBooks release and installation.
Different QuickBooks Desktop Hosting Modes
QuickBooks Desktop provides different hosting configurations that determine how a computer accesses and shares company files. The hosting mode is configured separately for each QuickBooks version on each computer.
When a business uses multiple QuickBooks Desktop versions, the hosting settings for those versions may operate independently.
The three main hosting modes are Not Hosting, Hosting Local Files Only, and Hosting Local and Remote Files.
1. Not Hosting Mode
In Not Hosting mode, the computer does not host company files for other computers through the database server. QuickBooks Database Manager operates as a normal process under the Windows user running QuickBooks Desktop.
This mode uses shared memory for communication between QuickBooks Desktop and the database process on the local computer.
Important: Not Hosting mode does not support hosting a company file for remote users. It is suitable when a computer only needs to access files locally rather than act as a host for other workstations.
If you want several employees to access the same company file over a network, you must configure an appropriate hosting setup on the computer that stores the file.
2. Hosting Local Files Only Mode
In Hosting Local Files Only mode, QuickBooks Database Server Manager runs as a Windows service. The service typically uses a name such as QuickBooksDBXX, where XX represents the version-specific number.
The service runs in the background and can continue operating while the computer is turned on, even when no user is actively running QuickBooks Desktop.
This hosting mode supports multi-user access through TCP/IP network communication. Other computers on the network can connect to the database server to access company files stored on the host computer.
The main characteristics of this mode include:
- It supports multi-user access to company files stored on the local computer.
- The database service runs in the background.
- Remote QuickBooks Desktop users can connect through the network.
- The computer hosts files stored on that computer rather than files located on other computers.
For many businesses that keep their company file on a dedicated server, this configuration is an appropriate hosting option.
3. Hosting Local and Remote Files Mode
In Hosting Local and Remote Files mode, QuickBooks Database Manager runs as a normal process under the currently signed-in Windows user.
The process starts when the user signs in to Windows and stops when the user signs out. This behavior differs from a database service configured to run continuously in the background.
This mode supports multi-user access through TCP/IP. Remote QuickBooks Desktop users can connect to company files stored on the host computer.
Depending on the configuration, the local computer can also work with company files stored on remote computers.
Businesses should choose the hosting mode that matches their network design. Avoid enabling hosting on multiple computers unnecessarily, as incorrect hosting settings can contribute to multi-user connection errors.
Requirements for Accessing QuickBooks Company Files
QuickBooks Desktop checks several conditions before allowing a user to access a company file over a network. If one requirement is missing, the user may be unable to open the file.
1. Windows File Permissions
The Windows account used to access the company file must have the necessary permissions for the folder containing the file.
The permissions should allow authorized users to open, read, and modify the company file. Depending on the network setup, the folder's sharing permissions and NTFS security permissions may both need adjustment.
Ask your system administrator to verify that the correct users and database service account have the required access. Do not grant unrestricted permissions to everyone when a more limited configuration will work.
2. QuickBooks Database Server Manager
The database server must be able to locate and open the company file. If the database service is stopped, misconfigured, or unable to access the file's folder, remote users may experience connection problems.
Make sure Database Server Manager is installed and configured on the computer that stores the company file. Also, verify that the appropriate service is running and that the network allows the required communication.
3. QuickBooks User Credentials
Each person accessing the company file must sign in with an authorized QuickBooks user account and password.
QuickBooks user permissions determine which company data and accounting functions each person can access. Create individual accounts for employees instead of sharing one login among multiple users.
Once the file permissions, database server, and QuickBooks login requirements are satisfied, authorized users can access the company file according to their assigned permissions.
How QuickBooks Desktop Finds the Database Server
QuickBooks Desktop uses a small configuration file with the .nd extension to identify the database server associated with a company file.
The .nd file normally shares the same base name as the company file and is stored in the same folder. For example, a company file named CompanyFile.qbw may have a corresponding CompanyFile.nd file.
The .qbw file contains the company data, while the .nd file stores network connection information used by QuickBooks Desktop, including server and port details.
How the Network Connection Works
When a user opens a company file, QuickBooks Desktop checks whether the file is being used and attempts to establish communication with the appropriate database server.
The process generally works as follows:
- QuickBooks Desktop locates the company file.
- The program checks the associated .nd file for network connection details.
- QuickBooks Desktop attempts to contact the database server.
- If the connection succeeds and access requirements are satisfied, the program opens the company file.
- If the connection fails, QuickBooks Desktop may display an error message with troubleshooting information.
A missing, outdated, or incorrect .nd file can contribute to connection problems. If you suspect a network configuration issue, use QuickBooks Database Server Manager to scan the folder containing the company file and verify the network configuration.
Before changing or recreating configuration files, make sure you have a reliable backup of your company data.
How to Troubleshoot QuickBooks Multi-User Mode Errors
QuickBooks Desktop may display H101, H202, H303, or H505 when it cannot establish the required connection in a multi-user environment.
These errors can result from incorrect hosting settings, blocked network communication, unavailable database services, or file permission problems.
Try the following basic checks:
- Verify hosting settings: Confirm that the computer storing the company file is configured to host it and that other workstations are not unnecessarily hosting the same file.
- Check Database Server Manager: Make sure the appropriate database service is running on the host computer.
- Scan the company file folder: Use QuickBooks Database Server Manager to scan the folder where the company file is stored.
- Review firewall settings: Confirm that Windows Firewall or other security software allows the required QuickBooks network communication.
- Check folder permissions: Verify that authorized users and the database service account can access the company file.
- Confirm network connectivity: Make sure the host computer and workstations can communicate over the local network.
- Update QuickBooks Desktop: Install the appropriate updates for your QuickBooks version and check whether the issue persists.
If the error continues, follow the troubleshooting instructions specific to the displayed error code. Avoid changing firewall rules or network permissions without understanding the security implications.
Best Practices for a Reliable QuickBooks Multi-User Network
A properly configured network helps reduce interruptions and protects important accounting information.
Follow these recommendations:
- Keep the company file in a shared folder on a reliable computer or server.
- Maintain regular backups of your QuickBooks company file.
- Use individual QuickBooks accounts for each employee.
- Install compatible QuickBooks Desktop releases on the computers that need access.
- Keep the host computer powered on and connected to the network while employees need access.
- Review firewall and folder permissions after making network changes.
- Avoid storing the active company file in an unreliable or disconnected network location.
- Restrict access to authorized users and maintain appropriate security controls.
These practices help improve access reliability and reduce the risk of avoidable multi-user problems.
Final Thoughts
Setting up Multi-User Network Mode in QuickBooks Desktop requires the correct hosting configuration, working database services, suitable Windows file permissions, and authorized QuickBooks user accounts.
Understanding the differences between Not Hosting, Hosting Local Files Only, and Hosting Local and Remote Files helps you choose the appropriate setup for your business. Checking the .nd configuration file, database server, firewall, and network connection can also help resolve common multi-user errors.
With the right configuration and regular maintenance, your team can access shared company data more reliably and complete accounting tasks without repeatedly transferring files between computers.
If you continue to experience H101, H202, H303, or H505 errors, follow the troubleshooting guidance for the specific error and verify your network settings before making further changes.
Frequently Asked Questions
What is QuickBooks Desktop Multi-User Mode?
QuickBooks Desktop Multi-User Mode allows multiple authorized users to access the same company file over a network. It requires suitable hosting settings, database server configuration, and file permissions.
Which computer should host the QuickBooks company file?
The computer that stores the company file should generally act as the host. Businesses with several workstations often use a dedicated server to keep the company file available to authorized users.
What is the difference between Hosting Local Files Only and Hosting Local and Remote Files?
Hosting Local Files Only allows the computer to host company files stored on that computer. Hosting Local and Remote Files also supports working with files located on remote computers, depending on the network configuration.
Why does QuickBooks display error H202?
Error H202 can occur when QuickBooks Desktop cannot communicate with the computer hosting the company file. Common causes include database service problems, firewall restrictions, network connectivity issues, and incorrect hosting settings.
What does the QuickBooks .nd file do?
The .nd file contains network configuration information that QuickBooks Desktop uses to locate and communicate with the database server associated with a company file.
Can multiple computers host the same QuickBooks company file?
The hosting configuration should match your network design. In a typical setup, designate the computer storing the company file as the host and configure workstations to access it without unnecessarily enabling hosting on every computer.
Comments