Error message: Connection Has Been Lost

You may see the following error while opening or using QuickBooks desktop.

 

 


 

QuickBooks displays this error because it cannot access your company data file. There are several possible causes of the error.

You use a standalone computer

  • The folder where the file is saved may need additional permission

  • A 3rd party process/service from an AntiVirus firewall may be interfering with QuickBooks

  • Your QuickBooks file may be corrupted

Your computer is connected to a network and your data file is stored on another computer

  • The network connection may be unstable (non-wired connection)

  • The folder where the file is saved may need additional permission

  • Firewall is preventing access over the network

  • Power saving mode is turned on

For more assistance : QuickBooks Enterprise support

 


 

Resolve Connection has been lost error

Quick Tip

Tips to resolve the issue:

  • Restart Database Server Manager

  • Move the file to a different folder

  • Set Power saving option to never

Tips to prevent the issue from happening again:

You use a standalone computer

For the best results, follow the steps and solutions in the steps and solutions in the order they appear.

Solution 1: Restart QuickBooks or your computer; restarting may reconnect QuickBooks to the data file.

  1. Restart QuickBooks.

  2. Restart your computer.

Solution 2: Use the QuickBooks File Doctor to fix the error

  1. Download and install the QuickBooks File Doctor. See QuickBooks File Doctor: Fix your company file or network (US, CA, and UK) to use the QuickBooks File Doctor.

  2. When the download is complete, install the tool by double clicking the .exe file.

  3. Launch the tool by double clicking the icon on your desktop.

  4. View the results.

    • If you see No problem detected in your Company File, your company file is OK. If you still see the error, Verify your company data file, and rebuild it if necessary. See Resolve data damage issues (basic troubleshooting) to perform a Verify and Rebuild.

    • If the tool detects data damage, you can:

      • Repair the file. The tool will tell you if it fixed your file.

      • Restore recently backed up company file.

      • Recover lost data with QuickBooks Auto Data Recovery

      • Send your company file to our Data Recovery Team. To request data recovery service from Intuit Data Services, contact QuickBooks Technical Support (US, Canada or UK). Fees may apply.

If your company file is stored on a portable drive, follow these steps:

Working on your company file while it is on a portable drive, such as a flash drive, is not recommended. Proceed with the following steps at your own risk.

Check your portable drive

  1. Make sure your portable drive is still connected. You may try:

    • Disconnecting and reconnecting your drive

    • Finding your file on your drive from My Computer

    • Saving other files to your drive to make sure it's working

  2. Make sure your drive has plenty of available space. It should have at least as much free space as the size of your company file.

  3. Note: If you still see the error, follow the steps above under Use the QuickBooks File Doctor to fix the issue.

Your computer is connected to a network and your data file is stored on another computer

Your network can break in several ways:

  • You may have seen a Windows error or similar problem on your computer.

  • The computer you're connected to (it's called a server or host) may have a similar problem.

  • The problem may lie in the connection between the two computers (cables, routers, protocols, etc.).

For the best results, follow the steps and solutions in the steps and solutions in the order they appear.

Solution 1: Use the QuickBooks File Doctor to fix the error

  1. Download and install the QuickBooks File Doctor. See QuickBooks File Doctor: Fix your company file or network (US, CA, and UK) to use the QuickBooks File Doctor.

  2. When the download is complete, install the tool by double clicking the .exe file.

  3. Launch the tool by double clicking the icon on your desktop.

  4. View the results.

    • If you see No problem detected in your Company File, your company file is OK. If you still see the error, Verify your company data file, and rebuild it if necessary. See Resolve data damage issues (basic troubleshooting) to perform a Verify and Rebuild.

    • If the tool detects data damage, you can:

      • Repair the file. The tool will tell you if it fixed your file.

      • Restore recently backed up company file.

      • Recover lost data with QuickBooks Auto Data Recovery

      • Send your company file to our Data Recovery Team. To request data recovery service from Intuit Data Services, contact QuickBooks Technical Support (US or Canada). Fees may apply.

Solution 2: Restart computers

  1. Restart the server first.

  2. Important: Before doing this, make sure no one else is connected to the network.

  3. Restart your computer.

  4. If you still see the error, continue with the next solution.

Solution 3: Check your network

