QBDSM Setup Guide
QBDSM Setup Guide

Download, Install , Setup QuickBooks Database Server Manager

To set up a multi-user network in QuickBooks, you need to install and set up QuickBooks database manager, which shares the company file over a network with multiple workstations. Apart from sharing the company file, the database manager manages and monitors the company file as well. After setting up the network, you need to keep QuickBooks database server manager running to access the company file from multiple workstations. Also its will help for QuickBooks Setup For Workstation users .

Note:: Only users who want to set up a multi-user network for QuickBooks desktop need to set up QuickBooks database server manager. If you don’t plan on using a multi-network setup for your accounting software, then you don’t need to install this database server manager on your system.

Download And Install Database Server Manager QuickBooks

The installation files for the database server manager are included in the setup for QuickBooks Desktop. Once you’ve downloaded the setup for QuickBooks Desktop accounting software, you can follow the steps provided below to install the database server manager on your system:

  1. Restart your system/server.
  2. Launch the QuickBooks Installation File.
  3. Follow the on-screen instructions and enter the product and license numbers to activate the product.
  4. Select Custom or Network Options as the installation type. Hit Next.
  5. Select the best option for network setup according to your preferences. Here are the available options:
    1. I’ll be using QuickBooks desktop on this computer, And I’ll be storing…: If you plan to install QuickBooks desktop and the database server manager on the server computer, then you must select this option.
    2. I’ll not be using QuickBooks Desktop…: If you don’t want to install QuickBooks Desktop on the server computer, then select this option.
  6. Follow through with the rest of the process till the software is installed on the server computer. Click on Finish.

 

Note:: If you want to have access to multiple versions of QuickBooks on your server, then install the oldest versions first and move to the newer versions. This is very useful for professional accountants who need to manage company files for multiple clients.

Configure QuickBooks Database Server Manager

To properly configure QuickBooks database server manager, follow the steps provided below:

  1. Open the Start
  2. Type in ‘Services’.
  3. Click on QuickBooksDBXX, where XX is the version number of QuickBooks.
  4. From the General tab, find the server status. Select STOP.
  5. Click on Startup Type and select Automatic.
  6. In the Logon tab, select the Local System account option.
  7. In the Recovery tab, choose Restart the Service for the following options:
    1. First Failure
    2. Second Failure
    3. Subsequent Failure
  8. From the General tab, select Start.

 

Now you’ve successfully configured and restarted QuickBooks Database server manager. But the task isn’t finished yet. To use the database manager to sync data between the server and multiple workstations, you need to properly set up Windows Firewall.

Firewall Settings To Allow QBDSM

To set up windows firewall, follow the steps provided below:

  1. Go to the Start
  2. Type in Windows Firewall and hit Enter.
  3. Click on Advanced Settings.
  4. Click on Inbound Rules and then New from the right panel.
  5. Select the Port through which you want to enable connections and hit Next.
  6. Select TCP and enter the required ports which are required by QuickBooks for setting up a proper multi-network connection.
  7. Click on Allow Connection and hit next.
  8. Enter a name and description for the Rule and click on Finish.
  9. Repeat the steps to create outbound rules.

 

Now you can begin using QuickBooks Database Server Manager.

How To Use Database Server Manager QB ?

After installing and configuring the database server manager, you need to scan the folders on your server for the company file to begin using the multi-network setup.

To scan folders on the server for company files, follow the steps provided below:

  1. Open the start menu on your server computer.
  2. Type in Database and click on QuickBooks Database Server Manager.
  3. From the Scan Folders tab, select Browse.
  4. Select the Folders which contain the Company files.
  5. Click on Ok.
  6. Click on Start Scan.

You can restrict the server manager from scanning all of the folders on your server. To do so, you’ll have to set up folder permission. This is especially important if you’re using database server manager 2019.

AccountsPro suggests using QuickBooks Hosting Services , so user can get automatic update and upgrade of QuickBooks Database Manager without any issues and errors.

