Quickbooks hosting multiple files on single server

tzykid · ‎December 16, 2019

Greetings,

I am working with a company that uses quickbooks to manage all of its DBA entities.

The quickbooks server currently is holding 12 company files with two users jumping between files throughout the day.

The issue is that on occasion, one of the company files will switch to single user mode. There is no H202 error, The user can easily switch back to single user mode, But I am perplexed as to why it switches.

I have performed some standard fixes that would apply to the H202 error. I have:

Set the local qbwuser.ini file to say multiusermode=Y and set the file as Read-Only

I stopped quickbooks service on the server and removed the ND and TLG files then started the service and recreated them with a login.

I was able to test by switching company files on one machine at the same time another user was switching files and I was able to get one of my files (that was previously in multi user mode) to switch to single user mode. There was no error, and it was able to switch back easily.

Is there a connection problem or possibly a fix for this that will allow my users to switch between company files and leave ALL the files in multi user mode? Has anyone else seen something similar?

Thanks

BettyJaneB · ‎December 16, 2019

Great job in performing some steps to fix the user issue, @tzykid.

Data damage on the company file can be the reason why the user access was changed to switch to single-user mode.

To fix this, we can run a file doctor to the affected company through the host company file. This resolves unusual behavior while working on the company file.

Here's how:

Download the QuickBooks Tool Hub file. .
Open the file you downloaded (QuickBooksToolHub.exe).
Follow the on-screen steps to install and agree to the terms and conditions.
When the install finishes, double-click the icon on your Windows desktop to open the tool hub.
From the tool hub, select the Company File Issues tab.
Select Run QuickBooks File Doctor.
In QuickBooks File Doctor, choose your company file from the drop-down menu. If you don’t see your file, hit Browse and search to find your file.
Press Check your file and then Continue.
Enter your QuickBooks admin password and click Next.

I'm including here a link that provide a video tutorial of this process: Utilize the QuickBooks File Doctor

If you encounter any errors while working on a multi-user mode, I have here some resources that you can check out for troubleshooting steps:

You've got me here to provide further assistance if there's anything else you need. Just let me know by dropping a reply below. Happy Holidays!

View solution in original post

BettyJaneB · ‎December 16, 2019

Great job in performing some steps to fix the user issue, @tzykid.

Data damage on the company file can be the reason why the user access was changed to switch to single-user mode.

To fix this, we can run a file doctor to the affected company through the host company file. This resolves unusual behavior while working on the company file.

Here's how:

Download the QuickBooks Tool Hub file. .
Open the file you downloaded (QuickBooksToolHub.exe).
Follow the on-screen steps to install and agree to the terms and conditions.
When the install finishes, double-click the icon on your Windows desktop to open the tool hub.
From the tool hub, select the Company File Issues tab.
Select Run QuickBooks File Doctor.
In QuickBooks File Doctor, choose your company file from the drop-down menu. If you don’t see your file, hit Browse and search to find your file.
Press Check your file and then Continue.
Enter your QuickBooks admin password and click Next.

I'm including here a link that provide a video tutorial of this process: Utilize the QuickBooks File Doctor

If you encounter any errors while working on a multi-user mode, I have here some resources that you can check out for troubleshooting steps:

You've got me here to provide further assistance if there's anything else you need. Just let me know by dropping a reply below. Happy Holidays!

tzykid · ‎December 17, 2019

I will certainly try that. So this seems to be a data file error?

Can I ask what makes you believe it is the data file causing the issues? Have you seen a similar issue before?

The accountants have said this has been an issue for over a year, and I was told the previous guy who looked at it ran file doctor on the files but the issue still happened. I am not against doing it again, because any little thing can help at this point, but do you have specific reasons as to why you believe that is the issue? What else could it be if this does not fix the issue?

I will run file doctor on them this evening and test.

Mark_R · ‎December 17, 2019

I appreciate you getting back to us, @tzykid.

It's the data file causing the issues since it relates to the multi-user connection to your server. The troubleshooting steps provided by my colleague above would fix this issue.

If running a file doctor won't fix the issue, I would suggest contacting our Technical Support Team. This way, then can further investigate this matter and open an investigation if some users are experiencing the same issue with yours. They can also provide further troubleshooting steps to resolve this issue and get you back to working order.

To reach them:

Go to your QuickBooks Home page, then click the Help menu at the top.
Choose QuickBooks Desktop Help from the drop-down.
Hit the Contact us icon.

Please let me know how things go. I'll be around to provide further assistance. Have a good one!

AdrianG001 · ‎May 26, 2022

You can manually set up and install a multi-user network as the main host of your company files. Let me guide you how.

To start with, here are the things you'll need to prepare before you can set a multi-user network:

Set Folder Permissions
Use Database Server Manager
Install Database Server Manager
Set Admin Rights

Once done, you can turn on the hosting of your company file for multi-user network:

Go to File.
Select Utilities.
Click Host Multi-User Access.
Select Yes.

I've included an article that you can read to learn more about hosting and multi-user network: Set Up and Install a Multi-user Network for QuickBooks Desktop.

If the issue persists, you can contact our support directly from the Help menu of your account. I'm here to help you accomplish this.

Go to Help.
Select QuickBooks Desktop Help.
Enter Multi-user Hosting in the Tell us more about your question: field.
Click Search.
Select Message Us.

In case you need some related articles in managing your multi-user network, here's an article you can read for more insights: General Info about Hosting your Company Data in Multi-user Mode in QuickBooks Desktop.

Topics

Training

Community

Resources

Quickbooks hosting multiple files on single server