This article will help you to host your QuickBooks company data file in multi-user mode. Hosting you company data files in multi-user mode can be a beneficial move for you as it allows multiple users to access and work on a single company file at same time.
If you are facing any kind of issues in multi-user mode such as multi-user not working or QuickBooks Error H101, H202, H303 or H505 when opening your company file in multi-user mode then you can get in touch with the QuickBooks Customer Service Phone Number +1800-567-0425 toll-free.
The term hosting refers to the situation where the computer that stores a data file gives access to other workstations to work on the file.
QuickBooks uses a service to manage company file access:
- QuickBooks 2019 uses QuickBooksDB29
- QuickBooks 2018 uses QuickBooksDB28
- QuickBooks 2017 uses QuickBooksDB27
- QuickBooks 2016 uses QuickBooksDB26
You can locate this service by going into the Windows Control Panel and then User Accounts, under users for this system. Find out the service that corresponds to your version of QuickBooks Desktop.
The following diagrams illustrate QuickBooks Desktop hosting modes.
Peer to peer hosting
How Company Files Are Accessed?
QuickBooks basically needs 3 requirements that needs to be fulfilled before it can allow access to the company files:
- Windows File Permissions: The logged on user must have the permissions to Full control in which the user can look at, open and edit the document of file.
- Database Server Mode: The database server opens the company file successfully.
- QuickBooks User Login: All the users must have a valid QuickBooks login credential.
- You’ll be able to access the company file once these 3 requirements are met.
The hosting mode is set for all QuickBooks versions and for all computers. However, it is not set for the company file or the QuickBooks Desktop installation. If multiple versions of QB Desktop 2018 or later are being used then the hosting mode settings for each version are independent.
Basically, there 3 hosting modes and they are as follow:
In Not Hosting Mode
- QuickBooks Database Manager runs as a normal process, as a Windows user running QuickBooks Desktop.
- Multi-user mode is not supported in the Not Hosting mode as this mode support the only QuickBooks user who is running QuickBooks Desktop on the local computer can use a database server to access a file.
In Hosting Local Files Only Mode
- QuickBooks Database Server Manager runs the QuickBooksDBXX Windows service (where XX is a number from 25 to 28 determined by the version of QuickBooks Desktop, as described under “Hosting defined,” above) and as the Windows user QBDataServiceUserXX (with XX being the same 2-digit number from 25 to 28 that the Windows service uses).
- The service keep on running as long as the system is on
- Using the TCP/IP to communicate with QuickBooks, the Multi-user mode is supported. The company files can be accessed on remote using a database server running in Hosting Local Files only mode.
- A computer in Hosting Local Files only mode can host only those files that are located on the host system.
In Hosting Local & Remote Files Mode
- QuickBooks Database Manager runs as a normal process, as the currently logged on Windows user. The process gets initiated after a user logs in to Windows and stops after the user logs out from the windows.
- A system under Hosting Local & Remote files mode supports the multi-user mode by using TCP/IP to communicate with QuickBooks. QuickBooks users can access the company file on remote using a database server.
- A local computer under this mode is able to host files that are located on remote systems and opened on the local systems.
How QuickBooks Desktop Determines Which Database Server To Communicate With?
- QuickBooks Desktop requires the .nd file which has the same name as the company file but with .nd extension. This file is located in the same folder where the company file is stored. The folder also consist the details required to contact the server like IP address and port.
- QuickBooks Desktop tells whether the .qbw file is in use or not, QB Desktop attempts to communicate with the server:
- If successful then the QuickBooks company file will open
- If unsuccessful then you may get an error message that needs to be resolved as soon as possible.
Technical Support For QuickBooks Multi-User Mode
The provided information about the multi-user mode will allow you to host your company files in multi-user mode. However, if you face any kind of issue while setting up the multi-user mode or while working in the multi-user mode then you can get in touch with our QuickBooks Support Phone Number +1800-567-0425 toll-free to resolve all your QuickBooks issues instantly.