After the scan is finished, you’ll find the folders listed in the QuickBooks company files found section. These company files can now be accessed over the network from any connected workstation.

QuickBooks Database Server Manager Failed to Start

If the database server manager failed to start or you see an error, then you need to follow with one of the methods provided below to get it started.
If QuickBooks Desktop and Database Server manager are installed on the Server

  1. Launch QuickBooks Desktop on the server
  2. From the File menu, select Open or Restore Company.
  3. Click on Open a Company File.
  4. Find the Company File and click on Next.
  5. Click on Open file in multi-user mode and hit Open.
  6. Log into the Company File.
  7. From the File menu, click on Close Company/Log off.
  8. Open the start menu and type in ‘Database’. Click on QuickBooks Database Server Manager.

This will restart the program on your system and resolve the error.
If only QuickBooks Database Server Manager is installed on the Server

  1. Open Control Panel through the start menu.
  2. Click on Administrative Tools.
  3. Select Services.
  4. Right click on QuickBooksDBXX, where XX is the version of the database server manager installed on your system.
  5. Select Restart.

This will restart the database server manager and resolve QuickBooks Error.

Error Troubleshooting QuickBooks Database Server Manager

If you are getting errors and issue like to mention below related to QBDSM then connect to QuickBooks Support Number to get help.

Issues Error
QuickBooks Database Manager Not Running QuickBooks Database Server Manager Error 1069
QuickBooks Database Manager Conflicting With Dns Server QuickBooks Database Server Manager Failed Resolve Errors And Retry
QuickBooks Database Manager Service Failed To Start QuickBooks Database Server Manager Folder With This Name Is Already Shared
QuickBooks Database Manager Network Diagnostics Failed QuickBooks Database Server Manager Hosting Mode Is Off
QuickBooks Database Manager Not Running On This Computer QuickBooks Database Server Manager Has Stopped Working
QuickBooks Database Manager No Files Are Connected QuickBooks Database Server Manager Wrong Ip Address
QuickBooks Database Server Manager Not Available QuickBooks Database Server Manager Keeps Crashing
QuickBooks Database Server Manager No Files Are Connected QuickBooks Database Server Manager Keeps Stopping
QuickBooks Database Server Manager Connection Sharing Not Allowed QuickBooks Database Server Manager Qbdbmgrn Not Running On This Computer
QuickBooks Database Server Manager Crashes QuickBooks Database Server Manager Qbcfmonitorservice Not Running
QuickBooks Database Server Manager Checking For File And Folder Permissions QuickBooks Database Server Manager Running No Files Are Connected
QuickBooks Database Server Manager Disabled Exceptions Not Defined QuickBooks Database Manager Started Then Stopped
QuickBooks Database Server Manager Does Not Start QuickBooks Database Server Manager Unable To Retrieve Connected Files
QuickBooks Database Server Manager Disconnect User

FAQs – QBDSM QuickBooks Desktop Pro, Premier , Enterprise

How do I resolve network errors which I receive when using the database server manager?

If you’re getting network errors, then you didn’t configure windows firewall properly. We’ve mentioned the steps to properly create inbound and outbound rules to configure the firewall. These rules create exceptions and enable QuickBooks to connect through certain previously blocked ports.

I cannot find the setup for QuickBooks Database Server Manager. How do I get the setup ?

The setup for the database server manager is included in the setup for QuickBooks Desktop accounting software. When you install QuickBooks, instead of Express Install, select Custom or Network Options to install the database server manager on your system.

How much time would it take to scan the folders on the server for the company file ?

The process is almost instantaneous if you selected the folder which contains all the company files. Don’t simply select a whole drive to be scanned as that would take a lot of time.

Related Posts

1 Comment

  • Connor Peake

    I do IT for a company and I have some questions regarding licensing and quickbooks database server manager ,well they utilize 2012 to 2021 ,so my question is can i use one of the already active keys to download the quickbooks database server manager?

Leave a Reply

Your email address will not be published. Required fields are marked *

AccountsPro Disclaimer
Call Now CALL NOW