Learn the best ways to download, setup and update the QuickBooks database server manager (QBDBMS)

Do you know what QuickBooks database server manager is? How to download database server manager? What are the steps to setup QuickBooks database server manager? What is the process to update Database Server Manager? Well, if you are searching answers for any of these questions, then it is worth to spend time to read this in-depth guide. Database server manager is also named as Intuit personal database manager tool. This effective tool makes it super easy to create network data files for each and every company file on the host system. For the ones who prefer using multi-user mode, QBDBMS is a must have tool.

To know the process to download, setup, and update QuickBooks database server manager, read this post till the end. However, if you are short of time and are seeking for experts and certified professionals to assist you, then do not hesitate in calling at our toll-free number i.e. 1-800-761-1787. Contacting our QuickBooks support team will help you in making the best use of this database server manager.

You might also like: How to resolve QuickBooks error code H505?

What is QuickBooks database server manager?

QuickBooks database server manager (QBDBMS) is a remarkable utility feature by Intuit. This tool functions to organize the QuickBooks server folder for multi-user mode. It helps in making the most of multi-user mode, and also without QBDBSM it is not possible for the user to access multi-user mode. Absence of QuickBooks database server manager will restrict the software use and also will affect the performance. This tool is accountable to share the company files with other systems over the network.

QuickBooks Database Server Manager Tool - Screenshot

Facts about QuickBooks database server manager

There are certain facts related to QuickBooks database server manager, it includes:

  • The QuickBooks database server manager creates .nd files that are known as network data files on the host system
  • Database server manager is compulsory in the case of multiple versions of QuickBooks desktop. In case the user wishes to use the multiple version of QuickBooks, then the user needs to install the QuickBooks database server manager
  • The QBDBSM has multiple versions. It can offer multiple versions of processes, but it can not provide the multiple versions of the software
  • Various QB version add a user during the installation of the database server manager
  • In case the user is using multi version of QuickBooks desktop, then he/she might need to install each version of the database server manager

Process to download QuickBooks database server manager

Now that you have decided to download the QuickBooks database server manager, it is important for you to know the exact process that you are supposed to follow, in order to avoid any kind of mess. The database server manager can be downloaded without any issue, as it doesn’t involve a very huge process. However, as per the developers of Intuit and as per the observation, this effective tool is the part of QuickBooks accounting software. In case, the user is not having it, then it can be easily downloaded from the official website of Intuit.

Alternative method

In case the user founds the first option of downloading QuickBooks database server manager a bit confusing, then in that case he/she can simply carry out the steps enumerated below:

  • The very first step is to download QuickBooks Tools hub from Intuit’s website and then move to the downloads by pressing Ctrl + J keys together.
  • After that, the user needs to click on the QuickBooksToolsHub.exe file.
QuickBooksToolHub.Exe File - Screenshot 1
  • And then click Yes in order to allow the app to make changes.
  • Once done with that, the user needs to click on Next to install it and click on Yes to accept the license agreement.
  • Move ahead by click on next and install options respectively. It should be noted that the process might take some time, which demands the user to be a bit patient.
  • After the installation is complete, the user is supposed to hit Finish option.
  • Followed by, opening the QuickBooks Tool hub icon.
QuickBooks Tool Hub - Logo
  • Now, under the network issues tab, the user can click on the QuickBooks database server manager option.
QuickBooks Database Server Manager - Screenshot

After the process completes, the user will be needed to give all the users permission to access the company folders. However, by default the QBDBSM will create a unique user for each installation.

Read this also: How to Create a journal entry in QuickBooks Desktop?

Configure QuickBooks database server manager

In case the user wants to use the default setting, then he/she can skip this section. Or else can carry out the steps below:

  • The user firstly needs to open the windows start menu
  • And then, the user should type in “Services” into the search tab and then open services
  • Once done with that, the user needs to choose and open QuickBooksDBXX
  • And move to the General tab and look for the service status section. In case it’s started or running, the user should select stop tab
  • Followed by, selecting automatic from the startup type drop down menu
  • The user is then required to move to the logon tab. Also, choose the local system account option
  • Moving ahead, the user needs to move to the recovery tab. And also opt for the restart the service from each of these drop down menus: First failure, Second failure, and Subsequent failure.
  • The last step is to move back to the General tab and also choose start tab to restart the database server manager

