Limited time. 50% OFF QuickBooks for 3 months.

Buy now & save
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Get unlimited expert tax help and powerful accounting in one place. Check out QuickBooks Online + Live Expert Tax.
mhn8339
Level 2

Issues with ND file and multiuser mode

Have a Server we installed QuickBooks Enterprise 24.0 - Windows Server 2022. We are unable to get multi-user mode working. When we try to open, comes up with H202 error.

Things we've tried;

- Uninstalling and clean reinstall

- Recreating the ND file

- Installing full QB Desktop app, Stop hosting, start hosting

- Created new QB Database file

- Scanned folders with QB Database Manager

- Changed port

- Reviewed the ND file, does NOT have the right engine name or port, but no other versions of QB are installed on this system.

- Manually changing ND file to reflect correct "database server" setting - still not working.

- Running FileDoctor and using QB Tool Hub.

 

Any ideas? I really don't want to have to do a wipe and reload on this server to fix this.

Solved
Best answer 2 weeks ago

Best Answers
mhn8339
Level 2

Issues with ND file and multiuser mode

Figured this issue out.

 

We did not have control of the network's router - so the DHCP/DNS was hosted on the router owned by the internet provider.

 

Because QB clients require access to the server both via IP and hostname, we had to either adjust where the DNS was or edit the host file on the Windows machine. We wound up adjusting the host file on the two broken Windows clients. (Which we had to copy the hosts file from c :\windows\system32\drivers\etc\hosts.file to another location, edit, then copy back & replace existing.)

 

Once we did this, multi-user mode worked perfectly.

View solution in original post

8 Comments 8
RazzieE
QuickBooks Team

Issues with ND file and multiuser mode

I appreciate the actions you’ve taken to rectify the H202 error in QuickBooks Enterprise multi-user mode, @mhn8339. I've got some additional troubleshooting steps you can take to resolve this issue. Allow me to discuss this further below.

 

To begin with, the H202 error in QuickBooks typically occurs when there are problems with the multi-user hosting setup, such as incorrect hosting configuration settings or issues with the Database Server Manager. You can try the following troubleshooting steps:

 

Solution 1: Check the service on your server

 

Note: If you use the full version of QuickBooks on your server computer, first turn on multi-user hosting.

  1. Open QuickBooks on your server computer. Go to File and then select Utilities. If Host Multi-User Access is an option, select it. If Stop Hosting Multi-User Access is an option, don’t select it.

 

Make sure QuickBooks services are running on your server computer. Follow these steps to check QuickbooksDBXX. Then repeat them for QBCFMonitorService.

 

  1. Open the Windows Start Menu on your server computer.
  2. Type in “Run” into the search and open Run.
  3. Enter “services.msc” into the Run window, then hit Enter.
  4. Navigate QuickBooksDBXX on the list then double-click. XX notes your version of QuickBooks plus 10. Example: QuickBooks 2023 is QuickBooksDB33.
  5. Choose Automatic for the Startup Type and make sure the Service status is either Running or Started. If it’s neither, select Start.
  6. Click the Recovery tab.
  7. Select Restart the Service from each of these dropdown menus: First failureSecond failure, and Subsequent failures.

     
  8. Click Apply and then select OK to save the changes.
  9. Repeat these steps for QBCFMonitorService.

 

When you’re done, open QuickBooks on each workstation. Go to the File menu and select Switch to Multi-user Mode. If everything opens correctly, the problem is fixed.

 

If solution 1 doesn't work for you, you may refer to this article for more solutions available: Fix Error H202 manually.

Additionally, you can explore this article to learn more Hosting Modes in QBDT: Host your company data in multi-user mode in QuickBooks Desktop. It covers topics such as setting up hosting, understanding hosting modes, and ensuring proper access to company files in a multi-user environment.

For any further questions you may have about multi-user hosting, you can utilize the comment below. The Community is here to help at any time. Have a pleasant day.

Chrea
Level 7

Issues with ND file and multiuser mode

@mhn8339 

Try opening the sample file in the multiuser mode. Did you encounter the same problem?

mhn8339
Level 2

Issues with ND file and multiuser mode

We had them create a new QB file, had issues on this too.

mhn8339
Level 2

Issues with ND file and multiuser mode

Changing some settings on the services did not resolve the issue, I have tried this.

 

I've compared two devices - one functioning multi-user mode device, and the problem one. The problem one is having SOME sort of issue that isn't shook out by clean reinstall. The ND file has the incorrect database name and port number versus the one that's displayed in the Database Manager. 

Dandie_A
QuickBooks Team

Issues with ND file and multiuser mode

I appreciate your efforts in troubleshooting and exploring alternative solutions to resolve the H202 error you encountered in QuickBooks Enterprise 24.0, mhn. Since you still encounter the error, I recommend contacting our live support team to give you more assistance. They have the tools and expertise necessary to check and provide an effective solution.

 

Here’s how you can reach out to QuickBooks Desktop support:

 

  1. Let's open QuickBooks account.
  2. Navigate to Help, then select QuickBooks Desktop Help or Contact Us.
  3. Enter the question, keyword, or topic you need help with.

 

Additionally, for more information about contacting QuickBooks Desktop support, you can check this article: QuickBooks Desktop support.

 

Moreover, if you need someone to help you with your workload in QuickBooks Enterprise, you can add or invite a user. You can check this article as your guidelines: Create and Manage users and roles in QuickBooks Desktop Enterprise.

 

Please keep me updated on your progress after contacting support, or let me know if there's anything else I can assist you with. Your seamless workflow is a priority, and I’m here to ensure everything runs smoothly.

Chrea
Level 7

Issues with ND file and multiuser mode

Install the trial version of QB Desktop 2023 Enterprise and open the sample file in multiuser mode to isolate the problem.

mhn8339
Level 2

Issues with ND file and multiuser mode

Figured this issue out.

 

We did not have control of the network's router - so the DHCP/DNS was hosted on the router owned by the internet provider.

 

Because QB clients require access to the server both via IP and hostname, we had to either adjust where the DNS was or edit the host file on the Windows machine. We wound up adjusting the host file on the two broken Windows clients. (Which we had to copy the hosts file from c :\windows\system32\drivers\etc\hosts.file to another location, edit, then copy back & replace existing.)

 

Once we did this, multi-user mode worked perfectly.

JessT
Moderator

Issues with ND file and multiuser mode

Hi mhn8339,

 

Thank you for sharing the steps you took to resolve the H202 error in your QuickBooks Enterprise. Your insights on adjusting the host file and DNS settings will undoubtedly help others facing similar issues. We appreciate your contribution to the community!

Get answers fast!
Log in and ask our experts your toughest QuickBooks questions today.

Need to get in touch?

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