QuickBooks Desktop allows multiple users to work on the same company file over a network. However, you need the right tools to make this process smooth and secure. The QuickBooks Database Server Manager is one of the most important tools for managing multi-user access. It helps other computers on your network connect to company files stored on a central server.

To share your company files, you must install and configure the Database Server Manager on the computer that hosts your QuickBooks data. Once configured, other users can access the same company file from their workstations without transferring it between computers.

In this guide, we will explain how to download, install, configure, and use QuickBooks Database Server Manager to share company files. Follow the steps carefully to set up your multi-user network.

What Is QuickBooks Database Server Manager?

QuickBooks Database Server Manager is a utility that allows multiple users to access a company file stored on a server computer. It manages the network connection between QuickBooks Desktop and your company data.

When you install this tool on your server, it helps workstations communicate with the company file. It also monitors the network and supports multi-user hosting.

Here are some important functions of this utility:

·         Allows multiple users to access the same company file.

·         Helps manage company files stored on a network server.

·         Supports QuickBooks Desktop multi-user mode.

·         Monitors network connections and database services.

·         Helps other computers find shared company files.

Note: You do not need QuickBooks Database Server Manager if you are the only person accessing your company file. It is mainly useful for businesses that need multiple users to work on the same data.

How to Download QuickBooks Database Server Manager

You do not need to download QuickBooks Database Server Manager separately. Intuit includes this utility in the QuickBooks Desktop installation package.

If QuickBooks Desktop is already installed on your server computer, you can check for the latest program updates. The Database Server Manager also receives updates through the QuickBooks Desktop installation and update process.

Follow these steps to get the installation file:

1.      Visit the official Intuit website.

2.      Find the QuickBooks Desktop download page.

3.      Select the appropriate QuickBooks Desktop version.

4.      Download the installation package to your server computer.

5.      If QuickBooks Desktop is already installed, check for available updates.

Once the installation file is ready, you can proceed with the installation process.

Steps to Install QuickBooks Database Server Manager

You must install QuickBooks Database Server Manager on the computer where you store your company files. This computer acts as the server and allows other systems to access shared data.

Before starting, close all running applications, including QuickBooks Desktop.

Follow the instructions below to install the utility.

Step 1: Open the QuickBooks Installation File

Locate the QuickBooks Desktop installation file on your server computer. The file usually has the name Setup_QuickBooks.exe.

Double-click the file to start the installation process. If Windows asks for permission, allow the installer to make changes to your device.

Step 2: Follow the Installation Instructions

The QuickBooks installation wizard will appear on your screen. Read the instructions and accept the required license agreement.

If prompted, enter your QuickBooks product number and license number to continue.

Step 3: Select the Custom or Network Installation Option

When the installer asks you to choose an installation type, select Custom or Network Options and click Next.

Avoid choosing the Express installation option if you need to keep an existing QuickBooks version for troubleshooting or other purposes.

Step 4: Choose Your Network Setup

QuickBooks will display two installation options. Select the one that matches your requirements.

Option 1: I'll be using QuickBooks Desktop on this computer, AND I'll be storing our company file here.

Choose this option if you want to install both QuickBooks Desktop and Database Server Manager on the same computer.

This setup allows you to use QuickBooks on the server while hosting company files for other workstations. Intuit recommends this option for users who want both functions on one system.

Option 2: I will NOT be using QuickBooks Desktop on this computer.

Select this option if the computer will only act as a server. You will install Database Server Manager without using QuickBooks Desktop on that machine.

This option is useful when you have a dedicated computer for storing and sharing company files.

Step 5: Complete the Installation

After selecting your preferred setup, click Next and then select Install.

Wait while the installation wizard copies the required files and configures the utility.

Once the process finishes, follow any remaining on-screen instructions to complete the setup.

Important: QuickBooks creates a separate Windows user account for each Database Server Manager version. For example, the 2023 version may create an account named QBDataServiceUser33.

Make sure this account has the necessary permissions to access the folders containing your QuickBooks company files. Without the correct folder permissions, other users may experience problems accessing shared data.

