Troubleshoot QuickBooks File Over a Network

Solution 1 :- Download QuickBooks File Doctor

  1. Download, install and run the QuickBooks File Doctor. (Click Here).
  2. If you still see the error go to Solution 2.
  3. If you can open you file by copying it to a different folder or computer, proceed to solution 2 or 3.

Solution 2 :- Configure Windows Firewall

Windows 7, Windows 8, Server 2008, and Server 2012:

  1. Click the Start menu and type firewall.
  2. Click on Windows Firewall.
  3. On the right-hand side, click on Advanced Settings.
  4. Click on Inbound Rules to highlight it.
  5. Right-click on Inbound Rules and select New Rule.
  6. Select Port and click Next.
  7. Make sure TCP is selected and type in the following ports for your year of QuickBooks: (if you have multiple years of QuickBooks installed or will be using, you will need to add each year's ports as well in this format: 8019, XXXXX, XXXXX, XXXXX, XXXXX).
    1. QuickBooks 2016: 8019, 56726, 55368-55372
    2. QuickBooks 2015: 8019, 56725, 55363-55367
    3. QuickBooks 2014: 8019, 56724, 55358-55362
    4. QuickBooks 2013: 8019, 56723, 55353-55357
  8. Click Next and make sure Allow the Connection is selected, then click Next again.
  9. Click Next again and give the rule a name, such as QBPorts. Click Finish when done.
  10. Repeat the steps above for the Outbound Rules (for step 4 inbound rules, choose Outbound Rules).
  11. Try opening QuickBooks again in multi-user mode or over your network to see if the issue has been resolved.

Server 2003:

  1. Click the Start menu and choose Control Panel.
  2. Double-click on Firewall.
  3. Click the Exceptions button.
  4. Click Add Port.
  5. Make sure TCP is selected and type in the following ports for your year of QuickBooks: (if you have multiple years of QuickBooks installed or will be using, you will need to add each year's ports as well in this format: 8019, XXXXX, XXXXX, XXXXX, XXXXX).
    1. QuickBooks 2016: 8019, 56726, 55368-55372
    2. QuickBooks 2015: 8019, 56725, 55363-55367
    3. QuickBooks 2014: 8019, 56724, 55358-55362
    4. QuickBooks 2013: 8019, 56723, 55353-55357
  6.  Click OK when finished.
  7. Try opening QuickBooks again in multi-user mode or over your network to see if the issue has been resolved.

Solution 3 :- Manage AntiVirus Programs

Configure your 3rd Party AntiVirus/Firewall Programs :

(do this only if configuring the Windows Firewall does not resolve the issue) :

Intuit does not support or maintain steps on the various internet security programs on the market today. In most cases, you should be fine just adding the ports above to the Windows Firewall. If you still encounter errors opening a file over a network or multi-user problems, you may want to try adding the following executable/directories to your 3rd party virus program.

Add the following ports to your 3rd party Antivirus/Firewall:

Make sure TCP is selected and type in the following ports for your year of QuickBooks: (if you have multiple years of QuickBooks installed or will be using, you will need to add each year's ports as well in this format: 8019, XXXXX, XXXXX, XXXXX, XXXXX.

  • QuickBooks 2016 :- 8019, 56726, 55368-55372
  • QuickBooks 2015 :- 8019, 56725, 55363-55367
  • QuickBooks 2014 :- 8019, 56724, 55358-55362
  • QuickBooks 2013 :- 8019, 56723, 55353-55357

Add the following executables to your 3rd party Antivirus/Firewall:

Note :- If you see Program Files (x86), go there as that means you are on a 64bit OS.

  • AutoBackupExe.exe located in C: > Program Files > Intuit YOUR QUICKBOOKS YEAR
  • Dbmlsync.exe located in C: > Program Files > IntuitYOUR QUICKBOOKS YEAR
  • DBManagerExe.exe located in C: > Program Files > IntuitYOUR QUICKBOOKS YEAR
  • FileManagement.exe located in C: > Program Files > IntuitYOUR QUICKBOOKS YEAR
  • FileMovementExe.exe located in C: > Program Files > IntuitYOUR QUICKBOOKS YEAR
  • IntuitSyncManager.exe located in C: > Program Files > Common FilesIntuitSync
  • QBCFMonitorService.exe located in C: > Program Files > Common FilesIntuitQuickBooks
  • QBDBMgrN.exe located in C: > Program Files > IntuitYOUR QUICKBOOKS YEAR
  • QBGDSPlugin.exe located in C: > Program Files > IntuitYOUR QUICKBOOKS YEAR
  • QBLaunch.exe located in C: > Program Files > Common FilesIntuitQuickBooks
  • QBServerUtilityMgr.exe located in C: > Program Files > Common FilesIntuitQuickBooks
  • QBW32.exe located in C: > Program Files > IntuitYOUR QUICKBOOKS YEAR
  • QBUpdate.exe located in C: > Program Files > Common FilesIntuitQuickBooksQBUpdate
  • QuickBooksMessaging.exe located in C: > Program Files > IntuitYOUR QUICKBOOKS YEAR
  • OnlineBackup.exe located in C: > Program Files > QuickBooks Online Backup

For steps on how to configure 3rd party AntiVirus/Firewall programs, refer to the following for support:

Intuit is unable to supply information for all of the several hundred firewall programs available today, as you will need to refer to the links below on how to configure your 3rd party internet security program. If your Antivirus/Firewall is not listed here, refer to your software's documentation or the software publisher's web site for support.

  • McAfee
  • Norton/Symantec
  • Trend Micro
  • Avast!
  • AVG
  • CA eTrust
  • Viper
  • WebRoot

Solution 4 :- Check for standby or hibernation mode on the host computer.

Check the host computer. If it is in standby or hibernation mode, it can disrupt the QuickBooks connection with your company file, and you may want to disable or reconfigure those settings to prevent the connection from being disrupted in the future. Double-click Power Options in Windows Control Panel to modify the standby and hibernation settings. Consult your computer's user manual or Windows help system for details and information.

Solution 5 :- Fix damaged network data files (*.nd).

A network data file (.nd file extension) is a configuration file that allows access to a QuickBooks company file in a network environment.

On the computer that is hosting the QuickBooks company file:

  1. On your keyboard, press Windows + E to open Windows Explorer.
  2. Browse to the folder that contains the Company File.
  3. Right-click the file that has the same name as your company file and the file extension .nd (for example "MyCompanyFile.nd") and select Rename.
  4. Change the file extension to .ndold (for example "MyCompanyFile.ndold") and press Enter.
  5. Open QuickBooks and open the company file. QuickBooks will create a new network data file for the company file.

Solution 6 :- Toggle hosting off and on at the host computer

On the computer that is hosting the QuickBooks company file:

  1. Open QuickBooks and open the company file.
  2. Choose File >Switch to Single User Mode.
  3. Choose File >Utilities > Stop Hosting Multi-user access.
  4. Choose File >Utilities > Host Multi-user access.
  5. Choose File >Switch to Multi-User Mode.

Note :- If you can't toggle hosting off and on, restart the computer in Safe mode with networking and try again.

Solution 7 :- Stop and restart the QuickBooks database service

On the computer that is hosting the QuickBooks company file :

First Stop the database server process, steps will depend on windows version :

Windows 8, 8.1 & 10

  1. On your keyboard, press Windows and type Task Manager.
  2. Click Task Manager.
  3. Right-click qbdbmgrn.exe and select End Task.
  4. Repeat step 3 to stop all instances of qbdbmgrn.exe if it appears on the list more than once.
  5. Close Task Manager.

Windows 7, and Vista :

  1. Right-click a blank space on the Windows taskbar and select Task Manager.
  2. Click the Processes Tab.
  3. Click the Image Name column heading to sort the entries alphabetically.
  4. Right-click qbdbmgrn.exe and select End Process.
  5. Repeat step 4 to stop all instances of qbdbmgrn.exe if it appears on the list more than once.
  6. Close Task Manager.

Now database server process completed, Open the Computer Management window :

  1. On your keyboard, press Windows + R to open the Run window.
  2. Enter compmgmt.msc and press Enter.
  3. Restart the database server process:
    1. In the Computer Management window, click the "+" symbol next to Services and Applications to expand the section.
    2. Select Services.
    3. In the Services window, click the Name column heading to sort the entries alphabetically.
    4. Right-click the appropriate service for your QuickBooks version and select Start:
      • QuickBooks 2016 or Enterprise Solutions 16.0 :- QuickBooksDB26
      • QuickBooks 2015 or Enterprise Solutions 15.0 :- QuickBooksDB25
      • QuickBooks 2014 or Enterprise Solutions 14.0 :- QuickBooksDB24
      • QuickBooks 2013 or Enterprise Solutions 13.0 :- QuickBooksDB23
  4.  Close the Computer Management window.

Solution 8 :- Set the correct folder permissions on the host computer

The folder on the host computer containing the QuickBooks company file must allow full control to all users, including the QuickBooks Data Server Manager user (QBDataServiceUser*).

To verify or set folder permissions for QuickBooks users, refer to the appropriate information for your version of Microsoft Windows:

  • Set access permissions for QuickBooks in Windows

Solution 9 :- Repair the QuickBooks installation

  1. Close any open programs.
  2. Insert your QuickBooks CD in the CD drive. If the QuickBooks installation window opens, close it.
  3. On your keyboard, press Windows + E.
    • Note: In Windows 8, click Computer at the top of the window.
  4.  Click Uninstall or Change a program.
  5. In the list of currently installed programs:
    • Windows 8 or 7: Right-click the QuickBooks program you want to repair and selectUninstall/Change.
    • Windows Vista: Right-click the QuickBooks program you want to repair and select Repair.
  6.  When the QuickBooks Installation Wizard opens, click Next.
  7. Select Repair and click Next. QuickBooks repairs the installation.
  8. After the repair is finished, click Finish and then Restart your computer if prompted to do so. If in case not prompted to restart, do it manually.

Solution 10 :- Uninstall and reinstall QuickBooks

If repairing the QuickBooks installation doesn't resolve the issue, perform a clean uninstall and reinstall of QuickBooks.

Solution 11 :- Verify and rebuild the QuickBooks company data

Refer to Verify and rebuild your company file to determine if the company file is damaged.

Note :- If the verify, rebuild, verify finds no integrity violations with your company file, create a new Windows Admin user called Test (see instructions at Microsoft Help & Support site) and log in as this user.

Leave a Reply

Your email address will not be published. Required fields are marked *