Is QuickBooks losing connection to the company file located on the server and prompting with the QuickBooks Error H202 message?
One of the most common reasons Error H202 occurs because the network firewall is blocking the connection while switching to multi-user mode and thus, QB is unable to communicate with the QuickBooks database server manager which is installed on the host computer that hosts your QBW. data file.
Here is the message usually displayed on your screen that “QuickBooks needs help as it is unable to connect to the host computer to open your company file.”
Unfortunately, this is a common problem often encountered by users running QB software through a server computer.
This is the computer where your accounting data gets stored providing access to one or several workstations connected to the network.
Here we have gathered for you several methods to help you fix Error H202 switching to multi-user mode.
This tutorial is aiming to provide you with information on how to fix lost connection between your host computer and the workstations running Desktop versions Pro, Premier, or Enterprise 2020.
To begin with, Please make sure that you have QuickBooks database server manager installed on the host computer that is hosting your data before you continue with the following methods.
Besides Error H202 this guide can help you resolve other multi-use setup error such as H101, H505 in QB Desktop. These steps may require some basic technical knowledge. So, we recommend you pay attention during the troubleshooting session to avoid causing any damages to your accounting data. So, before you begin be sure to back up your files.
If you are not familiar on how QuickBooks is setup than check this article to learn about QB multi-user mode setup.
Now, let’s look at what this error means and how it triggers following with 12 proven steps to fix QuickBooks error h202 server 2012.
What is QuickBooks Error H202?
- When QB tries to communicate with the database it tries to locate the .ND file which is a small text file and has the same name as your company file, but appears with a .ND extension. The same folders also have the .QBW extension which contains the information required to connect to the server port and IP address.
- Now QB desktop can specify if the .QBW extension is in use.
- When QB is able to locate the .ND extension and confirms that .QBW is operable, it tries to communicate with the host computer.
QB will open your data if the communication is successful
When you see the H202 code on your computer it means it the connection to the host computer was lost and thus could not communicate with the database.
What causes QuickBooks error h202 switching to multi-user mode?
Here is a list of components that prompts connection problem. While performing these steps you will learn and eventually find a solution to get rid of h202.
When you try to access your data, QB tries to initiate a connection with the host computer to open the accounting database, during this attempt QB fails to connect to the remote computer and at that point, you start seeing errors such as H101, H202, H505, and other similar H-series faults.
The server firewall is interrupting incoming and outgoing communication.
Damage QuickBooks database .
DNS server damage or confliction can cause this issue.
QuickBooksDBxx service is not running on the host computer.
A corrupted database could be one of main reasons to this error.
QB is unable to locate the IP address of the Host computer.
The Standard hosting configuration is defective or faulty.
Missing or damaged .ND files.
Also, read network connection problems occurred due to QBDBMgrN not running.
How to fix QuickBooks error h202 multi-user?
Important: We recommend you perform a backup of your QBW data before initiating the troubleshooting steps mentioned below. By doing this you can be certain to restore the original data from backup if required.
Complete these steps one by one to identify the connection issue between the server and the computer in your network and successfully get h202 error in QuickBooks Fixed.
Step1: Start with configuring your firewall settings
The firewall is blocking internet access for specific functions that require programs related to the software to function improperly due to which Error code h202 in QuickBooks may occur. You may update your firewall to the latest version which might help in resolving the issue. Additionally, Check to confirm that your firewall is set to allow connection to the host computer,
You can use the QuickBooks file doctor to fix the firewall from blocking communication, In case this tool did not fix QuickBooks multi-user error code h202 then we will demonstrate how to reconfigure the firewall manually.
Configure firewall manually
Open start menu in Windows.
Type “Windows Firewall” into the search bar to open Windows Firewall.
Go to Advanced Settings
On the left select Inbound Rules
Select New Rule
Check Port and hit Next
Select TCP from the box
Choose the specific ports from the list below which is categorized to the software version and enter the correct port in the local port field.
2020 QuickBooks Firewall Ports: 8019, XXXXX.
2019 QB Firewall Port: 8019, XXXXX
2018 QB Firewall Port: 55378,56728.55382,8019
2017 QB Firewall Port: 55373,56727.55377,8019
Note: The latest editions of QuickBooks use dynamic ports those are specified firewall ports assigned automatically while installing QB. So as you can see that the 8019, XXXXX are the default ports for QB 2019 and later versions.
Step2: I see error H202 when contacting the server
In this step, we will help you find out if the QuickBooksDBxx services are running properly on the server computer. Let’s perform a few simple steps and see if a service has stopped due to which the QuickBooks enterprise error code h202 is being caused.
Press Windows key and letter R simultaneously.
Now type services.msc in the Run box and press Enter.
Find the QuickBooksDBXX services in the list
Note: XX refers to the version of QuickBooks running on your server.
Double click on QuickBooksDBXX to open properties
Set startup type to Automatic.
Select Start if service status is not running or did not get started Automatically
Here is an infographic to help you further with this step.
Next Click on the Recovery tab now
Select Restart the Service in all the sections first failures, second failures and, Subsequent failures.
Finally to save the changes Click Apply then OK.
Now that we have completed the above steps, let’s go ahead and open QB on the user’s workstations.
First of all turn multi-user mode back on in QB.If you can access your data without the H202 than great your problem has been resolved.
Step 3: Fix Error H202 multi-user in Windows Control Panel
Make sure to Close QB in all the Workstations
Open Programs and features from the Window Start Menu
In the installed programs list find QB > right click on the program > select Change/repair
On the next window Check all the options
Wait until Windows has Completed Repairing QB
Next, open your software and check for the latest updates. Go to Help from the top menu > Choose Update QuickBooks desktop from the drop-down list > Update now > once the update is complete Restart computer.
If the issue was related to the program than this step has fixed the QuickBooks 2019 h202 error multi-user. After restarting your server you might not be experiencing any further communication issues with the workstations.
Step 4: Now add QuickBooks server to Windows host file
Before you continue with this step obtain admin user rights to get the IP address and computer name for your server and workstations both.
Note: Your server hosts the original .QBW extension and a workstation is a user computer from which you access the data stored on the server.
Now lets us apply the following steps on your server computer first and then on your workstations.
Here’s how to get your IP address and computer name.
Open the Run windows by pressing Windows + R on the keyboard.
Type “cmd” in the Run window and hit enter.
Type “ipconfig space /all” and press enter.
Now make note of the hostname and the IP address.
Here is an image to show how it should appear on your screen.
Now you have the server IP and the Computer names, Next, we will show you how to Edit and Save the Windows Host file. We will run these steps on both the workstations and server on which you are experiencing the Error.
Go to the windows start menu and type the following:
Select the Host file from the list.
Right-click on the file and choose to open with Notepad.
Now enter the IP address and the computer name you obtained earlier in the host area on this notepad. Follow the image below
Look at this image to get an idea on where to enter the IP address and the server name:
Reminder: Make sure you have updated the server name and IP address on both the workstations and on the server.
Assuming that you have performed all the above steps correctly now let’s go ahead and save the changes you just made to the host file.
Press Ctrl + S and as you would generally attempt to save a notepad.
Save as “hosts”, along with the quotation marks.
Make sure to save it on the desktop.
Return back to the file location
Right-click and rename the file to Hosts Old.
On your keyboard press Ctrl + S and close the notepad.
Close the notepad.
Now go ahead and open your QB to see if performing the above steps has solved your problem with switching to multi-user mode, or we shall continue with the next step.
Note: Keep the server name handy as you would need it while performing the next step.
Step 5: Run a Network Connection Test
In the following step, we will send a query/ping using the command window to check the connection between the host machine and the workstations.
Open QuickBooks Desktop
Go to file > utilities > select turn off hosting mode.
Go to the Windows search bar and type run to open the run window.
Type CMD and click OK.
Here is an image of the window that will open up on your screen:
Type ping space “[server name]” excluding brackets from the sides of the server name.
Continue to ping on each workstation experiencing connected to the network.
While trying to ping your server from workstations if you experience a slow response or packet loss than you might rather want to call a QuickBooks expert and get help with repairing your Network issues before you can troubleshoot any further.
Additionally here you can find out how to rename a file server to fix H202 Error?
Step 6: Move company data to a different location
Open Quickbooks in single-user mode and log in.
Press F2 to see the Product Information.
Copy the location from under File Information.
Open a folder and paste the location path and press enter.
Select and Copy the .TLG and .QBW files from the folder.
Go to your Desktop screen.
Right-click and choose to create a new folder
Paste them into the new folder.
Set Windows access permissions for the New Folder.
Turn to host mode on try to access your data now.
If the problem persists while accessing your data in multi-user mode than continue troubleshooting with the following steps.
Step 7: Run QuickBooks File Doctor Tool
Here’s how you can download and run the File doctor tool to resolve network issues related to error code h202 QuickBooks 2020.
Install the tool on your computer
Click on the browse button to choose your database.
Click to continue to scan your data for problems.
Once the tool completes the scan of your data open QB in multi-user mode to check if the problem has been resolved.
Continue with the next step if the problem is not fixed.
Step 8: Run QuickBooks connection diagnostic tool
Read this Article to learn about the connection diagnostic tool before you continue.
The QB connection diagnostic tool can help you repair damages and errors on your company file which causes network problems to communicate with the company file from the host computer and fix H-series errors.
Once you have downloaded the Connection Diagnostic Tool.
Go to Utilities Menu and select repair Network problems.
Click YES on the next window and press Continue.
Choose the damaged file from the list > “show advanced settings”.
Select the Error or problem you are facing with your Network from the Dropdown list.
Now log in to continue.
Wait while the Diagnostic tool repairs your damaged data and fixes the network issues related to multi-user mode compatibility. This may take some time.
Once the scan is complete restart your software and try to access your data from a workstation to confirm if error code H202 in QuickBooks has been fixed, if not go to the next step.
Step 9: Reinstate the database server manager
Sometimes something as simple as just restarting the database manager has helped many users solve the H202 Error.
Let’s perform the following steps to see if this is the solution to accomplish fixing this error:
Press Windows key + Run to open the run box.
Type services.MSC and click OK.
From the list of services find QuickBooksDB28 for , QBDB29 for , QBDB30 for 
Double click on your version of the software and Select stop to disable it.
Right-Click and Choose startup type as Automatic
Again right-click on the service and select restart the QuickBooksDB service from the drop-down.
Now exit and restart your computer.
Once your computer is back on, Open QB desktop and check if you can communicate in multi-user mode now, If error H202 did not go away because the database manager is not working properly then renaming or recreating the.TLG and .ND from the backup folder is our next option.
Step 10: How to rename the .ND and .TLG file?
As we mentioned earlier in this article that when QB is trying to communicate with the host computer it looks for the .ND and the .QBW files is always in the same directory and ensures that it is in use to reestablish a connection successfully.
If QB is unable to locate these files than error code h202 QuickBooks 2017 will occur but don’t worry let’s recreate the .ND and .TLG on the computer with the error.
Navigate to the company file backup folder to locate the .ND extension.
Or simply Type *.ND on the windows search bar.
You can choose to keep the damage .ND file but Rename it with a prefix (.ND.OLD).
Or Right-Click and choose Delete.
Confirm deletion if prompted on the screen
Find the .TLG extension in the same directory and rename it too (.TLG.OLD)
Next, Open database server manager to recreate new .ND and .TLG in the same folder.
Press the Scan folder tab.
Click Add and browse to the location of the company file folder.
Choose the company file causing Error H202 and Press Ok.
Start the scan and wait for the scan results to complete.
After the database manager has Completed the Scan Restart QB.
Step 11: Use the QuickBooks Tools Hub
The All-in-one QuickBooks tools hub can help with fixing network connectivity issues. Furthermore, with innumerable problems related to Error H202 and other common Software or company file issues.
For detailed understanding learn more about the QuickBooks tools hub please continue to read this article and Download tools hub here.
Once you have download the tools hub on the left you will see all the features you need and many tools to address different problems related to multi-user issues and accounting data.
Network problems: Run the tool on your server computer and use this tab to fix QB H202 Error or H505.
Program Problems: If you are having trouble accessing QB such as the program wouldn’t start or QB crashes, stopped working use this feature to find a solution including any PDF or printing-related issues from QB.
Installation Issues: In case you are trying to uninstall the program or unable to rei-install getting error 1904. Use this tab.
Password reset: This feature will help you reset passwords on your company data file.
Step 12: First Update and then try to repair QuickBooks
Open QB and click on help.
Select the update QB Desktop.
Once you have updated to the latest version.
First, create a backup of your company file to check if it is successful.
Next, Open the tools hub and choose the company file issues from the left menu.
It will automatically download the file doctor tool to fix any error and damages related to your data.
Once the tool has repaired the company data successfully from here on moving forward switching to multi-user mode should not be a problem anymore.
Being a QuickBooks Pro Advisor we are interested in guiding our readers to Quick solutions with problems you might face while operating the QB desktop software. In this post, we have covered all the proven and effective technical steps that has helped hundreds of users to find a solution to the QuickBooks error H202 fix and we hope your problem has been solved as well by now.
Let us know if you need any further help, You can contact support via Phone: +1 971-205-3827
You can send us an email: firstname.lastname@example.org
Additionally, you can also Log in to leave a query and receive help via our Expert’s community.