Error -6123, 0 when updating or opening company file
In multi-user mode while you are updating a company file to a new version of QuickBooks Desktop or while restoring a backup or sometimes opening a company file over a network. You see Error 6123, 0 or "Connection to the QuickBooks company file has been lost".
This error is usually caused by one or more of the following:-
- Opening your company file in a new version of QuickBooks.
- Disrupted network connection with the Host computer.
- Firewall settings prevent QuickBooks Desktop files from accessing the necessary ports.
- Multiple instances of QuickBooks Database Service are running.
- Damaged Data or Program Files of QuickBooks Desktop.
- 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 Desktop.
- You are restoring a backup directly from a flash drive or other removable storage device.
- Your company file is damaged.
- Damaged Windows user.
- You are using QuickBooks Desktop 2016 and a 3rd party Sybase 16 application (ex. IDEXX Laboratories Cornerstone). In this circumstance, you must contact the provider of the 3rd party software for help, or remove it entirely.
Instant Tip :-
- If yours is a single-user installation of QuickBooks, stop multi-user hosting if it is turned on.
- Restart (reboot) the computer. This closes any programs that might be in conflict, reloads the operating system, and re-establishes network connections.
If the error still occurs, try the Steps below that best fits your situation. Following Steps can help you in both Single-User & Multi-User set up
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.
Step 1: 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.
Step 2 : Check firewall settings
Configure your Firewall and Internet security for updates and network access.
- Run the File Doctor. (Click Here)
- Run the QuickBooks File Doctor which will automatically open the correct ports for you.
- Manually configure exceptions and ports to your Firewall.
Step 3 : Toggle Hosting Settings in QuickBooks
- Open QuickBooks Desktop and Open the Company File.
- Choose File > Switch to Single User Mode.
- Choose File > Utilities > Stop Hosting Multi-User access.
- Choose File > Utilities > Host Multi-User access.
- Choose File > Switch to Multi-User Mode.
Step 4 : Rename .ND and .TLG file
.ND is a configuration file that allows QuickBooks Desktop to access the company file in a network environment. While the .TLG is a file containing transaction logs created by QuickBooks for it to keep track of changes to the file since the last backup. Perform the outlined steps below on the Host computer.
- Open the folder where the company file is saved.
- Select right-click the corresponding .ND file of your company file.
- Example: MyCompanyName .qbw.nd
- Right click the .ND file and select Rename.
- Add .old at the end of the file name.
- Example: MyCompanyName .qbw.nd.old
- Do the same steps above for the .TLG file
- Open your QuickBooks Desktop Company file.
Step 5 : Move company file to a different location
To see whether there is a problem with the file path, move the file to the Desktop and open it from that location to see if it works.
- Go to the location of the company file on your computer.
- Right-click on the company file, then select Copy.
- Make sure you copy the correct file with the extention .QBW.
- Go to where you want to copy the file, preferably the Desktop.
- Right-click on a blank space, select New > Folder.
- Open the New Folder, then right-click on a blank space and select Paste.
- Open QuickBooks and access the company file from the new location.
If in case the issue is still there then you may want to check the following 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.
Click Following to see troubleshooting :