Was this page helpful?
Thank you!

Comments or suggestions?


May we contact you? Although a personal response may not be provided, we value your feedback.
Privacy Policy

Enter Email Address (optional)
email

Error -6123, 0

When opening or while using a QuickBooks company file over a network, in multi-user mode, or while restoring a backup, you see one or more of the following errors:

  • -6123,0
  • Connection to the QuickBooks company file has been lost
Why this is happening
This error can occur if:

  • A network connection with the host computer is disrupted.
  • Firewall settings prevent QuickBooks files from accessing the necessary ports.
  • Multiple instances of QuickBooks database service are running.
  • QuickBooks data or program files are damaged.
  • If the computer name where the data file is hosted has been changed while hosting was on.
  • If the McAfee Privacy Service is installed with the Block Web Bugs filter option selected. This filter conflicts with QuickBooks.
  • You are restoring a backup directly from a flash drive or other removable storage device to the local hard drive.
  • Your company file is damaged..
 
How to fix it

Intuit recommends 3 solutions for this problem based on how you are using QuickBooks when you get the error message.. The first solution may solve your problem, or you may need to try all 3 to resolve the issue. For best results, perform the solutions in the order shown.

When opening or while using a QuickBooks company file over a network

Solution 1: Download QuickBooks File Doctor
  1. Download, install and run the QuickBooks File Doctor.
  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: Manually resolve -6123, 0

Before attempting troubleshooting procedures:

  • Restart (reboot) the computer. This closes any programs that might be in conflict, reloads the operating system, and reestablishes network connections.
  • If yours is a single-user installation of QuickBooks, stop multi-user hosting if it is turned on.

If the error still occurs, select the option below that best fits your situation. For example, if you recently installed or updated firewall or antivirus software, you could start by checking the firewall settings. If you are not sure where to begin, step through each solution in order until the issue resolved.

Verify the network connection with the host computer:

If you have a wired network, on both the host computer and the client computer trying to access the company file, check the network connections and cables to make sure they are secure. Verify that other programs or resources located on the host computer are accessible. If not, restarting the host computer and then the client computer(s) may resolve the issue. Note: If restarting the computers consistently resolves the issue, you might have an ongoing connection problem on the network. Because of the complexity and variety of both wired and wireless computer networks, Intuit cannot provide support for your network configuration. Please consult with your system or network administrator (if you have one), the vendor who set up the network, or a local computer consultant to troubleshoot connectivity issues in your computer and network environment.
Check firewall settings


Configure your Firewall and Internet security for updates and network access.
 

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.
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.
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.

Stop and restart the QuickBooks database service

On the computer that is hosting the QuickBooks company file:

  1. Stop the database server process:

    Windows 8
    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, Visa and XP
    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.
  2. Open the Computer Management window:
    • On your keyboard, press Windows + R to open the Run window.
    • 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 2013 or Enterprise Solutions 13.0: QuickBooksDB23
      • QuickBooks 2012 or Enterprise Solutions 12.0: QuickBooksDB22
      • QuickBooks 2011 or Enterprise Solutions 11.0: QuickBooksDB21
      • QuickBooks 2010 or Enterprise Solutions 10.0: QuickBooksDB20
      • QuickBooks 2009 or Enterprise Solutions 9.0: QuickBooksDB19
      • QuickBooks 2008 or Enterprise Solutions 8.0: QuickBooksDB18
      • QuickBooks 2007 or Enterprise Solutions 7.0: QuickBooksDB17
      • QuickBooks 2006 or Enterprise Solutions 6.0: QuickBooksDB
    5. Close the Computer Management window.
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:

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 select Uninstall/Change.
    • Windows Vista: Right-click the QuickBooks program you want to repair and select Repair.
    • Windows XP: Select the QuickBooks version you want to repair and click Change/Remove.
  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 restart your computer if prompted to do so.
Uninstall and reinstall QuickBooks

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

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 login as this user.

When opening QuickBooks in multi-user mode

Errors that occur while setting up or working in multi-user mode can be time-consuming to diagnose and correct. To help investigate and resolve the error, We recommend downloading the QuickBooks Connection Diagnostic Tool, which analyzes whether your computer and network connection are set up properly for multi-user mode. If the tool doesn't help you resolve the error, you can return to this article and try the solution described here.

Use the QuickBooks File Doctor

To resolve this issue manually

If the computer name where the file is hosted has been changed:

  1. Reboot the system and then restart QuickBooks.
  2. Go to File > Utilities > Stop Hosting Multi-User Access
  3. Go to File > Switch to Multi-User Mode

Note: If the company file cannot be opened, the Switch to Multi User Mode will not be available. Please go to File>Utilities>Host Multi-User Access.

If the McAfee Privacy Service is installed:

  1. Open the McAfee Security Center.
  2. Select the Privacy Service tab on the left side.
  3. Select Configure Privacy Service Options, and select the Options tab.
  4. Select the Block Info tab, and uncheck the Block Web Bugs on this Computer option.
  5. Close McAfee Security Center.
  6. Open QuickBooks in multi-user mode.

Note: Intuit does not provide technical support for third-party applications that integrate data with QuickBooks desktop software. Contact the third-party owner, developer, or vendor for questions regarding the data integration process or for technical support for the application that shares data with QuickBooks.

When restoring a backup file

Solution 1:Update QuickBooks to the latest release.

Note: QuickBooks is often updated after it is first released to fix common issues. These release updates are free and easy to download.

Solution 2: Copy the file from removable storage device to your computer before restoring your backup
  1. Copy the .QBB (backup) file from the removable storage unit to your computer's desktop.
  2. Open QuickBooks.
  3. From the QuickBooks File menu, choose Open or Restore Company.
  4. Browse to the local desktop, and chose the backup file.
  5. Click Open.
  6. In the Restore Company To: window, browse to the local desktop and click Save.
  7. Important: This restores your backup on your local computer, rather than a network location. Once the file restores successfully, you may then copy the company file (.QBW) from the local desktop to the desired network location. 
Solution 3: Run rebuild and verify on the original file, then create a new backup

  1. Open the original file the backup was created from.
  2. Go to File > Utilities > Rebuild Data. 
  3. After the rebuild is complete, go to File > Utilities > Verify Data.  
    1. If the verify comes back with the message "No issues detected", proceed to step 5.  
    2. If the file fails the verification, run the Rebuild Data Utiltiy..
  4. Choose local backup.
  5. Save the backup to the desktop.
  6. After the backup is created, move the backup to the removable storage unit.  Once you have the file on the removable storage unit, repeat the steps from Solution 2.  If the error still occurs, continue to Solution 4.  
Solution 4: Create a portable company file from the original file

  1. Open the original file the backup was created from.
  2. Go to File > Create copy.
  3. Select Portable company file.
  4. Save the portable file to the desktop.
  5. After the portable company file is created, move it to the removable storage unit.  Once you have the file on the removable storage unit, repeat the steps from Solution 2 selecting Restore a portable file instead of the backup file option

If none of these solutions resolve the issue, you can read discussions and post messages and questions relating to your issue on the Intuit QuickBooks Community site. You can also review other available QuickBooks support options for additional guidance.

KB ID# SLN40085
5/21/2013 11:51:54 PM
QYPPRDQBKSWS10 9090 Pro 2012 62d7af