cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Level 2

Errors Hosting Multi-User Mode

Running QB Enterprise 2018 on Server 2012.

 

I cannot switch over to multi-user mode from the workstation and I am getting Error H202.

 

I have tried the relevant help articles.  On the QB DB Server manager it says all is running fine, but on the QB Desktop File Doctor it says "QBDBMgrN not running on this computer."

 

I have also tried the relevant help article for that one as well.  Anyone go through this recently?

Solved
Best answer December 17, 2018

Best Answers
Highlighted
Level 2

Errors Hosting Multi-User Mode

FIXED - So this was a problem for me all day.

 

It started as the H202 error and not being able to get into multi-user mode, but then I was getting errors on QB File Doctor saying *QBDBMgrN was not running on this computer".  I tried a clean install of qbmanager, manually adding firewall ports, resetting the firewall settings to default, multiple restarts, etc.

 

After several hours of my own trouble-shooting about an hour and a half with support, we tried renaming the *.QBW.TLG and the *.QBW.ND with .old (so QB would create new files) files and it not only fixed the problem but greatly sped up QB itself. 

 

If you've tried all the help articles it might be helpful to take note of the size of the .tlg and .nd files.  I was told if they are too large it could create errors.

 

For reference, my tlg file was about 1.04GB and my file size itself was 1.9GB

View solution in original post

9 Comments 9
Highlighted
Level 2

Errors Hosting Multi-User Mode

FIXED - So this was a problem for me all day.

 

It started as the H202 error and not being able to get into multi-user mode, but then I was getting errors on QB File Doctor saying *QBDBMgrN was not running on this computer".  I tried a clean install of qbmanager, manually adding firewall ports, resetting the firewall settings to default, multiple restarts, etc.

 

After several hours of my own trouble-shooting about an hour and a half with support, we tried renaming the *.QBW.TLG and the *.QBW.ND with .old (so QB would create new files) files and it not only fixed the problem but greatly sped up QB itself. 

 

If you've tried all the help articles it might be helpful to take note of the size of the .tlg and .nd files.  I was told if they are too large it could create errors.

 

For reference, my tlg file was about 1.04GB and my file size itself was 1.9GB

View solution in original post

Highlighted
QuickBooks Team

Errors Hosting Multi-User Mode

It’s nice to see you in theCommunity, MLee.


I’m glad to know that our Technical Support Team was able to help you get back on track. Thank you for including the additional steps you’ve performed with them since it surely helps a lot of customers who are also experiencing the same error.

 

If you have additional questions about working in QuickBooks, I'm adding a link to our helpful articles. Just select the topic to view it.

 

If there's anything else that I can help with, don't hesitate to leave me a comment. I'd be glad to assist you further. Have a great rest of your day.

Highlighted
Level 1

Errors Hosting Multi-User Mode

What is the location of these files?

Highlighted
Level 1

Errors Hosting Multi-User Mode

What is the location to the files??

Highlighted
Moderator

Errors Hosting Multi-User Mode

Good day, @mark_castro.

 

Your QBW.TLG and QBW.ND files can be found in the same folder where you saved your QuickBooks company file. I'm here to help you locate them.

  1. Open your QuickBooks Desktop company file.
  2. Go to the Home page.
  3. On your keyboard, press the F2 key.
  4. Under FILE INFORMATION, look for the Location section.

Additionally, I've added a screenshot below for your visual reference.

 

 

Lastly, I've also included this article in case you'll bump into some errors and issues with your company file: Resolve Problems Opening QuickBooks Desktop or your Company File.

 

If there's anything else that I can help you with, please let me know in the comment section down below. I'll be always around ready to help.

Highlighted
Level 1

Errors Hosting Multi-User Mode

This looked promising, but no luck.   Hosting 3 company files on a 2012 server. Up until 3 days ago, multi-user hosting was working fine. Suddenly Friday, only one user could get in at at time on all 3 companies. Logged into server, tried to open a company and got -6175,0 error. Got any users out if the companies and ran file doctor.  Stopped hosting on the server per the 6175 troubleshooting document. Am able to get into all 3 companies from the server console; ran backups and database integrity checks. Try to start hosting, get the 6175 Can't open company file. Try to start multi-user, says it has to close and put in single-user mode first, then gives 6175 error.  I see the message about the server job not running, and that process is not active, but I see no way to start it aside from trying to host multi-user. Even rebooted the server off hours, still get the 6175 error whenever I try to enable hosting.

Before you ask-no updates/installs/shutdown was done on the server between the time it was working and when it stopped.

Highlighted
Level 12

Errors Hosting Multi-User Mode

Explore this reference link

https://quickbooks.intuit.com/learn-support/en-us/access-data-remotely/how-to-fix-error-6175-0/00/20...

 

Next, open a dummy file or sample file to isolate the issue. If you can open any of them in muti-user mode, your data file may be damaged. Call and ask Intuit Data Service to fix it. Should you need to resolve in due course, consider purchasing a 3rd party file repair service.

 

Hope it helps.

Highlighted
Level 1

Errors Hosting Multi-User Mode

I reviewed the 6175,0 article several times before posting this inquiry and tried the steps outlined.  File Doctor would run and come back with 'No problems found'.  I could open each company as single user/not hosted from the server (local QB 2018 is installed), ran backup with verification and database integrity check. These all worked.  (and why would I need a third party database repair utility? Can't Intuit fix their own database??).

After trying the same steps several times (definition of insanity?) and having File Doctor come back and tell me 'turn on hosting' again, I went back and tried it.  Suddenly it worked-all companies now showed multi-user hosting.  I have no idea what/if I did differently, but now it is OK.  This happened a couple months ago and I figured it was a fluke. Apparently not; I just wish I could figure out why QB decides to have a hissy fit and stop hosting.

Highlighted
Level 1

Errors Hosting Multi-User Mode

I have a possible fix. We have a similar situation, different environment - 5 Win 10 workstations: 4 workstations and one acting as a server only, running database server manager.

 

Users will all be in multiuser mode all day, then shut down QB end of day and log out of windows. Next morning, the first PC logging into QB will get an error that others are logged in in Multiuser mode - to switch to MuM. Clicking the button fails with an error. Sometimes a 6000 error, but I've also seen H202 today.

 

Their tech support made a good point asking how they close out of the program- with the X or by File>Close Company/Logoff. They have been using the X. So they suggested using the correct method- File > Close.  I believe this will solve our problem. Hitting the X doesn't properly close the file handles on the server. It leaves them open and connected and gives the weird MuM error. Why it doesn't give an error of too many concurrent users- more than 3 theyre licensed for, idk. 

 

ALSO - dont let the bastards upsell you to Premium or anything else with more users. They'll ask how many users and how many PCs. The second you tell them you have 3-user license but 4 computers theyll try to tell you thats the problem - just upgrade to PREEMIIIUMMMM. Yeah right. I had a tech do that at the beginning of the call and then at the end she again tried to say the "server counts as a user"... BS! They're so full of it. I told her that it's impossible. Of all the many dozens of offices I've set up this way, never have I gotten a 3 user limit message with a server + 3 users on 3 PCs.  If you try to log in a 4th user- of course QB will stop you. So, no, the server is NOT a user. I can't believe they're still running those scams. I thought they had revamped their support a while ago. They're up to their old tricks.

 

Need to get in touch?

Contact us