Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
April 15, 2019
Question

Quickbooks Desktop, multi-user mode issues

  • April 15, 2019
  • 2 replies
  • 27 views

Hi there, I wonder if anyone can help. We host our company file on a server and have recently upgraded both of our workstations that access that company file to Quickbooks Desktop 2019. All went well but when I tried to switch to multi-user mode it came up with error H202. I followed the suggestions to deal with that but still no joy. We haven't changed anything on the server where the company file sits so access to it should be the same as it was when we were both running Quickbooks Desktop 2014.

I've printed off numerous help pages and run database scans, the intuit file doctor etc but nothing seems to be helping.

Has anyone else encountered this upon upgrade ?

Any help would be most welcome

Thanks

2 replies

QuickBooks Team
April 15, 2019

Welcome to the Community, SueMapp. I'd be glad to lend a hand in fixing error H202.

 

To get this be fix, use the QuickBase Database Server Manager. Here's what you'll need to do:

  1. Go to your server computer.
  2. At your server computer (computer hosting your company file/s), open the start menu then type database.
  3. Click on QuickBooks Database Server Manager.
  4. If no folder locations are shown, click Browse and browse to the folder where you store your company file(s).
  5. Click OK.
  6. Click Start Scan, which will repair the firewall permissions to allow QuickBooks to communicate over your network and resolve your error.
  7. Once done, click Close.
  8. Try opening QuickBooks in Multi-User mode on your workstation(s).

That's it! For more detailed steps, I'm including a helpful article that you can check: https://quickbooks.intuit.com/community/Help-Articles/Error-H101-H202-H303-or-H505-when-opening-your-company-file/m-p/238999.

 

I want to ensure that this is taken care of for you, so please feel free to let me know how it goes. Have a great day!

April 16, 2019

Hi there, thanks for coming back to me. I have tried this solution several times but it hasn't worked. I have two workstations running QB Desktop 2019 and only one user can get in at a time. I've run the scan several times to try and cure it so that we can work in multi-user mode but it doesn't make any difference. I've been googling various solutions but cannot fathom out why it now won't work. It was fine when we were running QB Premier 2014 

 

Any other suggestions would be great, thanks 

Sue

February 10, 2020

Hello,

 

I am having issues of this kind on an existing installation running QB 2016 Premier Accountant version. The system was fine up to a few days ago, having been running for almost 2+ years now on this. Since a few days ago I'm getting Error H202 when users try to switch companies to multi-user mode. These companies were working fine in multi-user mode up to a few days ago.

 

The strange thing is that if I open the same company from the "server" first, switch it to multi-user mode and then go to a client PC, they can access the company in multi-user mode fine. But if the company is first opened on a client PC, the users cannot switch it to multi-user mode, but gets the H202 error.

 

The QB service account is local admin on the server.

The users have full access to the folder where the company files is.

I ran QB Database Server manager which is not finding anything wrong.

I temporarily disabled the firewall, same result.

I ran the QB Tool Hub + Database Server manager, no issues found, same problem.

QB Services are running in automatic mode.

I went through every step in great details of this link, again nothing resolved it:

https://quickbooks.intuit.com/learn-support/en-us/open-programs/how-to-fix-error-h202-and-h505/00/186029

 

Server is running Windows Server 2012 R2, clients all Windows 10 and QB is updated to the latest version everywhere.

 

The strange thing is that companies open in mutli-user mode if they are opened like that on the server first. In my mind, this shows that the server is ok, or almost. I need some guidance as for sure it was working properly a few days ago and I need to see if there is a fix.

 

Some screenshots attached:

Page 1 - the error if the client tries to set to multi-user first

Page 2 - if multi-user is set on server first, it works

Page 3 - if the company is opened in multi-user mode on the server, the client connects fine in multi-user mode

 

Thank you,

Stefan


I have the exact opposite problem. I have a new Windows 10 surface pro running QuickBooks as server. I have done everything listed (firewall checked, virus software stopped, uninstalled QB on server and reinstalled, scanned with database server manager, checked that DBmgr was running in services, etc) but if the server is logged into a company file then the workstation cannot log into same file even though server is set to multi-user mode. Workstation gives error (no number) that it sees the server is set to multi-user but it cannot connect.  In a log file somewhere, I did see that the server had file locked maybe.  If the workstation logs into company file first then the server CAN log into file just fine. Very odd.

Angelyn_T
Moderator
May 7, 2020

Hello, @book3.

 

At this time I recommend following the steps provided by my colleagues above to resolve the problem you're getting. If you're getting the same problem, I recommend reaching out to our Support Team so they can review and check this error further.

 

To contact support:

 

  1. Open this link: https://help.quickbooks.intuit.com/en_GB/contact.
  2. Select QuickBooks Desktop for the product.
  3. Pick the options that suit your experience under the What can we help you with? section. (Errors, Errors by code number)
  4. Choose a way to connect with a representative under Here's how to connect with a QuickBooks expert about "I ...".

Post again if you have any other questions. I'm always here to help. Have a good day!