Resolve Network & Connection Failure Issues With QuickBooks File Doctor

want to resolve network and connection failure issues using QuickBooks File Doctor? Then you are to read this article since we have provided all related information in this article. This tool has lots of time-saving features and is easy to use. So, go through the article to understand the error in a better way and follow the steps of the solution to fix the error, learn the solutions and implement them in the same way. For more info contact our QuickBooks Proadvisor toll-free: [quickboks]

QuickBooks file doctor is an updated version of the connection diagnostic tool which previously is used to help solve some of your network issues like qbdbmgrn not running, QuickBooks cloud hosting mode is off, network connection failure, network access from the workstation is very slow, etc.

Here are possible solutions to resolve various network issues.

When Hosting Mode is Off

You can easily access the company file from the host system or server system by QuickBooks. If QB hosting modes are off then things will not only become difficult but they will create another problem. So it is compulsory to turn on the hosting modes and if you did not face this situation, you would need to follow these requirements.

  • Firstly, you will have have to map the server.
  • Kindly check if your system is set in the multi-user mode or not. If not then set up QuickBooks Online Multi-Users mode.
  • Save your QB company file in a shared folder.

Accessing your Quickbooks files when the network requires Quickbooks Hosting Turnes on.

Important: If you are on the workstation computer then you should ignore this warning.

Turn on hosting

QuickBooks company data files in multi-user mode

Hosting simply means allowing multiple systems (workstations) to access files from the main system over the network. QuickBooks Desktop has a range of services to manage company file access:

  • QuickBooks Desktop 2020 uses QuickBooks DB30
  • QuickBooks Desktop 2019 uses QuickBooks DB29
  • QuickBooks Desktop 2018 uses QuickBooks DB28
  • QuickBooks Desktop 2017 uses QuickBooks DB27

Here is the list of QuickBooks hosting modes:

Dedicated hosting diagram

Dedicating hosting method in QuickBooks

Peer to peer hosting diagram

Peer to Peer hosting method in QuickBooks

Alternate hosting diagram

Alternate hosting method in QuickBooks

How can you access the company file

Before accessing the company file. Remember these conditions:

  • Windows File Permissions: The login user has full control over the system, including permission to look at the data, open it and modifying data.
  • Database server mode: Database Server Mode can open the company file successfully.
  • QuickBooks Online User login: Before accessing the system every user must have the QuickBooks login username and password.

Hosting modes

Hosting mode is available for every version of QuickBooks Desktop and for each system. It is not installed for QuickBooks installation or company file. Hosting mode settings for each version of  QuickBooks 2017 and later versions independently.  

Three types of hosting modes: 1. Not hosting (also known as hosting Off), 2. Hosting local files only, and 3. Hosting local and remote files.

1. Not hosting mode:

  • QuickBooks Database Manager runs always in a normal process: As a Windows User running QuickBooks. 
  • Not hosting mode does not support multi-user mode. In this mode, memory is distributed between the users to communicate with QuickBooks. The important thing to remember is in this mode, only local system QuickBooks users can use a database server to access a file.

2. Hosting local files only mode:

  • In Hosting local files only mode QuickBooks Database Server Manager runs on Windows service named QuickBooksDBXX (where XX is a number from 27 to 30 defined by the version of QuickBooks, as specified under “Hosting defined,” above) and as the Windows user QBDataServiceUserXX (with XX being the same 2-digit number from 27 to 30 that the Windows service uses).
  • As long as the system being on, QuickBooksDBXX service always running.
  • In hosting local files Multi-user mode is supported and using TCP/IP to reach out with QuickBooks. QuickBooks users who are on the remote systems can access company files using access company files with a database server running in Hosting Local Files only mode. 
  • A system in Hosting Local Files only mode can host only those files that are located on that system.

3. Hosting Local & Remote files

  • QuickBooks Database Manager works as a normal process, the user currently logged on Windows user.  The process going until the user logged out from the system.
  • In Hosting Local & Remote system can support multi-user mode, using TCP/IP to data transfer with QuickBooks. QuickBooks users on the remote system can access company files on the local system using the database server.
  • In this mode, the local system can host files stored in it and also stored on the remote system and open on the local system.

How does QuickBooks Desktop decide which database server to interact with?

  1. QuickBooks Desktop search for .nd file. The .nd file has the same name as the company file but with a different QuickBooks file extension (.nd file extension). And place in the same directory whose extension is .qbw. The directory also stored the information to reach the server, like IP address and port. 
  2. QuickBooks Desktop check .qbw file is in use or not.
  3. After searching .nd file and verify that the company file is in use, QuickBooks tries to reach out with the server: 
  • Then communicating QuickBooks opens company file.
  • But if it is not successful, and it shows errors like H101, H202, H303, or H505 while opening the company.

A folder including the file is not writable or not shared

The company file folder must be shared with every other user. And Set up folder and Windows access permissions to share company files to share them, other users.

No network connectivity

One working TCP/IP adapter and the hostname of the local machine is resolvable.

Run IPConfig

IPConfig is very important in verifying the TCP/IP configuration of your system. This help helps to solve network issues using QuickBooks. Some IPConfig commands are:

CommandDescription
ipconfigbasic TCP/IP information
ipconfig /alldetailed TCP/IP information
ipconfig /renewRenew the IPv4 address for all network adapters
ipconfig /releaseRelease the IPv4 address for all network adapters

To run ipconfig:

  • Choose the Window start option.
  • In the search field, choose CMD.
  • Select Command Prompt in the list results.
  • Mention ipconfig in the command prompt and then Enter.

If you want to know more about the IPConfig, insert ipconfig/? in the command prompt.

Network problem: IP reverse lookup has failed

Search that windows can produce an IP address from the hostname and modify the process.