How to Configure QuickBooks Database Server Manager

QuickBooks Database Server Manager usually works with its default settings. However, you can configure its Windows service settings if your network requires additional adjustments.

Follow these steps to configure the Database Server Manager service:

Step 1: Open Windows Services

1.      Click the Windows Start menu.

2.      Type Services in the search bar.

3.      Select the Services application from the search results.

4.      Find the QuickBooks database service for your installed version.

The service name generally follows this format: QuickBooksDBXX, where XX represents the QuickBooks version number.

Step 2: Check the Service Status

Double-click the QuickBooks database service to open its properties.

Under the General tab, locate the Service Status section.

If the service is already running, select Stop before changing its settings.

Step 3: Set the Startup Type

Find the Startup Type dropdown menu under the General tab.

Select Automatic from the available options. This setting allows Windows to start the database service automatically when the computer starts.

Step 4: Select the Local System Account

Open the Log On tab in the service properties window.

Select Local System account as the login option.

This setting determines which Windows account runs the database service. Use the appropriate configuration for your network and security requirements.

Step 5: Configure Service Recovery Settings

Next, open the Recovery tab.

You will find three failure options:

·         First failure

·         Second failure

·         Subsequent failures

Select Restart the Service from the dropdown menu for each option.

These settings allow Windows to restart the database service automatically if it stops unexpectedly.

Step 6: Restart the Database Server Manager Service

Return to the General tab.

Select Start to restart the QuickBooks Database Server Manager service. Wait until the service status changes to Started or Running.

Your database service configuration is now complete.

How to Share QuickBooks Company Files Over a Network

Installing Database Server Manager is only one part of the setup process. You must also prepare your company file folders and network permissions so other computers can access the data.

Here are two important tasks to complete after installation.

1. Configure Firewall and Antivirus Permissions

Windows Firewall or third-party antivirus software may block QuickBooks network communication.

To prevent connection problems, make sure your firewall and antivirus settings allow QuickBooks Desktop and Database Server Manager to communicate over your network.

Check that the required QuickBooks applications and network ports are allowed. The specific ports depend on your QuickBooks Desktop version.

Avoid disabling your firewall or antivirus permanently. Instead, create the appropriate exceptions while keeping your system protected.

2. Scan Your Company Files

After installing Database Server Manager, scan the folders that contain your company files.

The scan helps the utility identify company files that need network hosting.

Follow these instructions:

1.      Open QuickBooks Database Server Manager.

2.      Select the Scan Folders tab.

3.      Choose Browse to locate the folder containing your company files.

4.      Select the appropriate folder.

5.      Click Start Scan.

6.      Wait for the scanning process to finish.

Once the scan completes, Database Server Manager will update the folder information so other computers can access the hosted company files.

Make sure your company files are stored in a shared network folder with the correct Windows permissions.

Common Problems With QuickBooks Database Server Manager

Sometimes, users experience network or hosting problems even after installing Database Server Manager. These issues can prevent workstations from opening company files in multi-user mode.

Some common problems include:

·         QuickBooks Database Server Manager not running.

·         Company files not appearing after scanning.

·         Firewall blocking QuickBooks network communication.

·         Incorrect folder-sharing permissions.

·         Database service stopping unexpectedly.

·         Multi-user mode connection errors.

To troubleshoot these problems, check whether the database service is running, verify folder permissions, review firewall settings, and scan the company file folders again.

You should also confirm that the server and workstation computers are connected to the same network and that network discovery and file sharing are configured correctly.

Final Thoughts

QuickBooks Database Server Manager plays an important role in sharing company files across multiple computers. It allows businesses to manage their QuickBooks Desktop data from a central server while giving authorized users access through their workstations.

To set it up correctly, download the QuickBooks Desktop installation package, install Database Server Manager on the server computer, configure the database service, and scan your company file folders. You should also check firewall permissions and Windows folder-sharing settings.

By following these instructions, you can create a better multi-user environment and make it easier for your team to work with shared QuickBooks company files.