11

I was able to open quickbooks just fine, but when I try to switch to multi-user mode, it gives me error H202.

  • Quickbooks Database Server Manager is running correctly on the file server.
  • The Quickbooks Connection Diagnostic Tool reports no errors and opens the file just fine.
  • I'm using Quickbooks 2012 (oddly, this never happened under Quickbooks 2010)

qb diagnostic tool output

Michael Pryor
  • 2,636

3 Answers3

11

I gleaned some info from a guy that used WireShark to track down his problem with error H202.

Apparently if you open the file as \\fileserver.mydomain.com\fileshare\quickbooks.qbw, Quickbooks may have problems reaching the database server to switch to multi-user mode.

However, if you open the file as \\fileserver\fileshare\quickbooks.qbw, Quickbooks should work just fine. i.e. don't use the fully qualified domain name, use the NETBIOS name.

In our case this meant editing the lmhosts.sam file located at c:\windows\system32\drivers\etc to include the line

10.1.1.19 FILESERVER #PRE

(where 10.1.1.19 is the ip of the fileserver your QB file is on and FILESERVER is the NETBIOS name of the server)

You can also see that this is your problem from Quickbooks point of view if you specify the full name in the "Change hosting server" field on the diagnostic tool.

Michael Pryor
  • 2,636
6

Michael's answer above drove me to a resolution for us as well. We were getting H202 error in multi-user environment unless we had a user logged on to the company file at the host server first and then the clients could log on fine. We are/were using a CNAME instead of the actual hostname of the host server. So we had a friendly CNAME of quickbooks so they could map as \quickbooks\\companyfile, but with this we experienced the errors mentioned. So I just switched to use the actual hostname of the computer and this seems to resolve this issue. Very strange that it works fine without error using the CNAME if someone is logged on at the host server first though.

mholman
  • 61
0

Google search with site:intuit.com YOUR PROBLEM OR QUESTION is highly useful.

The most likely cause is another PC at your location is trying to be the Multi-Use Host and is causing a conflict with the server which should be the host. At every PC, do File | Utilities and then do you see Stop Hosting Multi-User Access? If so, please do choose that, so that PC's settings in QuickBooks revert to Host Multi-Use Access (i.e., it's not hosting any more).

If that does not resolve it, please see
http://support.quickbooks.intuit.com/support/Articles/INF12401
http://support.quickbooks.intuit.com/support/Articles/SLN42911
http://support.quickbooks.intuit.com/support/Articles/SLN40493
http://support.quickbooks.intuit.com/support/Articles/HOW12723
http://support.quickbooks.intuit.com/support/Articles/SLN63353

K7AAY
  • 9,725