QuickBooks fulfills businesses’ demands to much extent with its advanced features. It stores a huge amount of financial data within the company files that users can easily access. There are instances when users face difficulty opening the company file and end up with QuickBooks Connection has been lost error. The error is seen on the screen along with a message, “The connection to the company file has been lost. QuickBooks must close immediately. Any unsaved data will need to be re-entered.” Stopped QuickBooks Database Server Manager is the major cause behind this error. If you are wondering why QuickBooks network connection failure appears, go through the blog to learn about the causes, along with troubleshooting solutions to fix it.
Stressed over QuickBooks connection has been lost error? Don’t worry. Call us on our toll-free number 1.855.738.2784 and get immediate effective assistance from certified QuickBooks professionals
Primary reasons behind QuickBooks Network Connection Failure error
Following are major reasons that bring forth this connection error in QuickBooks:
- The QB Database Server Manager has stopped running on the main server.
- The company file user is trying to access is damaged and needs repair.
- The company file user is trying to access was created on an older version of QuickBooks.
You may read also : Intuit data protect backup failed
Most Reliable Solutions to Fix QuickBooks Connection to server has been lost error
Given below is the list of the most reliable and effective solutions to resolve connection error in QuickBooks:
Solution 1. Run Quick Fix my Program from the QB Tool Hub to eliminate common program issues
- Close company files before you quit the QuickBooks Desktop application and then open your web browser.
- From the browser, download the setup file of the recent QuickBooks Tool Hub version and save it to an easily accessible location when prompted.
- Find the file, double-click to open it, and perform the on-screen steps. Agree to the terms and conditions to install the QuickBooks Tool Hub successfully.
- After finishing the installation, open the QuickBooks Tool Hub by double-clicking the icon and go to the Program Problems tab.
- Click Quick Fix my Program and let the tool resolve issues within QuickBooks.
Solution 2. Get QB Tool Hub and run File Doctor to fix company file and network issues
- From the QuickBooks Tool Hub, click the Company File Issues tab and choose Run QuickBooks File Doctor.
- Wait till the File Doctor opens. It may take around a minute, and then scroll the drop-down to choose your company file.
- If you can’t see your data file there, click Browse and search it on your device.
- Choose the middle Check your file option, click continue and enter QuickBooks login credentials.
- Wait until File Doctor starts and repair your company file data and resolve network issues.
- When the tool finishes, open QuickBooks and your company file.
Solution 3. Enable hosting on the main server
- On each workstation, open QuickBooks and go to the File menu.
- Choose Utilities. If the Host Multi-User Access option is in the list, this one is not hosting the company file, move to the next computer.
- If you see the Stop Hosting Multi-User Access option, select it to turn off hosting on the workstation.
- Follow the same steps to change settings on each workstation and disable hosting
- Click the Windows icon to open the Start menu and open Internet Explorer.
- Find the folder containing company files and right-click it.
- Choose Properties, then Sharing, and click Share Add.
- Choose the corresponding QBDataServiceUserXX for the QuickBooks version you use and then set permission to Full Control for both users.
- Finally, select Share.
Solution 5. Go to server manager and turn off power management
- Move to the computer hosting the company file and open the Control Panel.
- To open the Power management settings, tap the Windows key on your keyboard and enter Power Options.
- Choose Power Options from the results and switch off all sleep, standby, and hibernation modes on the server computer.
Solution 6. Make use of QB Auto Data Recovery Tool to recover lost data
- Move to your desktop and make a new folder with the name QB Test and then open the folder containing the company file.
- Within the folder, search for the .tlg file with the same name as that of your company file.
- If you can’t see the file extensions, follow the steps given below to show file extensions:
- Open File Explorer, choose Organize and then select Folder and search options.
- Select View, then File name extension, and click Hide extensions for known file types.
- Click Apply and then OK.
- Copy the .tlg file and paste it to the QBTest folder on your desktop.
- Find and open the QuickBooksAutoDataRecovery folder from the location of your company file.
- From here, copy the .QBW.adr file and paste it to the QBTest folder.
- Now, you have the.QBW.adr file and .tlg file in the QBTest folder.
- Open the QBTest folder, right-click the .QBW.adr file and choose the Rename option.
- Remove .adr from the end of the file name and then open QuickBooks Desktop.
- Next, open the company file you pasted in the QBTest folder and verify all transactions using your account.
- Choose File, select Utilities, and click Verify Data to test the data integrity of the recovered file.
- If this company file is not damaged, transfer its copy to the original location and move the damaged one to a different location.
This article on QuickBooks connection has been lost error ends here. We are hopeful that the solutions discussed above will help you eliminate the issue. If the problem continues even after performing the solutions, get in touch with the QuickBooks support team for assistance by giving us a call at our Toll Free Number.
You may read also : QuickBooks Already Has A Company File Open