Want to create a QuickBooks database server manager? Follow this guide!

Comments · 62 Views

Learn about QuickBooks Database Server Manager, its setup, features, and troubleshooting tips to manage multi-user access efficiently.

QuickBooks Database Server Manager allows you to share your company files with other computers in your network. In the event that you have installed a network to monitor your multi-user network, start QuickBooks Database Server Manager so users can log in to access the company files. If something is prevented from a multi-user connecting with your server, the QuickBooks error h202 will be encountered.

Note: If you require more than one user to have access to your file, you only need Database Server Manager; if not, then you don't need to have it.

Need help with the setup of Database Server Manager? Call 1.855.738.2784 to get information and support from QuickBooks experts 24/7.

Download Database Server Manager

Database Server Manager is contained in the QuickBooks Desktop file, and this will automatically update. You download and update the QuickBooks Desktop.

How to install Database Server Manager

Download the QuickBooks Database Server Manager on your server computer, where your company files are hosted.

Important: In case you are hosting several versions of QuickBooks Desktop on the same network, install them in sequence starting from the earliest to the latest.

  1. Close all your programs on your server computer, including QuickBooks.
  2. Locate the install file Setup_QuickBooks.exe you downloaded and double-click it.
  3. Follow the on-screen instructions that appear to find your product or license numbers.
  4. Choose Custom or Network Options to install the type, and click Next. Do not select Express.
    Note: If you want to keep the prior version to compare and troubleshoot, then the implicit choice is to install QuickBooks Desktop overtop of your prior version of QuickBooks Desktop.
  5. Click Next to install the Database Server Manager. In this step it will not overwrite any company data if QuickBooks Desktop is installed on your server computer.
    • If you plan to have Database Server Manager and QuickBooks Desktop on the server computer, select the suggested option: "I'll be using QuickBooks Desktop on this computer, AND I'll be storing our company file here so it can be shared over our network."
    • If you plan to only have Database Server Manager on your server computer, select "I will NOT be using QuickBooks Desktop on this computer."
  6. These instructions will tell the rest of what to do on the screen. When you are done, click Install. Windows will sometimes make you confirm.

Note: QuickBooks installs a new Windows user for each release of Database Server Manager. For example, Database Server Manager 2023 appears in the list as QBDataServiceUser33.

Allow the QBDataServiceUserXX (where XX is the user number) to read and access the folders that contain files relevant to your business. When you grant system-level permissions, you can see these users.

Set up Database Server Manager

If you don't wish to use the default, just skip this step and move on to Step 3.

  1. Click on the Windows Start menu.
  2. Type Services in the search box and open Services.
  3. Select and open QuickBooksDBXX. XX is the version number.
  4. In general, look for Service status. If it is either Started or Running, select Stop.
  5. On Startup type, select Automatic
  6. And click on Logon - Local System account.
  7. Recovery -> Restart the service from each of these: First failure, Second failure, Subsequent failures
  8. General Start to reboot Database Server Manager.

Configure your firewall permissions

Check your firewall and antivirus permissions. If you haven't done so, ensure you are allowing the Database Server Manager to run on your server computer.

Scan company files

Go through how to scan your company files so that you can host them over your network.

Conclusion

You can consider setting up multi-user access in QuickBooks as the best step for collaborating. This guide will walk you through a deployment of QuickBooks database server manager across your network, testing connectivity, and routine maintenance that will create the best performance for you. The database server manager makes it very easy to access your company data.

Recommended To Read: How To Resolve An unexpected error has occurred in “QuickBooks”: mainframe must be already created by now as this dll is demand loaded

Comments