Connection Has Been Lost issue is a QuickBooks company file error that arises when the user is unable to access the company file. It asks QuickBooks to close immediately, potentially causing data loss.
Quickbooks stores financial information and records related to business in a company file. When the “Connection Has Been Lost” message appears while opening or working with a company file on QB desktop, you cannot access, retrieve, modify, or store the financial information or data. The damaged company file (the QBWUSER.ini file) is the major root cause of this problem.
This issue may arise due to file corruption, insufficient permissions, or interference from third-party processes. The user will see the following error prompt when facing this issue:
This error states that “The connection to the company file has been lost. QuickBooks must close immediately. Any unsaved data will need to be re-entered”
|The error occurs due to the Portable Storage Drive.
|Ensure that the Portable Drive is connected to the computer because, generally, the company file is stored on a local drive.
|The error occurs due to enabled Power Management Settings
|Turn off the Sleep, Standby, and Hibernation Modes as they disrupt the connection if they are activated on the host computer.
|The error occurs due to the enabled hosting mode.
|Hosting means a computer that has a company file stored allows other computers to access the same file. Turn off the host mode to avoid connection problems.
|The error occurs due to the enabled hosting mode
|Hosting means a computer which has a company file stored allows other computers to access the same file. Disable the host mode to avoid the connection problems.
|The error occurs due to an Antivirus or Firewall
|Please turn off the Firewall, as it can interfere with the communication between QuickBooks and the company file.
Reasons Behind the Problem Connection Has Been Lost in QuickBooks
Users may face the problem while working with company files due to the following reasons:
- Company files are stored on a different system or a portable drive, and the connection to the storage device is disrupted.
- Activated sleep or hibernation mode in the Windows power management settings.
- Corrupted or damaged data within the company file.
- Interference of Antivirus or Firewall with QuickBooks.
- More than one system on a network hosts the QuickBooks company file.
Methods to resolve the error Connection Has Been Lost in QuickBooks.
Method 1: Check the Connection with the Portable Storage Device
It is advisable to keep the company file on the same system on which the QuickBooks desktop is installed.
However, if the File is stored on a portable device or somewhere on the network, there could be a connection issue with that device or network, making the company file inaccessible.
The portable device could be a flash drive (pen drive) or external hard disk, a location on a network.
The portable storage drive in which the company file is saved should be connected to another computer.
Follow the below steps:
- Disconnect and reconnect the drive.
- Find the QuickBooks Company File (QBW) in a removable drive from My Computer.
- Save another File to ensure it’s working.
Note: Make sure that the drive has enough storage space to store the QuickBooks Company File.
Method 2: Disable Power Management Settings on the Server
If the above method does not solve your problem, try turning off the Power Management Settings on the server.
For this, follow the steps:
- Go to the Windows Control Panel and open the Power Management Settings on the system where the company file is stored.
- Press Windows Key.
- Type and select Power Options in the search results
- Turn off Sleep, Standby, or Hibernation Modes on the host computer.
Note: Please refer to the Windows Help and Support Manual for more detailed information about Power Options.
Method 3: Fix the Company File with QuickBooks File Doctor
Run QuickBooks File Doctor to resolve the Connection Has Been Lost issue in QuickBooks.
- Open Tool Hub and select the Company File Issues tab.
- Click on the File Doctor option in the Company File Issues.
- Click on the Company File Diagnose option.
- View the results after the diagnosis process ends.
Note: QuickBooks does not support wireless networking, and it is not reliable for company files. Please follow this step at your own risk.
Method 4: Turn Off Firewall
Firewall can interfere with QuickBooks, which can lead to the problem Connection Has Been Lost. Follow the steps below to turn off the Firewall:
- Press the window button to open the Start Menu.
- Open Firewall settings.
- Select the Advanced Settings in Firewall settings.
- Right-click on the Inbound Rule in Advanced Settings.
- Go to New Rule.
- Select the TCP option.
- Select the Specific local Port in Port.
Note: You need to create the Outbound Rule in a similar way you created the Inbound Rule.
Method 5: Fix Hosting on all Systems
Host system tasks
Make sure QuickBooks Database Server Manager is installed on all the hosting systems. To check this, press the Windows key and type QuickBooks. If nothing appears related to QuickBooks or QuickBooks Database Server Manager, then you need to install it.
- Check Hosting Settings
If QuickBooks is installed on the host system:
- Open QuickBooks File Menu.
- Go to File and select Utilities.
- If “Stop Hosting Multi-User Access” appears in the menu, hosting is already enabled, and you can proceed to the next step.
- However, if “Host Multi-User Access” appears, select it to enable hosting on this computer, and then proceed with the next step.
If QuickBooks is not installed on the host system:
- Double-click the QuickBooks Database Server Manager icon in the Windows system tray (or select Start > All Programs > QuickBooks > QuickBooks Database Server Manager).
- Click on the Database Server
- Make sure your company file shows up in the list of currently connected files. If it’s missing, go to the Scan Folders section and find instructions on how to add it.
- Close QuickBooks Database Server Manager.
- Delete and recreate .nd file:
Scan the folder where your company file is saved. This process creates a file called the Network Descriptor (nd) file. The *.nd file contains important details about the computer hosting your company file.
- Press Windows key
- Type and select QuickBooks Database Server Manager.
- Click Add Folder and look for the folders which store the company file.
- Click Scan after adding all the folders.
- Click on Close (the data files will appear under the QuickBooks company file).
- Browse to the folder that stores the company file and ensure that a file named .band is created for every company data file.
Note: Uninstall and reinstall QuickBooks if QuickBooks Database Server Manager does not appear in the programs list.
Ensure hosting is turned off.
- Open QuickBooks.
- Select Utilities.
- Disable hosting by enabling QuickBooks Single User Mode if Stop Hosting Multi-User Access appears on the list.
- After ensuring that the hosting mode is off on all computers, the user should scan for the ” QuickBooks multi-user mode not working ” error.
Open company file using UNC path
UNC (Uniform Naming Convention) is a way that Windows uses to describe where things are on a network.
For instance, if you want to find a company file, you can use a UNC path like this: \\Computer Name\Shared Folder\. The “Computer Name” part is like the server’s name. To open your company file, follow these steps:
- Open QuickBooks Desktop.
- Select File and Open or Restore Company.
- Select Open a company file.
- Click on Next.
- Click on My Network Places.
- Double-click on the Entire Network.
- Browse to the location on the server.
- Choose Company File and Click on Open.
The error ” Connection Has Been Lost ” in QuickBooks can affect the workflow and cause the company File integrity to fail. This problem can cause QuickBooks to close abruptly and lead to data loss. Incorrect file permissions, unstable network connections, or interference from third-party processes or a firewall can cause a connection issue.
Hopefully, the above-given information is useful for you. But if you still facing any kind of issues with your software and need professional assistance, regarding accounting, bookkeeping & accounting software-related issues then feel free to get in touch with us at +1-802-778-9005, or you can mail to us at: [email protected]