Important: Wireless networking is not reliable enough for information like your company file. It's not supported by QuickBooks. Review the details if you like, but don't use wireless networks for QuickBooks.

  1. Open or save another file on the server to make sure you have the necessary access. Using another program like Microsoft Excel or WordPad, create and delete another file on that computer.

  2. If you're not able to create and delete a file in that folder, set access permissions required for QuickBooks. See: Set Windows access permissions to share company files

You may need to consult a network technician or your IT staff if your network isn't working.

If you still see the error, continue with the next solution.

Solution 4: Disable power management settings on the server

  1. On the computer where the company file is stored, open the power management settings in Windows Control Panel:

    • On your keyboard, press Windows and type Power Options, then click to select Power Options.

  2. Turn off all sleep, standby, and hibernation modes on the host computer. Refer to Windows Help and Support for more information about power options.

Solution 5: Fix hosting on all computers

Host computer tasks

  1. Make sure QuickBooks Database Server Manager is installed on the host computer (server)

    1. On your keyboard, press Windows and type QuickBooks.

    2. If QuickBooks or QuickBooks Database Server Manager doesn't appear in the list, it means the program is not installed. Refer to Install, Update and Set Up the QuickBooks Database Server Manager.

  2. Set hosting settings

  3. If QuickBooks is installed on the host computer:

    1. Open QuickBooks.

    2. Choose File > Utilities:

      • If Stop Hosting Multi-User Access appears in the menu, hosting is enabled and you can proceed to the next step.

      • If Host Multi-User Access appears in the menu, select it to enable hosting on this computer, and then proceed with the next step.

      • The host computer should say Stop Hosting Multi-User Access. If it doesn't, select Host Multi-User Access to fix it.

  4. If QuickBooks is not installed on the host computer (called a server-only installation):

    1. Double-click the QuickBooks Database Server Manager icon in the Windows system tray (or choose Start > All Programs > QuickBooks > QuickBooks Database Server Manager).

    2. Click the Database Server tab.

    3. Verify that your company file appears in the window below Currently connected company files and logged in users. If it isn't there, click the Scan Folders tab and click Help for information about adding the company file.

    4. Close the QuickBooks Database Server Manager window.

  5. Delete and recreate the .nd file

  6. You need to scan the folder where the company file is stored to create the Network Descriptor (nd) file. The *.nd file stores information about the computer that is hosting the file.

    1. On your keyboard, press Windows and type QuickBooks Database Server Manager.

    2. Click QuickBooks Database Server Manager.

    3. In the QuickBooks Database Server Manager window, click Add Folder and find the folders storing the company files.

    4. When all folders are added, click Scan.

    5. The data files appear under QuickBooks company files found. Click Close.

    6. Browse to the folders containing the company files and make sure the file .band was created for each company data file.

  7. Note: If you don't see the QuickBooks Database Server Manager in the Programs list, you might have to uninstall QuickBooks and reinstall selecting the second 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

  1. Make sure hosting is turned off

    1. Open QuickBooks.

    2. Choose File > Utilities, and then:

      • If Stop Hosting Multi-User Access appears in the menu, select it to disable hosting on this computer and proceed with the next step. If the workstation says Stop Hosting Multi-User Access, click it to fix it.

      • If Host Multi-User Access appears in the menu, hosting is already disabled and you can proceed with the next step. The workstation should say Host Multi-User Access. If it does, don't change it.

  2. Open the company file using a UNC path

  3. UNC (Uniform Naming Convention) is a common syntax Windows uses to describe the location of a network resource.

  4. An example of a U NC path is \\Computer Name\Shared Folder\. Computer Name in this example would be the name of the server where the company file is hosted.

  5. Follow the steps below to open the company file using the U NC path:

    1. Open QuickBooks.

    2. Choose File > Open or Restore Company.

    3. Select Open a company file and click Next.

    4. In the left pane of the Open a Company window, click My Network Places.

    5. Double-click Entire Network and navigate to the location on your server where the company file is stored.

    6. Select the company file and click Open.

If the problem is not resolved, there is Advanced option recommended by Intuit that you can use with help of Quickbooks Technical Support experts.

 

Article Source : https://community.intuit.com/articles/1459751-error-message-connection-has-been-lost