Created with Sketch.Learn about PPP and Loan Forgiveness, stay informed with the latest changes.
Created with Sketch.Need help with 1099's or other Year End topics? Visit our Year End Resources page.
Created with Sketch.New to QuickBooks or using a new product? Visit our Get Started resource page to help you get going.
Created with Sketch.Need to make changes to your account? Visit the Account Manager Portal.
cancel
Showing results for 
Search instead for 
Did you mean: 
Level 2

Quickbooks hosting multiple files on single server

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

Solved
Best answer December 16, 2019

Best Answers
QuickBooks Team

Quickbooks hosting multiple files on single server

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:

  1. Download the QuickBooks Tool Hub file. .
  2. Open the file you downloaded (QuickBooksToolHub.exe).
  3. Follow the on-screen steps to install and agree to the terms and conditions.
  4. When the install finishes, double-click the icon on your Windows desktop to open the tool hub.
  5. From the tool hub, select the Company File Issues tab.
  6. Select Run QuickBooks File Doctor
  7. 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.
  8. Press Check your file and then Continue.
  9. 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

3 Comments
QuickBooks Team

Quickbooks hosting multiple files on single server

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:

  1. Download the QuickBooks Tool Hub file. .
  2. Open the file you downloaded (QuickBooksToolHub.exe).
  3. Follow the on-screen steps to install and agree to the terms and conditions.
  4. When the install finishes, double-click the icon on your Windows desktop to open the tool hub.
  5. From the tool hub, select the Company File Issues tab.
  6. Select Run QuickBooks File Doctor
  7. 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.
  8. Press Check your file and then Continue.
  9. 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

Level 2

Quickbooks hosting multiple files on single server

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. 

QuickBooks Team

Quickbooks hosting multiple files on single server

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:

 

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

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

Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up

Need to get in touch?

Contact us