QB's lost connection

Anonymous · ‎April 01, 2019

I have a client that uses QB 2019 networked in Multi-user mode. The database is reachable and shared out correctly, the issue I'm having is form time to time is the connection has been lost error with no code or H505 code will display. Either way it requires me to login to the server an run the QB database manager, it completes with out any errors and the users can logon without issue. I know they like to remain logged and not log out at the end of the day, could QB's automatically log you out if remaining idle for a long period of time or I'm I just missing something,

Thanks

Catherine_B · ‎April 02, 2019

Hi there, Pauliej.

One reason that you're prompted with this error could be your Database Server Manager status has stopped. The status should remain Running to avoid it. Though your users are switching company files to the other, it shouldn't cause the error.

Refer to the Solution 2: Check hosting and services in this article that will walk you through how to enable hosting on the server.

The Community is always around to help you with your questions.

View solution in original post

Anonymous · ‎April 01, 2019

Hi, @Anonymous.

Thank you for reaching out in the Community. Let me help share some information about getting the H505 error and how you can fix this.

This error is usually associated with the multi-user hosting setup. You'll need to ensure that all workstations have the Host Multi-User Access under the utility file.

You can perform these following steps first:

On each workstation (not the server or hosting computer), go to QuickBooks File menu and select Utilities. This can be done even without opening a specific company file.
If you see Host Multi-User Access on the list, this computer is not hosting the company file and you can go to the next computer.
If you see Stop Hosting Multi-User Access, select that option to disable hosting on your workstation, which will fix the H505 errors.
Ensure all workstation(s) in your office look like this under the File then Utilities menu (please refer to screenshot below).

If the issue persists, I recommend checking this article for checking hosting and services: Error H101, H202, H303, or H505 when opening your company file.

This should help the users to remain logged in to QuickBooks.

Keep me posted if there's anything else you need or if you have other questions about multi-user mode. I'll always be here to help. Have a good one.

Anonymous · ‎April 02, 2019

Thanks for the quick response, I need to have the computers in Host multi- use mode because the are sharing\using the same company file at the same time. The issue is that they get an error everyday see attached file and I have to remote into the server to run the database manager to fix the issue and it reports no errors, they don't log out at the end of the day. It just seems that the QB's times out for some reason.

Anonymous · ‎April 02, 2019

Thank you

All but on computer had host Multi-User Access on, but I that user switches between company files and doesn't require Multi-User Access could this be an issue?

Catherine_B · ‎April 02, 2019

Hi there, Pauliej.

One reason that you're prompted with this error could be your Database Server Manager status has stopped. The status should remain Running to avoid it. Though your users are switching company files to the other, it shouldn't cause the error.

Refer to the Solution 2: Check hosting and services in this article that will walk you through how to enable hosting on the server.

The Community is always around to help you with your questions.

Anonymous · ‎April 03, 2019

Still getting the same error, now it's progressing. I can open the QB's database manager on the remote server, when I it the dialog box disappears nothing happens.

Kristine Mae · ‎April 03, 2019

Hello there, Pauliej.

I've checked your screenshot and saw that you got the Connection has been lost error.

I've got you the specific article to fix it. Follow the solutions under If your computer is connected to a network and your data file is stored on another computer and make sure to perform them in order: Error message: Connection Has Been Lost.

You can keep us updated after trying the steps. We're just around to help you.

KlentB · ‎July 14, 2022

I'll help you restore the connection, peter_Cpafma.

Connection issues are usually caused by a currupted company file, firewall/folder permission, and unstable connection. To isolate the issue, you'll want to perform these troubleshooting procedures:

Check your network and then restart the Database Server Manager.
Move the file to a different folder.
Set the power saving option of your computer to never.

If you're still having difficulty accessing the file, you can install QuickBooks Tool Hub. This program will scan your company file and resolve data damages. For the best experience, we recommend using this tool on Windows 10, 64-bit. Here's how to use it:

Close QuickBooks.
Download the most recent version (1.4.0.0) of the QuickBooks Tool Hub.
Open the file you downloaded (QuickBooksToolHub.exe).
Follow the on-screen steps to install, then agree to the terms and conditions.
When the install finishes, double-click the icon on your Windows desktop to open the tool hub.

Once done, run the Quick Fix my File utility:

From the tool hub, select the Company File Issues tab.
Select Quick Fix my File.
Once the process is completed, click OK and then open QuickBooks again.

For additional solutions, I recommend checking out this guide: Error message: Connection Has Been Lost. I'm also adding this article to learn how to fix general problems when your company file won't open: What to do if you can't open your company file in QuickBooks Desktop.

If you need further assistance in dealing with your other tasks, don't hesitate to reach out to me. Looking forward to helping you out again.

Topics

Training

Community

Resources

QB's lost connection