Steps to Set up QuickBooks database server manager

After downloading the QuickBooks database server manager, it is time for set up process to be performed. The steps to carried out in this process are as follows:

Permit QuickBooks database server manager to run on the server computer

  1. To begin with, the user is supposed to configure the firewall manually, so that the QBDBSM can run on the server system.
  2. Open the QuickBooks database server manager and hit a click on the Port Monitor tab.
QuickBooks Database Server Manager Port monitor tab - Screenshot
  1. After that, the user should click on Start menu and then look for Windows firewall and open it.
Windows Firewall - Screenshot
  1. The next step is to right click Inbound rules from the advanced settings, and then select rule.
QuickBooks Firewall Port (Create a New Rule) - Screenshot
  1. Now, select Port and next options respectively.
Choose Port Option (QuickBooks Database Server Manager) - Screenshot 1
  1. Followed by, ensure that the TCP is selected.
Ensure TCP option is Checked - Screenshot
  1. After this, the user is supposed to enter in the specific ports in specific local ports option.
Configuring QuickBooks firewall and security exceptions - Screenshot
  1. The port format is as per the QuickBooks currently in use.
    • QuickBooks Desktop 2020: 8019, XXXXX. 
    • QB Desktop 2019: 8019, XXXXX.
    • QuickBooks Desktop 2018: 8019, 56728, 55378-55382.
    • QuickBooks Desktop 2017: 8019, 56727, 55373-55377.
  2. After that, click on Next and allow the connection.
Allow the connection - Screenshot
  1. Once done with that, hit Next when needed and mark all the profiles. And click Next once again.
Firewall Setting up in QBDBSM - Screenshot
  1. And then create a rule and also name it .
  2. To end the process, click on the Finish option. The user is also required to repeat the same steps for outbound rules.

Related article: How to setup charts of accounts in QuickBooks desktop?

Steps to Update QuickBooks Database Server Manager

Update your QuickBooks database server manager by following simple steps:

Steps to Update QuickBooks Database Server Manager - Infographic Image

In general, QuickBooks database server manager gets updated along with the QuickBooks desktop, but in case you wish to manually update it, then the process involves the steps stated underneath:

  1. First of all, open the official Intuit website, and then download the updated patch for database server manager.
  2. And then, the user will have to reboot the server after the installation of the patch completes.
  3. After that, the message will appear on the workstation stating “The company file needs to be updated to work this version of QuickBooks desktop
The company file needs to be updated to work this version of QuickBooks desktop - Screenshot
  1. In the next step, the user is supposed to backup the data, as these updates can make changes in the database server.
Backup your data - Screenshot
  1. And to end the process, make sure to carry out the on-screen prompts and you are good to go.

Read Also: How to Resolve QuickBooks Error Code 404?

Final words.!

The database server manager is one of the most effective features that is offered to users. Without this, the user cannot access the multi-user mode. However, at times the user gets confused with the download, set-up, and update process of QuickBooks database server manager. After going through this article, you might be able to learn a lot of things related to QBDBMS. We hope that this article might be able to help you to make the best use of database server manager.

Whereas, if you are having any question in your mind, or in case you got stuck somewhere, then do not hesitate in talking to our accounting professionals, as we will be happy to help you anytime. You can call us at our toll-free number i.e. 1-800-761-1787, and converse the issue with our QuickBooks enterprise customer support team. Our experts will ensure to resolve all your queries in the best possible way. Thus, hurry up and call us and let our team manage the rest on your behalf.


Other helpful blogs/posts:

Solution of QuickBooks error code 1402

How to fix QuickBooks unable to create accountant’s copy issue?