Have you ever encountered the “QuickBooks Connection Has Been Lost” error message? What went wrong and how can it be resolved? This issue, a standard QuickBooks company file error, arises when the user cannot access the company file. QuickBooks may prompt an immediate closure, risking potential data loss. The “Connection Has Been Lost” error typically occurs due to file corruption, insufficient permissions, or interference from third-party processes.
QuickBooks stores critical financial information and business records in a company file. When this error appears while opening or working with a company file on the QuickBooks desktop, you cannot access, retrieve, modify, or store any data. The primary root cause is often a damaged QBWUSER.ini file. This disruption can significantly hinder your ability to use the application effectively.
Ensuring QuickBooks meets user demands for seamless operation with complex business data involves routine updates and upgrades. However, the update process can be precise and complex, sometimes leading to network connection errors. This guide will explore strategies to effectively and efficiently resolve the “QuickBooks Connection Has Been Lost” issue, providing simple steps to fix the problem and maintain smooth business operations.
What is Meant by the “QuickBooks Connection Has Been Lost” Issue?
When using QuickBooks Desktop, users might encounter an error that prevents access to the company file, known as the “QuickBooks Connection Has Been Lost” issue. This error appears with the following message:
QuickBooks Connection Has Been Lost Error Abort
“The connection to the company file has been lost. QuickBooks must close immediately. Any unsaved data will need to be re-entered.”
This message indicates network connectivity issues that make opening the company file challenging.
To address this problem, users can try the following quick tips:
– Restart the Database Server Manager
– Move the file to another folder
– Set the Power Saving option to “Never”
Inaccurate folder permissions, incorrect internet settings in Windows, and firewall configurations can also produce errors such as:
- -6000, -80
- Server Busy
- -6000, -77
- The file you specified cannot be opened. Ensure that another program or a read-only file is not using it. The Windows error was: The system cannot find the path specified.
- -6176, 0
For standalone computer users encountering the “QuickBooks abort lost connection” error, additional tips include:
– Grant additional permissions to the folder where the file is saved.
– Check for corruption in QB files.
– Ensure the antivirus firewall and third-party products do not restrict QuickBooks connectivity.
The “QuickBooks Connection Has Been Lost” error may occur due to:
– Poor internet connectivity
– Insufficient permissions for the folder where the file is saved
– Restrictions from antivirus firewalls and third-party products
– Unstable non-wired network connections
– Enabled power-saving mode
– Corrupted QuickBooks files
– Outdated QuickBooks application
– Multiple systems configured to host the company file on the network
– Storing the company file on an external portable device
– Multiple systems with multi-user mode enabled
Encountering this error can cause significant disruptions. Therefore, it is crucial to understand and eliminate the root causes to resolve the issue effectively.
How to Face the “QuickBooks Connection Has Been Lost” Error due to server ?
To resolve the “QuickBooks Connection has been Lost” error in QuickBooks 2023, implement the following solutions:
Recognize the Symptoms
If you encounter any of the following symptoms in your QuickBooks program or computer device, you are likely facing connection issues:
– Inability to open and operate the company data file
– Repeated occurrence of a similar error on the device
– Server unable to connect with the workstation
– Inability to create or delete non-QuickBooks files or folders
– Device instability when using a wireless connection
– Sudden system crashes or freezes
– Damaged QBWUSER.INI file
– “The connection to the company file has been lost in QuickBooks” error message
– Windows errors or similar issues while running other applications
– Both server and host systems experiencing these problems
– Troublesome computer connections involving cables, routers, protocols, etc.
Troubleshooting Methods
If you’re encountering these signs, use the following expert-recommended solutions to eliminate the issue:
- Restart the Database Server Manager: This can help re-establish the connection between the server and the workstation.
- Move the File to Another Folder: Sometimes, relocating the file can resolve permission or path issues.
- Set the Power Saving Option to Never: This ensures the network connection remains active and stable.
- Grant Additional Folder Permissions: Ensure that the folder containing the company file has sufficient permissions.
- Check for QB File Corruption: Verify and repair any corruption in the QuickBooks files.
- Adjust Antivirus and Firewall Settings: Ensure that your antivirus and firewall are not blocking QuickBooks.
- Use a Wired Connection: Wireless connections can be unstable; using a wired connection might resolve the issue.
- Update QuickBooks: Ensure you are using the latest version of QuickBooks to avoid compatibility issues.
- Verify Network Configuration: Ensure only one system is configured to host the company file on the network.
- Avoid External Portable Devices: Store the company file on a local drive rather than an external device.
- Limit Multi-User Mode: Ensure that only necessary systems have multi-user mode enabled to avoid conflicts.
By following these troubleshooting methods, you can effectively address and resolve the “QuickBooks Connection has been Lost” error, ensuring smoother operations for your QuickBooks application.
How to Tackle the “QuickBooks Connection has been Lost” Error.
To resolve the “QuickBooks Connection has been Lost” error in QuickBooks 2023, follow these solutions:
Method 1: Restart QuickBooks
A simple and often effective fix for the “QuickBooks Connection has been Lost” error is to close and reopen QuickBooks.
Method 2: Restart the System
Sometimes, updates do not take effect until you restart your computer. Ensure you restart Windows after installing updates.
Method 3: Use the Quick Fix My Program Tool
The Quick Fix My Program tool helps address general errors and glitches that cause issues like “QuickBooks Connection Has Been Lost.” Before running the tool, ensure you exit QuickBooks.
Steps to Run Quick Fix My Program:
1. Download QuickBooks Tool Hub:
– Click the link [HERE](https://example.com) to download the QuickBooks Tool Hub.
– Save the installer file to an easily accessible location.
2. Install QuickBooks Tool Hub:
– Navigate to the download folder and double-click the QuickBooksToolHub.exe file to start the installation.
– Agree to the terms and conditions when prompted and follow the on-screen instructions to complete the installation.
3. Run Quick Fix My Program:
– Open QuickBooks Tool Hub using the desktop icon.
– Go to the “Program Problems” tab.
– Select the “Quick Fix My Program” tool.
– Let the tool run to repair QuickBooks.
By following these methods, you can effectively address and resolve the “QuickBooks Connection has been Lost” error, ensuring a smoother operation of your QuickBooks application.
Method 4: Run QuickBooks File Doctor for Issues with the Company File
In rare cases, connection errors in QuickBooks may result from damage to the company file.
Follow these instructions to run QuickBooks File Doctor and fix any issues:
QuickBooks File Doctor
1. Open QuickBooks Tool Hub:
– If you haven’t already, download and install QuickBooks Tool Hub. Open the tool using the desktop icon.
2. Access Company File Issues:
– Click the “Company File Issues” tab within QuickBooks Tool Hub.
3. Run QuickBooks File Doctor:
– Select “QuickBooks File Doctor” and choose the appropriate options to repair the company file.
4. Review the Results:
– If the message “No problem detected in your company file” appears, click “OK.”
– If the error persists, use the Verify and Rebuild Data utilities.
5. When Data Damage is Detected:
Follow these steps if QuickBooks File Doctor detects data damage:
– Repair the File: Allow the tool to fix your file.
– Restore Backup: Restore the most recent backup of your company files.
– Use QB Auto Data Recovery: Utilize QuickBooks Auto Data Recovery to recover lost files.
– Seek Expert Help: Contact QuickBooks Technical Experts for further assistance.
6. Verify Error Resolution:
– Once the file is repaired, try accessing it on the local machine or server to ensure the error is resolved.
By running QuickBooks File Doctor, you can identify and repair any damage to your company file, helping to resolve connection errors and improve the functionality of your QuickBooks application.
Method 5: Host Multi-User Access
Ensure your server runs in Multi-User mode and your workstations are in Single-User mode to resolve connection errors.
Host Multi-User Access
1. Configure Workstations:
– On each workstation (excluding the hosting computer), open QuickBooks.
– Click on the “File” menu and select “Utilities.”
2. Check Multi-User Access:
– Look for the option “Host Multi-User Access” in the list.
– If you see “Stop Hosting Multi-User Access,” click on it to disable hosting on that workstation.
By ensuring that only the server is hosting in Multi-User mode and all workstations are in Single-User mode, you can prevent connection errors and improve the performance and reliability of QuickBooks in a networked environment.
Method 6: Check the Portable Drive
While it is generally recommended to store your company file on a local drive, you may choose to use a portable device, such as a USB drive or external hard disk. If you decide to do so, please proceed with caution and be aware of the risks involved.
If your company file is stored on an external storage device, ensure the drive is correctly connected and operational. Additionally, consider the following points to avoid issues when accessing the file from a portable drive:
1. Properly insert the removable device. You can try:
– Disconnecting and reconnecting your drive.
– Locating your QuickBooks company file on your removable drive via My Computer.
– Saving other files to the drive to ensure it is functioning correctly.
2. Verify that your drive has sufficient available space. It should have at least double the free space of your company file size.
Method 7: Check Your Network
If your company file is stored in a network folder, you need to ensure that your system has access to that specific folder on the network drive. Follow these steps to verify access:
- Open or save another company file on the server to confirm you have the necessary access.
- Try creating and deleting Microsoft Excel or WordPad files in the network folder.
- If you cannot create and delete a non-QuickBooks file in that folder, set up the Windows access permissions required for QuickBooks.
- Check if resolving any network access issues helps fix the QuickBooks connection has been lost error.
Method 8: Run QuickBooks Auto Data Recovery
If QuickBooks cannot establish a connection due to data corruption, the QuickBooks Auto Data Recovery Tool can help resolve the issue. Follow these steps to download, install, and run the tool to address connection problems caused by data corruption:
- Attempt to access the company file. If the issue persists, proceed with data recovery using the QuickBooks Auto Data Recovery Tool.
- Refer to our comprehensive guide on recovering lost QuickBooks data using the QuickBooks Auto Data Recovery Tool for detailed instructions.
Method 9: Employ Verify and Rebuild Data Utility
Should the QuickBooks connection error arise due to a damaged company file, utilize QuickBooks’ Verify and Rebuild Data utilities. Here’s how:
QuickBooks Verify and Rebuild Data Utility
- Open QuickBooks Desktop and access the File menu.
- Choose Utilities, then Verify Data.
- Allow the scan to identify errors in both the application and company file.
- If errors are detected during the verification scan, proceed to run the Rebuild Data utility. Return to the File menu in QuickBooks Desktop.
- Select Utilities, then Rebuild Data.
- Let the scan execute, rectifying any errors found in the company file.
Method 10: Reboot All Network Computers
When grappling with the QuickBooks connection loss, consider rebooting both the server and workstation computers. Often, a simple refresh can resolve the issue effectively. To proceed:
- Restart the server, ensuring no other computers are connected during the process.
- Similarly, restart each workstation accordingly to address the error.
Method 11: Ensure Sufficient Permissions in Multi-user Mode
When operating in multi-user mode, proper Windows permissions are essential for accessing files. Without them, you may encounter errors like the QuickBooks connection loss. To prevent this, adjust these settings. But before proceeding, consider the following:
- Verify that installation directories have the requisite permissions.
- If using Microsoft Windows Home edition, note that the security tab might not be visible in normal mode. Switch to safe mode:
- Restart your computer and press the F8 key until the Advanced Boot window appears.
- Select Safe Mode and press Enter.
- Note that the QB Desktop version determines QBDataServiceUserXX. For example, QuickBooks Desktop version 2019 corresponds to QBDataServiceUser19.
- Be aware that enabling multi-user access on workstations might inadvertently trigger Alternate Hosting mode, restricting other users’ access to company files.
Ensure Proper Permissions Setup
To configure folder permissions accurately, follow these steps:
1. Navigate to the Windows Start menu and select File Explorer.
2. Right-click on the folder containing the company file and choose Properties.
3. In the Security tab, click on Advanced.
4. Select QBDataServiceUserXX and click Edit.
5. Set the following permissions to Allowed:
– Traverse Folder/Execute File
– Read Attributes
– Create Files/Write Data
– List Folder/Read Data
– Create Folders/Append Data
– Write Attributes
– Read Extended Attributes
– Read Permissions
– Write Extended Attributes
If permissions are incorrectly configured, follow these additional steps:
1. Locate the folder where your company file is stored and right-click on it.
2. Select Properties.
3. Click on Security, then Edit.
4. Choose QBDataServiceUserXX. Select Full Control, then Allow.
5. Click Apply and OK.
Adjust Folder Permissions
To resolve the QuickBooks connection loss error, consider modifying folder permissions as outlined below:
1. Open File Explorer from the Windows Start menu.
2. For each of the following folders, locate, right-click, and perform the next steps:
– C:\Program Data\Intuit\Entitlement Client
– C:\Program Data\COMMON FILES\INTUIT\QUICKBOOKS
– C:\Users\Public\Public Documents\Intuit\QuickBooks\Sample Company Files\QuickBooks Enterprise Solutions X.0 (X = version) or C:\Users\Public\Public Documents\Intuit\QuickBooks\Sample Company Files\QuickBooks 20XX (XX = year)
– C:\Program Data\Intuit\Entitlement Client\v6.0
– C:\Program Data\Intuit\Entitlement Client\v5
– C:\Program Data\Intuit\Entitlement Client\v8
– C:\Program Data\Intuit\Entitlement Client\v3
– C:\Program Data\COMMON FILES\INTUIT
– C:\Users\Public\Public Documents\Intuit\QuickBooks\FAMXX (XX = year)
– C:\Program Data\Intuit\QuickBooks Enterprise Solutions X.0 (X = version) or C:\Program Data\Intuit\QuickBooks 20XX (XX = year)
– C:\Users\Public\Public Documents\Intuit\QuickBooks\Company Files
3. After right-clicking each folder, select Properties.
4. In the Security tab, choose Everyone. If Everyone is not listed, click Add, type “Everyone” in the box, then click OK.
5. Select Full Control, then click Apply and OK.
Procedure 12: Managing Hosting Across All Computers
To resolve the QuickBooks connection loss error, ensure that hosting settings are configured correctly on all computers. Follow these steps for both host computers and workstations:
Host Computer Tasks:
To manage hosting on the server, follow these steps:
1. Install QuickBooks Database Server Manager on the host computer (server).
a. Press the Windows key on the keyboard and search for QuickBooks.
b. If QuickBooks or QuickBooks Database Server Manager is not listed, it indicates they are not installed on the computer.
Managing Hosting Settings:
If QuickBooks is installed on the host computer, follow the steps outlined in Method 5.
If QuickBooks is not installed on the host computer (server), follow these steps:
1. In the Windows system tray, locate QuickBooks Database Server Manager and double-click to open. Alternatively, navigate to the Start menu > All Programs > QuickBooks > QuickBooks Database Server Manager.
2. Click on the Database Server tab.
3. Check if your company file appears under the Currently connected company files and logged-in users section. If not found, click the scan folders tab, and then select Help for instructions on adding the company file.
4. Close the QB Database Server Manager window.
Deleting and Recreating the .ND File:
The .nd file contains information about the computer hosting the file. Follow these steps to recreate the Network Descriptor (.nd) file by scanning the folder containing your company file:
1. Press the Windows icon on the keyboard and search for QuickBooks Database Server Manager.
2. Open QuickBooks Database Server Manager, select Add folder and locate the folders containing the company files.
3. After adding all folders, click on Start Scan.
4. Once the QB company files are detected, close the window.
5. Verify that the .nd file is created for each company data file by checking the folders with company files.
Note: If QuickBooks Database Server Manager is not listed in the Programs list, uninstall QuickBooks and reinstall it. Select the option “I’ll be using QuickBooks on this computer, AND I’ll be storing our company file here so it can be shared over our network.”
Workstation Tasks:
Perform the following actions:
1. Disable hosting on the workstation by following these steps:
a. Open QuickBooks Desktop.
b. Go to the File menu and select Utilities.
c. If you see the option “Stop Hosting Multi-user Access” in the menu, select it to disable hosting on this computer. Then, proceed to the next step. However, if you see the option “Host Multi-user Access,” click on it to rectify the setting.
d. If the “Host Multi-user Access” option appears, it indicates that hosting is already disabled. You can proceed with the subsequent steps. If the workstation displays “Host Multi-user Access,” leave it unchanged.
2. Open the company file using a UNC Path.
Access the company file through the UNC path using the following steps:
1. Launch QuickBooks and navigate to the File menu.
2. Select File, then Open or Restore Company.
3. Choose to open a company file and click Next.
4. In the left pane of the open company window, select My Network Places.
5. Double-click on Entire Network and navigate to the location on the server where your company file is stored.
6. Select your company file and click Open.
Method 13: Configuring Firewall Settings
When your Firewall and antivirus software restrict QuickBooks connectivity, it’s essential to review the settings and add QuickBooks ports as exceptions. If you need to add multiple versions of QuickBooks Desktop on the same computer, follow these steps:
1. Open the Start menu and search for “Windows Firewall” to access the settings.
2. Select “Advanced Settings” from the options.
3. Right-click on “Inbound Rules” and choose “New Rule.”
4. Select “Port” and proceed to the next step.
5. Make sure to select the TCP option.
6. In the specific local ports field, enter the ports according to your QuickBooks Desktop version:
– QuickBooks Desktop 2020 and later: 8019, XXXXX.
– QuickBooks Desktop 2019: 8019, XXXXX.
– QuickBooks Desktop 2018: 8019, 56728, 55378-55382.
– QuickBooks Desktop 2017: 8019, 56727, 55373-55377.
Note: QuickBooks Desktop 2019, 2020, and future versions use dynamic ports, which are specific firewall ports assigned during installation to ensure exclusive use by QuickBooks Desktop.
7. After entering the port numbers, proceed to the next step.
8. Choose “Allow the Connection” and select “Next.”
9. Make sure to select all profiles if prompted and click “Next.”
10. Create a rule and give it a name like “QBPorts(year).”
11. Once completed, select “Finish.”
12. Repeat the same steps for “Outbound Rules.”
After completing these steps, launch QuickBooks Desktop and switch to multi-user mode to check if the “QuickBooks connection has been lost” error persists.
Creating Windows Firewall Exceptions for QuickBooks
As QuickBooks utilizes executable files for various tasks, it’s important to create exceptions for them:
1. Open the Start menu and search for “Windows Firewall.” Press Enter when the results appear.
2. Click on “Advanced Settings” and right-click on “Inbound Rules.”
3. Select “New Rule.”
4. Choose “Program” and proceed to the next step.
5. Opt for “This Program Path” and click on “Browse.”
6. Locate and select any executable file associated with QuickBooks, then click “Next.”
7. Select “Allow this connection” and proceed to the next step.
8. Make sure all profiles are selected if prompted, then click “Next.”
9. Create a rule and name it something like “QBFirewallException.exe.”
Conclusion
The solutions outlined above should typically suffice to resolve the “QuickBooks Connection Has Been Lost” error. However, if you encounter any difficulties or need further assistance, technical support is available through the provided Support Number.