Resolving the QuickBooks Connection Has Been Lost issue

QuickBooks is a renowned software used by accountants, businesses, and other entities that require credible bookkeeping. The software keeps a record of all the data processed and uses it for other monetary tasks required for overseeing the finance. QuickBooks also ensures punctual payroll, helps in creating official documents for filing taxes, reliable account reports, and a lot of other tasks needed for a business. Even after so much to offer, the software is still prone to internal issues common in any software. Users may face difficulties accessing their company files and receive a message that QuickBooks Connection Has Been Lost. On the off chance that this issue has also troubled you on your PC, keep reading further to learn about the reasons it develops and ways to get rid of it.

Minor QB issues can transform into problems for your business; prevent any consequences by contacting a QB support team available at 1-855-856-0042.

About the issue

QuickBooks stores the financial data as company files which can be shared or hosted by the server to allow multiple users to connect and work on the data concurrently. Whenever you try to access a company file, the software fetches the file and initiates a connection with the file. Suppose, due to any reason, this connection is interrupted or it lapses. In that case, the software will immediately develop an error, and you’ll see an error message, “The connection to the company file has been lost. QuickBooks must close immediately.” The consequences of this error include lag in the system followed by a software crash. You’ll be barred from accessing your company file until this issue is resolved.

Reasons

Some practical conditions that encourage the development of this error are mentioned below-

• The Database Server Manager has crashed in the background, or the QB program files are corrupted.
• QuickBooks doesn’t have enough permissions to access the company file in its location, or the company file doesn’t exist in the specified location.
• The company file you tried to access is located on a network or portable drive currently disconnected from the system you are working on.
• The company file has been damaged by a malware attack or data corruption in your hard drive, and the file now exists in an unsupported format for QuickBooks.
• QuickBooks is suffering from internal issues, which can be a result of faulty/incomplete installation of the software on your PC.

Solutions

The methods that can effectively counter this error in QuickBooks are listed underneath-

Solution 1- Restart the QuickBooks Database Server Manager

When problems with the Database Server Manager prevent QuickBooks from connecting to the multi-user network, an error is produced when connecting to the company file.. Follow the steps given below to restart the DBSM and get rid of these issues-

1. Go to the control panel using the search panel on the taskbar.
2. Open Administrative Tools and select Services in the list.
3. Find QuickBooksDBXXin the list of services. (XX denotes the QB version).
4. Right-click on the QuickBooksDBXXservice and click Restart.
5. Open QuickBooks and retry opening the company file.

Try the next method if the error pops up again.

Solution 2- Rename the QB program files and scan them in the Database Server Manager

The transaction log(.tlg) file and the network descriptor(.nd) file are crucial program files for QuickBooks. If there are discrepancies in the transaction file data and the company file, the error will occur if the network descriptor file is damaged or missing. You can fix issues in these files by renaming them as they get recreated every time QuickBooks runs. Follow the steps given below-

1. Go to the folder containing your QB files.
2. Look for files with the same name as your company file but with extensions .nd & .tlg.
3. Right-click on the .tlg file and select Rename.
4. Add ‘.old’ at the end of the file name as an extension and save the file.
5. Rename the .nd file too.

After both of these files are renamed, let’s use the steps below to run the Database Server Manager & scan the files to register them on the network.

1. Go to the search panel on the taskbar and type ‘Database.’
2. Open QuickBooks Database Server Manager from the search results.
3. Go to the Scan folders tab and click Browse.
4. Select the folder containing your QuickBooks files and tap Start Scan.
5. Wait for the process to finish and click Ok.
6. Retry opening your company file in QuickBooks.

If you come across the error again, follow the next method.

 

Solution 3- Use the Verify-Rebuild Utility to repair damage in your company file

If your company file is compromised due to data corruption or a virus attack, the software will immediately develop an error as soon as the file is processed. QuickBooks offers a Verify-Rebuild tool that scans the data for any issues and resolves them automatically. Follow the steps given below to use the utility-

1. Open QuickBooks Desktop and click on
2. Select Utilities and tap Rebuild Data.
3. The software will prompt you to back up your data; click Ok if you want to create a backup.
4. The data repair will immediately start after the backup is created.
5. Click Ok when the process is finished, and you receive a message that Rebuild has been completed.

Now, use the Verify data utility to scan the data and check for any other issues.

1. Go to File and select Utilities.
2. Click on Verify Data and wait till the process is finished.
3. If the process finishes, you are good to go, but if you see a message, ‘Your data has failed the integrity check,’ click on Rebuild now.
4. Wait for the process to finish and reopen your company file.

If you are still unable to access the file due to errors, try the following method.

Solution 4- Move your company file to a different location and run your QuickBooks in Administrator mode

This error can also occur if QuickBooks isn’t able to find or access the file in its specified location. This can be due to restrictions from the Firewall or folder permissions. Follow the steps to move the file to a different location and run QuickBooks in Admin mode to prevent any such issues-

1. Go to the folder containing the QuickBooks Desktop company files.
2. Search for your company file with extension .qbw.
3. Right-click on the company file and select the option that says Copy.
4. G to a different location, right-click anywhere in the empty space and select
5. Right-click on the QB icon, select Run as Administrator and try to open your company file from this new location.

Check if the error persists. We have mentioned some important points to keep in mind and try if the company file is located on a portable drive or network. Go through them and check if you have any of the conditions mentioned below-

• Verify that the portable drive is connected to your system.
• Go to the power options from the search panel and disable sleep, standby, and hibernation modes.
• Ensure the server computer is running in multi-user mode and restart your server computer, followed by all the workstations.
• Make sure your network connection is stable and provides an average speed of 3Mbps and 1.5Mbps minimum.

Final note

You read the entire insight of the QuickBooks Connection Has Been Lost issue and now know why your software is suffering. We have provided instructions on how to solve the problem, which you are expected to follow to make your QuickBooks error-free once more.

For any more assistance regarding any queries you have, give a call at 1-855-856-0042 to converse with a QB ProAdvisor expert directly.