Steps to Troubleshoot QuickBooks Error Connection Has Been Lost
QuickBooks is a robust accounting software but sometime it receives some technical glitches and errors that the users are notified of through error messages. One frequent error that QuickBooks users face is “connection has been lost” which may be caused by a difficulty on accessing your company file while opening or using that file on QB desktop.
If you receive the above mentioned you can try the following tips:
- You can restart database server manager.
- Move the company file to a different folder or location.
- You can set power saving feature to never
You may get the following error message in your computer screen:
“The connection to the company file has been lost. QuickBooks must close immediately. Any unsaved data will need to be re-entered.”
In case you use just one computer
- The folder in which the company file is stored may need additional permission.
- A third party software such as an anti-virus may be contradicting with QuickBooks accounting software.
- Perhaps your QuickBooks file is corrupt.
How to Fix QuickBooks Error Connection Has Been Lost Issue
To fix this issue, you would have to follow the given steps in the provided order.
Solution 1: Restart QuickBooks
Solution 2: Restart your PC
Method 3: Used the file repair tool called QuickBooks file doctor
- Go to Intuit’s official website and download and install the QuickBooks file doctor.
- Tap on the icon twice on your desktop to launch it.
- Check the results.
- If there is “No Problem Detected” in the file, your company file has no issue.
- If you see the error, check your data file and build it again if required.
- In case the tool find data damage you can do the following:
If a portable file has your company files:
Generally, a company file is saved on the local drive. It’s not advisable to work on a company file stored on a portable drive like a flash drive. You can try the following steps (at your own risk).
Check your portable drive
- Ensure that your portable drive is connected while you try the following steps:
- Disconnect and reconnect your portable drive.
- Go to My Computer and try finding your QB company file on your removable drive from.
- Saving other computer files to your drive and see if it’s working.
- Check the space availability in your drive. It should have enough free space to store your company file.
Important: In the error persists, perform the steps mentioned above under Use the QuickBooks File Doctor to fix the issue. You can also contact to QuickBooks Error Support Helpline to get the instant help from experts.
If your computer is connected to a different network and your data file in a different computer
- There may be an unstable network connection (non-wired connection).
- The location where the file is stored may need additional permission.
- Firewall may not be allowing access over the network.
- Power saving mode is turned on.
Your network can break in several ways:
- Your computer had a Windows error or a similar issue.
- The server/ host may have a similar issue.
- Your computer may have a connection issue, for example, tables rooters protocols and likes.
For the best results, follow the steps and solutions in order they appear.
Solution 1: Use the QuickBooks File Doctor to Fix the error
- Go to the official website of Intuit, and download and install the QuickBooks file doctor.
- Double click the QuickBooks file doctor icon on desktop to launch the tool.
- Check results.
- If the result shows, “No problem detected in your Company File” your company file is fine. In case the error persists, validate your company data file, and build it again (if necessary). Perform basic “Resolve data damage issues” to do a Verify and Rebuild.
- Do the following method to detect data damage:
- Repair the file if prompted the tool will notify you once the issue is fixed.
- Restore the company files you recently created a back up of.
- Use QuickBooks Auto Data Recovery to recover lost data.
- Contact QuickBooks Customer Support.
Solution 2: Restart Computers
- Restart the server.
Note: Before performing this step, make sure no other device is connected to the network.
- Restart your computer(s).
Solution 3: Check Your Network
Note: QuickBooks does not support Wireless networking as it isn’t very reliable for data like your company file.
- Open or save a different computer file on this server to make sure you have the required access.
- Create and delete MS Excel or WordPad file on that computer.
- In case you are not able to create and delete a non-QuickBooks file in that folder, set up Windows access permissions necessary for QuickBooks.
Note: Please consult a professional in case your network isn’t working or you are not confident in performing the steps provide.
Solution 4: Open power management settings on the server and disable them
- Go to the location where the company file is saved, and open the power management settings in Windows Control Panel:
- Press Windows key on your keyboard.
- Type Power Options, and tap on Power Options from the results.
- Check the host computer and turn off all hibernation, sleep, and standby modes.
- Check Windows help and support for more details about power option.
Solution 5: Fix hosting on all systems
Host computer tasks
QuickBooks Database Server Manager should be installed on the host computer.
Press Windows keys on keyboard, and type QuickBooks.
- If QuickBooks or QuickBooks Database Server Manager doesn’t show up in the list, it insinuates that the program is not installed.
- Check Install, Update and Set Up the QuickBooks Database Server Manager on Intuit’s website.
- Set hosting settings
- If QuickBooks is installed on the host computer:
- Open QuickBooks.
- Select File > Utilities.
- In case you see Stop Hosting Multi-User Access in the menu, hosting is enabled and you can move on to the next step.
- If you see Host Multi-User Access in the menu, select it to enable hosting on this computer, and then move on to the next step.
If QuickBooks accounting software is not installed on the host computer:
- Go to Windows system tray and double-click the QuickBooks Database Server Manager icon
- Click Start key on the keyboard > Go to All Programs > select QuickBooks > select QuickBooks Database Server Manager.
- Click the Database Server tab.
- Make sure your company file shows up in the window below “Currently connected company files and logged in users.”
- Note: If you don’t see that, click the Scan Folders tab and then Help for information about adding the company file.
- Now, close the QuickBooks Database Server Manager window.
Delete and recreate .nd file.
You should scan the folder where the company file is saved to create the Network Descriptor (.nd) file. The *.nd file holds details about the computer that is hosting the file.
- Press Windows key on your keyboard and type QuickBooks Database Server Manager.
- Click on QuickBooks Database Server Manager when the search result appears and then click Add Folder and find the folders that have company files.
- Add all required folders and click Scan.
- The data files show up under QuickBooks company files found.
- Click Close.
- Browse to the folders that store the company files and ensure the file .band was created for every company data file.
Note: In case the QuickBooks Database Server Manager isn’t there in the Programs list, you can uninstall QuickBooks and reinstall selecting the second option.
- Verify that hosting is turned off
- Open QuickBooks.
- Choose File and then Utilities.
- If you see Hosting Multi-User Access in the menu, click on it to disable hosting on this computer and continue with the next step. In case workstation says Stop Hosting Multi-User Access, proceed to fix it.
- If you see Host Multi-User Access in the menu, it means hosting is disabled and you can continue with the next step.
- The workstation should read Host Multi-User Access. If it does, don’t change it.
- Use a UNC path and open the company file
Note: UNC (Uniform Naming Convention): is a common syntax Windows used to describe the location of a network resource, for examples, \\Computer Name\Shared Folder\. In this example, Computer Name would be the name of the server that hosts company file.
Here is how to open the company file using the UNC path:
- Go to QuickBooks > Choose File > Open or Restore Company.
- Click on Open a company file and then Next.
- Click My Network Places in the left pane of the Open a Company window.
- Double-click Entire Network and browse to the location on your server that has the company file stored.
- Select the company file and Open it.
Please make sure you connect to the network using wired connection Configure firewall and also add QuickBooks firewall ports Set up folder permissions in order to share company files to keep this issue from happening again.
We hope you find this article helpful. In case, you have any doubt, questions or if you require support, you can contact us at +1-800-880-6389. We will be more happy to help you out in this.