QBCFMonitorService/QBDBMgrN not running or Firewall is Blocking QuickBooks

You may also face networking issues if the firewall blocked internet access for particular QuickBooks files or programs. Issues may also be resolved if you are updating your firewall to the latest release. Or also need to configure firewall ports manually.

QBCFMonitor Service not running:

  • To open 8019 configure your firewall and QuickBooks applications on the client and server for the tool.
  • Make sure server hosting is turn on.
  • Verify the server: A ping should receive from the client and the server.

QBDBMgrN not running:

  • To open the Dynamic database port for QuickBooks File Doctor and all QuickBooks applications configure the firewall. Configure firewalls on all the client systems and on your main server.
  • Make sure hosting is turned on your server.
  • Assured that able to ping the server with both IP and hostname on the server and client systems.

Firewall software is Active may be preventing QuickBooks:

Third-party apps like anti-virus and firewall may also be the reason for this issue. You can make an exception for your version of QuickBooks by configuring the Firewall settings.

For QuickBooks Enterprise Solution

Below is the list of files that needs access on the firewall ports 80, 8019, 56725-56728, and 55363 through 55382. These are the ports for both incoming and outgoing traffic & for the QuickBooks 2018 to QuickBooks 2019.

  • AutoBackupExe.exe located in C:\Program Files\Intuit\QuickBooks Enterprise Solutions XX.X
  • FileManagement.exe located in C:\Program Files\Intuit\QuickBooks Enterprise Solutions XX.X
  • Dbmlsync.exe located in C:\Program Files\Intuit\QuickBooks Enterprise Solutions XX.X
  • FileMovementExe.exe located in C:\Program Files\Intuit\QuickBooks Enterprise Solutions XX.X
  • DBManagerExe.exe located in C:\Program Files\Intuit\QuickBooks Enterprise Solutions XX.X
  • IntuitSyncManager.exe located in C:\Program Files\Common Files\Intuit\Sync
  • QBGDSPlugin.exe located in C:\Program Files\Intuit\QuickBooks Enterprise Solutions XX.X
  • QBCFMonitorService.exe located in C:\Program Files\Common Files\Intuit\QuickBooks
  • QBLaunch.exe located in C:\Program Files\Common Files\Intuit\QuickBooks
  • QBDBMgrN.exe located in C:\Program Files\Intuit\QuickBooks Enterprise Solutions XX.X
  • QBServerUtilityMgr.exe located in C:\Program Files\Common Files\Intuit\QuickBooks
  • QuickBooksMessaging.exe located in C:\Program Files\Intuit\QuickBooks Enterprise Solutions
  • QBW32.exe located in C:\Program Files\Intuit\QuickBooks Enterprise Solutions XX.X
  • OnlineBackup.exe located in C:\Program Files\QuickBooks Online Backup
  • QBUpdate.exe located in C:\Program Files\Common Files\Intuit\QuickBooks\QBUpdate

To allow internet access to the above mentioned QuickBooks files, you need to configure your firewall settings. You can follow the instructions mentioned in the above QuickBooks Files. Here XX denotes the version of your QuickBooks i.e. Enterprise 19.0, in addition to this, you may also need to visit your Firewall software’s website for detailed information on how to make the exception of these files.

Since there are hundreds of Firewall applications are available in the market therefore we won’t be able to provide information on each and every firewall software. Below we have explained the procedure for the most popular and common firewall systems. If you are not able to find your firewall software here then we recommend you to visit the software developer website or contact their customer assistance.

Firewall ProgramSteps
Norton Firewall SoftwareFor detailed information, you need to visit the Norton Search Solutions Library. There you need to find the detailed procedure for configuring the firewall. After going to their website, you have to:
1. Select the drop-down menu and then search for the firewall product that you are using.
2. After that, choose the version of the firewall installed on your system.
3. In the Search bar, type creates firewall rule and then press enter.
Here from the list of knowledge-based articles, you have to find the Creating a new firewall rule in Norton Product. Then, follow the instructions as mentioned in the article carefully to configure the firewall.
McAfee Personal FirewallFirst of all, visit the McAfee official website, and here find an article named How to configure Firewall settings to allow the inbound connections through the specific ports. Here, you’ll find a detailed instruction article by the McAfee support on how to configure firewall ports. If you want a more specific option then go to mcafee.com & select the type of your business and from the drop-down menu select the support option.
Trend Micro PC-cillinFor the detailed information on how to configure the Firewall ports visit the official Trend Micro Support website. Once you open their site:
1. First of all, choose the product that you are using.
2. And then click on Search.
Avast On-Access ProtectionIf you are using the Terminal services of Avast as well as Avast On-Access protection is also enabled then you have to find how to exclude a file from on-access protection? You have to exclude all the files mentioned in the above table to have the internet access to them and also you need to exclude the QuickBooks Company File (.QBW file)
Microsoft Windows FirewallGo to the Microsoft Support official website and then follow the instructions:
1. Click on the drop-down menu and then select the product that you are using.
2. Go to the Search bar and type opening ports in the firewall and then press enter.

Update QuickBooks Desktop

These issues also occur due to problems related to updating. So, you should also examine for any software updates. To make daily update schedules go to the Help menu in QuickBooks Desktop and select for Update QuickBooks Desktop. Continue updates daily and verify & rebuild QuickBooks data files to help get ahead of errors.

The Bottom Line

We hope this article is helpful to you but if you are still facing the issue then you can dial our helpline number +1-844-405-0904 to get immediate help from our team of Intuit certified QuickBooks ProAdvisors.

Reference: https://quickbooks.intuit.com/learn-support/en-us/data-utilities/resolve-network-issues-with-quickbooks-file-doctor-test-results/00/201283

CLOSE
Call Now