QuickBooks File Doctor is the most important tool which is designed to recover your damaged company file and it will help you to recover some of your network issues also. You can review the results you will get from using the File Doctor to see how to resolve the issue. Each of the test results has a section that describes it in detail, along with resources to help to resolve network issues with QuickBooks File Doctor test results.
If your Hosting Mode is Off
You should keep your hosting always turn on to get access to the QuickBooks Files over a network and resolve issues with QuickBooks File Doctor.
Turn on Hosting:
About hosting QuickBooks company data files in multi-user mode
Hosting means to allow another computer or workstations to get access to the file from the main computer, where the company files are saved.
We have mentioned below the services that QuickBooks Desktop uses to manage company file access:
- QuickBooks Desktop 2020 uses service QuickBooksDB30
- QuickBooks Desktop 2019 uses service QuickBooksDB29
- QuickBooks Desktop 2018 uses service QuickBooksDB28
Now check your Windows Control Panel, here you will see this service in Use Account, in the Users option for this computer. You need to check for the service that compatible with your version of QuickBooks Desktop to resolve network issues with QuickBooks File Doctor.
We have mentioned below all the QuickBooks hosting modes.
- Dedicated hosting diagram
- Peer to peer hosting diagram
- Alternate hosting diagram
How company files are accessed
You need to meet the below conditions to access the company file:
- Windows File permissions: It is necessary to have permissions set to Full control with the user who logged in, which will give you permission to look at, open, and modify the file.
- Database Server mode: In the database server mode you can successfully open the company file.
- QuickBooks User login: Each user should have a QuickBooks user login and password.
Hosting modes
This hosting set for each version of QuickBooks Desktop and for each computer. This feature is not for company files or the QuickBooks Installation. If you are using multiple versions of QuickBooks 2018 or the latest one then the hosting mode setting for each version will be independent.
There are three types of hosting modes available:’
Not Hosting (also known as Hosting Off)
- In this hosting mode, the database manager will work as normal as a windows user using QuickBooks.
- This hosting Mode can not support multi-user mode, It uses shared memory to connect with QuickBooks. In this mode, the user who is using QuickBooks on a local computer can use the database server to access the file.
Hosting Local Files only
- In this hosting QuickBooks, Database Server Manager will work as a Windows service named with QuickBooksDBXX and as the windows user QBDataServiceUserXX.
- The service QuickBooksDBXX will be in On condition till your system is on.
- In this mode, you get the advantage of multi-user mode, using TCP/IP to connect with QuickBooks. The QuickBooks user with a remote computer will be able to get access to company files using the database server that is working in Hosting local files only mode.
- A system with this hosting mode can host those files that are placed on that computer.
Hosting Local & Remote files
- In this hosting QuickBooks Database Manager works like a normal process, as you are working on windows. This hosting will start working when you will log in to windows and stop when you logout.
- A system with this hosting will be able to support multi-user mode, by using TCP/IP to connect with QuickBooks. The QuickBooks use who has remote computers can get access to the company file on this computer by using a database server.
- A local computer with Hosting Local & Remote files mode can host files saved in it along with the files that are placed on a remote system and opened on the local system.
How does QuickBooks Desktop determine which database server to communicate with?
- QuickBooks Desktop always searches for the .nd file. The .nd file is a very small text file saved with the same name as the company file, but with the .nd file extension. You will get this file in the same directory as the company file, which has the file extension .qbw. The directory also keeps the information required to contact the server, such as the IP address and port.
- QuickBooks Desktop can determine if the .qbw file is working or not.
- If QuickBooks Desktop found the .nd file and detects that the company file is working then QuickBooks will try to connect with the server.
- If it is successfully done then Quickbooks will open the company file.
- If it is not done successfully then you get an error message that describes the steps you need to solve the issue.
The Folder containing the file is not writable or is not shared
You need to make sure that the folder having the company file should be shared with other users.
No network connectivity
There should be at least one working TCP/IP adapter and then the host-name of the local machine resolvable.
Run IPConfig
You will find the IPConfig tool very useful in verifying the TCP/IP configuration on the computer. This will helps you to solve the problem by using QuickBooks on a network.
We have mentioned the most common IPConfig commands below:
| Command | Description |
| ipconfig | You will get basic TCP/IP information |
| ipconfig /all | It is for detailed TCP/IP information |
| ipconfig /renew | To renew the IPv4 address for all network adapters |
| ipconfig /release | To release the IPv4 address for all network adapters |
To run ipconfig:
- First you need to select the Windows Start button.
- Then you need to enter CMD in search field.
- Then choose the Command Prompt in the result showing on the screen.
- Now at the command prompt you need to enter ipconfig and then press Enter.
Network problem: If IP reverse lookup has failed.
You need to make sure that if your windows can produce an IP address from a host-name and reverse the process.
IF QBCFMonitorService/QBDBMgrN not working properly or Firewall is Blocking QuickBooks
You can encounter the issues if your firewall block the internet access required for the specific QuickBooks programs or files. If you are updating your firewall to the latest release will help you to resolve the issue or you will require manually configure exceptions and ports needed for your firewall software.
If QBCFMonitor Service is not running:
- First, you need to configure your firewall to open the 8019 port for the tool as well as QuickBooks applications on the client and server.
- You should make sure that the server hosting is turn on.
- You need to ping the server. It should be successful from the client and the server.
If QBDBMgrN is not running:
- First of all you need to configure your firewall to open the Dynamic database port for the QuickBooks File doctor, and entire application of QuickBooks. You should configure your firewall on all client computers and server.
- You need to make sure that your hosting is turn on on the server.
- Make sure that you will be able to ping the server with iP as well as hostname on the server and all client computers.
[Firewall software] is Active can be blocking QuickBooks:
If you have found any third party firewall then it should be listed here. You need to configure the firewall exceptions for your QuickBooks version.
QuickBooks Enterprise Solutions
You need to grant the following files accessible through your firewall on ports 80,8019, 56725-56728, and 55363 by 55382 for both the traffic (incoming and outgoing).
- An AutoBackupExe.exe File should be placed in C:\Program Files\Intuit\QuickBooks Enterprise Solutions XX.X
- Dbmlsync.exe File should be placed in C:\Program Files\Intuit\QuickBooks Enterprise Solutions XX.X
- DBManagerExe.exe File should be placed in C:\Program Files\Intuit\QuickBooks Enterprise Solutions XX.X
- FileManagement.exe File should be placed in C:\Program Files\Intuit\QuickBooks Enterprise Solutions XX.X
- FileMovementExe.exe File should be placed in C:\Program Files\Intuit\QuickBooks Enterprise Solutions XX.X
- IntuitSyncManager.exe File should be placed in C:\Program Files\Common Files\Intuit\Sync
- QBCFMonitorService.exe File should be placed in C:\Program Files\Common Files\Intuit\QuickBooks
- QBDBMgrN.exe File should be placed in C:\Program Files\Intuit\QuickBooks Enterprise Solutions XX.X
- QBGDSPlugin.exe File should be placed in C:\Program Files\Intuit\QuickBooks Enterprise Solutions XX.X
- QBLaunch.exe file should be placed in C:\Program Files\Common Files\Intuit\QuickBooks
- QBServerUtilityMgr.exe File should be placed in C:\Program Files\Common Files\Intuit\QuickBooks
- QBW32.exe File should be placed in C:\Program Files\Intuit\QuickBooks Enterprise Solutions XX.X
- QBUpdate.exe File should be placed in C:\Program Files\Common Files\Intuit\QuickBooks\QBUpdate
- QuickBooksMessaging.exe File should be placed in C:\Program Files\Intuit\QuickBooks Enterprise Solutions XX.X
- OnlineBackup.exe File should be placed in C:\Program Files\QuickBooks Online Backup
You need to follow the instructions given in the QuickBooks file list that is written above in combination with the detail on the website of the firewall maker to get configured your firewall to allow internet access to the QuickBooks files.
| Program | Steps |
| McAfee Personal Firewall | You need to check how to configure the McAfee Personal Firewall to allow inbound connections on a particular port to get detailed instructions given by McAfee support to configure your firewall. You can found the Additional support option in mcafee.com and you can select your type of business and the support option from the list. |
| Norton Firewall Products | You need to check Norton Search Solutions Library to search for the complete instructions given to configure your firewall. You will need to follow the below steps: First, you need to select your product from the drop-down list. Then select your version from the drop-down list. Now you need to enter the create firewall rule in the search box. Then you can see that your search results will display the knowledge base article Creating a new firewall rule in Norton product. Then you need to follow the instructions given by Norton technical support. |
| Trend Micro PC-cillin | You need to check the Trend Micro support for more detail. You will need to do: First, select your product. Now you have to choose the Search option. |
| Microsoft Windows Firewall | You need to check the Microsoft Support website for detail. You will need to choose first your product from the drop-down list. Then in the Search box, you need to enter opening ports in the firewall. |
| Avast On-Access Protection | If you are having Terminal services and have the Avast on-Access protection turned on then you should exclude a file and the files that required internet access from the on-access protection. |
QuickBooks Pro and Premier
You need to give the below files access by your firewall on ports 80, 8019, 56725-56728, and 55363bby 55382 for incoming and outgoing traffic.
- An AutoBackupExe.exe file should be placed in C:\Program Files\Intuit\QuickBooks 20XX
- Dbmlsync.exe file should be placed in C:\Program Files\Intuit\QuickBooks 20XX
- DBManagerExe.exe file should be placed in C:\Program Files\Intuit\QuickBooks 20XX
- FileManagement.exe file should be placed in C:\Program Files\Intuit\QuickBooks 20XX
- FileMovementExe.exe file should be placed in C:\Program Files\Intuit\QuickBooks 20XX
- IntuitSyncManager.exe file should be placed in C:\Program Files\Common Files\Intuit\Sync
- QBCFMonitorService.exe file should be placed in C:\Program Files\Common Files\Intuit\QuickBooks
- QBDBMgrN.exe file should be placed in C:\Program Files\Intuit\QuickBooks 20XX
- QBGDSPlugin.exe file should be placed in C:\Program Files\Intuit\QuickBooks 20XX
- QBLaunch.exe file should be placed in C:\Program Files\Common Files\Intuit\QuickBooks
- QBServerUtilityMgr.exe file should be placed in C:\Program Files\Common Files\Intuit\QuickBooks
- QBW32.exe file should be placed in C:\Program Files\Intuit\QuickBooks 20XX
- QBUpdate.exe file should be placed in C:\Program Files\Common Files\Intuit\QuickBooks\QBUpdate
- QuickBooksMessaging.exe file should be placed in C:\Program Files\Intuit\QuickBooks 20XX
- OnlineBackup.exe file should be placed in C:\Program Files\QuickBooks Online Backup
You need to follow the instructions included in the QuickBooks file list that is given above in combination with the detail on the website of the firewall maker to configure the firewall to get internet access to the QuickBooks file.
| Program | Steps |
| McAfee Personal Firewall | You need to how you can configure the McAfee Personal Firewall to all inbound connections on specific ports for the detailed information given by McAfee support to configure your firewall. You can get additional support to configure your firewall and you can select your type of business and support option from the list. |
| Norton Firewall Products | You need to check the Norton Search Solutions Library to search for detailed information to configure your firewall. You have to do the below steps: Initially, you need to select your product from the list. Then select the version you required from the list. Now go to the Search box, and then enter create a firewall rule. Now you can see your search result on the knowledge base article Creating a new firewall rule in Norton product. Then you need to follow the instruction given by Norton Technical support. |
| Trend Micro PC-cillin | Check the Trend Micro support for more detail. You will need to do: Select your product first. Then select the Search box. |
| Microsoft Windows Firewall | Check the Microsoft Support for instructions. You have to choose your product from the list. Now In the Search box, you need to enter opening ports in the firewall. |
| Avast On-Access Protection | If you can use the Terminal Services and can have the Avast On-Access protection enabled then you should have exclude your company file and the files that would be required Internet access for your above-listed version |
Winding Up!!
At the end of this article, we discussed how to resolve network issues with QuickBooks File Doctor test results. We hope that you read and understand the article thoroughly and apply the same to resolve the network issues with QuickBooks File Doctor