Multi-User Mode Not Working in QuickBooks: Causes and Ways to Fix It

QuickBooks Desktop's Multi-User Mode is helpful when multiple people work on the same company file at the same time. However, if in the moment you are on some important task and it stops working, it feels very frustrating.


You might notice that QuickBooks remains in Single-User Mode, another computer cannot open the company file, or you see errors such as H202, H505, H101, H303, or 6175. These errors often indicate an issue with the connection between your workstation and the computer that hosts the QuickBooks company file. 

What Is Multi-User Mode in QuickBooks?


Multi-User Mode lets multiple people work on the same QuickBooks company file from different computers at the same time. The computer that stores the company file acts as the host or server, while the other computers connect to it as workstations.


For this setup to work properly, the host computer needs the correct QuickBooks Database Server Manager settings. The database service must run on the computer where the company file is stored, even if QuickBooks Desktop isn't open there.


If something disrupts that connection, Multi-User Mode may stop working.

Why Is Multi-User Mode Not Working?


Several issues could be causing this. One common issue is incorrect hosting. The computer that stores the company file should usually host Multi-User Mode. If a workstation starts hosting the company file, it can cause problems for other users trying to connect. Intuit identifies having multiple host computers as a potential cause of multi-user issues.


Network problems are also a frequent cause. If the workstations cannot communicate with the server, QuickBooks will display H202 or H505 errors, and the firewall settings can block the connection as well.


Also, one important thing is the folder permissions. The Windows account used by QuickBooks Database Server Manager needs proper access to the folder containing the company file.

How to Fix QuickBooks Multi-User Mode Not Working


Try these methods one at a time. First, start with the simpler checks before making any changes to your network or Windows settings.

Method 1: Check Which Computer Is Hosting the Company File


First, find out where your QuickBooks company file is stored. This should usually be your server or host computer. On each workstation, open QuickBooks without opening the company file. Go to File > Utilities.


If you see Stop Hosting Multi-User Access, select it. This will stop that workstation from acting as the host. On the server computer, check the same menu. The server should be set to host the company file. Intuit recommends that the server should be the only computer hosting the company file in a typical network setup.

Method 2: Check QuickBooks Database Server Manager


QuickBooks Database Server Manager is important for a network-based Multi-User setup. It allows other computers to access company files stored on the server.


Open QuickBooks Tool Hub on the server and go to Network Issues > QuickBooks Database Server Manager. Then check if the folder containing your company file is listed. If it isn't, browse to the folder and select Start Scan.

Method 3: Check Your Network Connection


If Multi-User Mode suddenly stopped working, then check if the workstations can still communicate with the server. Make sure the server computer is on and connected to the same network. From a workstation, check if you can access the shared folder where the QuickBooks company file is stored.


If the server is unreachable from another computer, QuickBooks won't establish the connection it requires. For network-based setups, ensure that Windows Network Discovery and sharing settings are configured properly.

Method 4: Check Folder Permissions


QuickBooks requires proper Windows permissions to access the folder with the company file. On the server, right-click the company file folder and open Properties > Security. Make sure the QuickBooks Database Server service account has the permissions it requires.


The exact account name changes based on your QuickBooks Desktop version and may appear as QBDataServiceUserXX. Intuit provides specific requirements for folder permissions for these accounts.


If you don’t have an idea about changing Windows permissions, the safest way is to ask your IT administrator to handle this step.

Method 5: Check Your Firewall Settings


A firewall can stop communication between QuickBooks workstations and the server. This is especially important to check if the company file opens normally on the server, but users on other computers cannot access it.


Intuit recommends ensuring that important QuickBooks processes, including QBW32.exe, QBUpdate.exe, QBDBMgr.exe, and QBDBMgrN.exe, can pass through the firewall when troubleshooting certain multi-user errors.

Method 6: Run QuickBooks File Doctor


If the network and hosting settings look correct but Multi-User Mode still isn't working, then QuickBooks File Doctor can help identify certain company-file and network issues. 


For that, you have to open QuickBooks Tool Hub, select Company File Issues, and choose Run QuickBooks File Doctor. Now select your company file and opt to check the network. Enter your QuickBooks administrator password when prompted, and the tool finishes its check. Intuit recommends using File Doctor as part of the troubleshooting process for errors like H202.

Method 7: Restart the QuickBooks Database Service


If the Database Server Manager service isn't working correctly, then other computers may not connect to the company file. The QuickBooks Database Server Manager operates as a Windows service on the computer that hosts the company file. Multi-User Mode depends on this service for network access.


If the service has just stopped or isn't functioning properly, restart it, then try opening the company file from a workstation. If you're unsure which service corresponds to your QuickBooks version, then you should avoid changing unrelated Windows services.

Method 8: Check for H202, H505, H101, H303, or 6175 Errors


If QuickBooks shows an error code, then pay attention to it. H202 and H505 usually mean the workstation is unable to communicate with the server. H101 and H303 may also occur with incorrect hosting or network settings.


Also, error 6175 can indicate issues regarding the starting or communicating with the QuickBooks Database Server Manager. Intuit recommends checking hosting settings, using File Doctor, and reviewing the user settings of the firewall and Windows to address this issue.

What If Multi-User Mode Still Doesn't Work?


If you've checked all necessary functions, including hosting, Database Server Manager, network access, permissions, and firewall settings, but the problem is still happening, the issue needs a deep understanding.


So, before making any major changes, ensure you have a recent backup of your QuickBooks company file. This provides a safer starting point if you need to troubleshoot or repair anything further.

Conclusion


When Multi-User Mode is not working in QuickBooks, the issue most probably relates to how QuickBooks interacts with the company file. So first, start by checking which computer is hosting the file. Then review QuickBooks Database Server Manager, network access, folder permissions, and firewall settings.


If you encounter errors like H202, H505, H101, H303, or 6175, use those codes to look up your troubleshooting. QuickBooks Tool Hub and File Doctor can also help identify specific network and company-file issues. Most importantly, avoid changing hosting or Windows settings randomly across all computers. For additional troubleshooting guidance, Accounting Assist Pro is available at +1-888-892-5727 to help resolve QuickBooks network and QuickBooks company-file errors.

Frequently Asked Questions


Why is QuickBooks Multi-User Mode not working?


Multi-User Mode may fail due to incorrect hosting settings, network issues, firewall restrictions, folder permissions, or problems with QuickBooks Database Server Manager.


How do I fix the QuickBooks H202 error?


H202 usually indicates that a workstation is unable to communicate properly with the server that hosts the company file. So, check the hosting setup, run QuickBooks Database Server Manager, scan the company file folder, and use QuickBooks File Doctor if needed.


Should every computer host QuickBooks Multi-User Mode?


No. In a standard network setup, the computer holding the company file should be the host. Workstations that just access the file should not host it, as multiple hosts can cause connection issues.


Does QuickBooks Database Server Manager need to be running?


Yes. The database service must run on the computer where the company file is stored for other computers to access it through the network.


Comments

Popular posts from this blog

QuickBooks Error 61: Causes and Complete Fix

QuickBooks Error 61: Causes and Complete Fix

How Does QuickBooks Tool Hub Work?