Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
November 10, 2022
Question

HELP - Quickbooks Desktop Enterprise - Proper Network Setup

  • November 10, 2022
  • 12 replies
  • 43 views

Hello Everyone...
Need some guidance on how to properly setup a Quickbooks Desktop Enterprise 21 on a network recently inherited.


Current Setup:

       Users: 20

        QB Server: Hosts Database/Company File + QB Database Manager - NO Quickbooks Application Installed.

        Terminal Server & Workstations: Running Quickbooks Desktop Enterprise 21 as MUILTI-User Mode

 

Issue: On a daily basis, users get locked out with a message file is being used by someone else or someone is using QB in Single-User mode.

 

 

Is it safe to say the proper setup should be:

          QB Server: Hosts Database/Company File + QB Database Manager + INSTALL Quickbooks Desktop Enterprise application in Multi-User mode and activate Host Multi-User Access

          Terminal Server & Workstations: Run Quickbooks Desktop Enterprise 21 in SINGLE-User Mode

 

Any guidance would be greatly appreciated!

12 replies

AlcaeusF
Level 14
November 10, 2022

Hello @Jvasconcelos,

 

Thank you for posting here in the Community. I'd be glad to lend a hand with setting up QuickBooks for multi-user access.

 

When hosting in multi-user mode, it's crucial to set up everything correctly. Since the computer storing a company file (the host) allows other computers to access the file, the proper setup varies from the mode chosen.

 

There are three hosting modes available depending on what you prefer for your Enterprise 2021 version. Dedicated hosting, Peer to peer hosting, and Alternate hosting.

 

Begin by checking our link about hosting, which includes diagrams illustrating the connectivity process: Hosting your company data in multi-user mode in QuickBooks Desktop.

 

On a multi-user network, one computer hosts your company files (server computer). Computers that connect to your network but don't host your company files are your workstations.

 

These additional links will guide you further with setting up QuickBooks in a server:

 

 

Also, aside from manually backing up your company file, QuickBooks can do it automatically on your behalf. For more information about how you can schedule a backup, I recommend checking out this article: Back up your QuickBooks Desktop company file.

 

Drop a comment below if you need more guidance with setting up QuickBooks Desktop. I'll keep an eye on your response. Take care.

November 10, 2022

Hi @AlcaeusF 
Thank you so much for your assistance and resource articles. Best graphic to describe our current setup is the one below:


Again, on this server we only Database Manager installed, Quickbooks desktop is NOT installed - Should I install it and turn on Hosting?

This afternoon I been reaching out to our users and personally check if their QB is set for Hosting under Utilities and no one is, setting is OFF. Yet almost every morning we will get the message the company file is locked or being used by someone, sometimes error H505, H202.. Only solution is to reboot the server where company file and QB Database Manager resides.

katherinejoyceO
Level 9
November 11, 2022

Thanks for coming back, @Jvasconcelos. Yes, you can follow the suggestion shared by my peer AlcaeusF to install Quickbooks on a server and then turn on hosting.

 

Here's the link with complete steps to guide you in this process: Install QuickBooks Desktop on a server

 

Let me know if you have additional concerns about installing QuickBooks and hosting. We're always around to help.