User Navigation
With the introduction of QuickBooks to the market, the way accounting is done has changed dramatically. This new era program has quickly become popular accounting software due to its extensive features that aid in accounting, bookkeeping, payroll, sales, and inventory. Among many amazing features and tools offered by Intuit, QuickBooks Database Server Manager (QBDSM) is also one of the highly useful tools. Before digging in deep and exploring the facts related to QBDSM, it is recommended to know what it is all about. This article gives you the complete information and quick process for how to install, Update and Set up QuickBooks Database Server Manager. Thus, make sure to read this post till the end.
Understanding of QuickBooks Database Server Manager:
Designed by Intuit, it is a very useful and powerful feature that enables users to set up a QuickBooks server for multi-user access. This utility creates a network data file (.ND) for the host computer’s company file. It’s also referred to as Inuit’s personal database manager software. This incredible feature makes it simple for users to create network data files for company files that are stored on the host system or host workstation.
If a user wishes to use numerous desktop versions of QuickBooks, this useful utility must be installed. The user cannot access multi-user mode without this utility. Each QuickBooks database server manager version installed on the system adds a new user to the desktop version.
It can Help you to Perform the Following Activities:
β€ Scan the QuickBooks company file because multi-user access is dependent on it.
β€ Check for new company files on the local storage device automatically.

Step by Step Instructions to Install QuickBooks Database Server Manager:
Steps for Install QuickBooks Database Server Manager
π First, go to the QuickBooks Installer and double-click on the same and βStartβ with the installation of the βWizardβ
π Next, select the βNextβ if the system has proper internet connection and the updates can be downloaded
π In case, there is no internet connection then choose βNoβ >>> βNextβ
π Now, next move is to close all the other running applications and then hit βNextβ
π Read out the complete terms of the Software License Agreement and then select the βI accept the terms in the license agreementβ and if youβre agree with all the terms and conditions then hit βNextβ
π Choose the option βCustom or Networkβ and then choose any one from the two installation types:
π Select βIβll be using QB on this computer AND Iβll be storingβ if you plan to run the QB program on this computer.
π Select βI will NOT be using QuickBooks on this computerβ if you will use this computer just to store QuickBooks data.
π To allow the access, click βYesβ, Allow βAccessβ
π Type the correct License and product number within the relevant field of βLicense Number and Product Numberβ
π To complete the installation, perform the installation prompts instructions
π At last, you need to set up the Database Server Manager once the installation is accomplished.Β Β
Steps to Update QuickBooks Database Server Manager
It is suggested that you regularly update the βDatabase Server Managerβ. 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:
π Move to the βUpdate QuickBooks Desktopβ >>> βDownload the Patchβ to the latest release update
π After the patch installation is successfully completed, you have to reboot the server
π You will receive the following message β The company file needs to be updated to work with this version of QuickBooks desktopβ after the server is updated
π Because these changes can change, rewrite, or replace the database structure, you will be prompted to create a backup
π Following the onscreen instructions, you should be able to open the QuickBooks company file after the backup is complete.
Steps for Setup the QuickBooks Database Server Manager
π In the beginning, open the QuickBooks Database Server Manager
π Next, scan the files that you wish to use for multi-user access
π Now, scan the company files on the server to make sure that the files are configured properly to give them access to the multiple users
π After that, add a new company files to the server
π Once done then you can use Monitored Drives Features and keep your Database Server Manager up-to-date
π Make sure that the company are connected to the server and users are logged into the company files
π Change the status of the service if you want then implement the Service Administrative Tools and configure the service
π In the end, use the feature βUpdatesβ and then download the recent updates to the QuickBooks Server.
Steps to Allow QuickBooks Database Server Manager to Run on the Server Computer
π To start with configuring the firewall manually and then QBDBSM can easily run on the server computer
π Launch the QuickBooks Database Server Manager and click the tab βPort Monitorβ
π Next, click βStartβ menu >>> find the Windows Firewall and then open it
π From the Advanced Settings, do a right-click on the Inbound rules and then select the βruleβ
π Now, select the βPortβ followed by βNextβ button respectively
π Make sure that the TCP should be selected
π In a particular local ports, enter the specific ports
π The port format is as per the QuickBooks is currently in use:
π QuickBooks Desktop 2017: 8019, 56727, 55373-55377
π QuickBooks Desktop 2018: 8019, 56728, 55378-55382
π QuickBooks Desktop 2019: 8019, XXXXX
π QuickBooks Desktop 2020: 8019, XXXXX
π Click βNextβ >>> βAllow the Connectionβ
π If you need, click βNextβ and then mark all the profiles and then click βNextβ once again
π Once done then βCreate a ruleβ and also give a name to it
π At last, click βFinishβ and then repeat the same steps for outbound rules as well.
Use the QuickBooks Database Server Manager, Execute the Below Steps:
Step 1: Open the QuickBooks Database Server Manager
π Go to the Windows Start menu and click βPrograms >> βQuickBooksβ
π Click on the option βQuickBooks Database Server Managerβ.
Step 2: Scan the Folder Features
π Move to the βWindows Startβ button and click βProgramsβ >> βQuickBooksβ
π Next, click βQuickBooks Database Server Managerβ and then βScan Foldersβ
π Look for the folders contain βQuickBooks company filesβ
π In case, you donβt know which files then scan the entire the whole disk
π At last, click the button βScanβ and youβll be able to view via the display bar which folders are being scanned.
When the scanned folders are entirely scanned, all of the company files that are setup for multi-user access are found.
Step 3: Add the Folder
π Click βAdd foldersβ >>> βFolderβ that you want to add there
π Under the folders, the location of the folder containing βQuickBooks company fileβ.
Step 4: Remove the Folder
By clicking the folders that contain QuickBooks Company files and then clicking “Remove Folder“, the user can “Remove” the folder.
Step 5: Hit the βScanβ Button
π This is the last step and you have to go to the listed folders containing βQuickBooks Company filesβ and click βScan the Foldersβ
π After completing the scanning, you can see the βlist of company filesβ appears in the same folder.
Step 6: Monitored Drive Features
π Move to the βStartβ button and click βProgramsβ >>> βQuickBooksβ >>> βQuickBooks Database Managerβ
π Next, click on the βMonitored Driveβ tab
π Now, you have to βremove and renameβ then hit βSelectβ
π In case, you want all the βlocal drivesβ that you want to monitor for company files which are added.
In Conclusion!
One of the most useful features available to users is the database server management. You won’t be able to use the multi-user mode until you have this. However, the download, set-up, and update processes for QuickBooks database server manager might be confusing at times. After reading this article, you should be able to understand a lot about QBDBMS. Hopefully, the aforementioned procedure is helpful for you to make the best use of QuickBooks Database Server Manager.

π Frequently Asked Questions
Q1. What are the key features of QuickBooks Database Server Manager?
Ans: Database Server, Monitored Drive, Update, and System features are the key functionalities of QuickBooks Database Server Manager. Moreover, this fantastic tool allows users to easily build network data files for company files stored on the host system or host workstation.
Q2. How do the System features help you in QuickBooks Desktop?
Ans: This is the useful feature that allows you to find the system information of the system where the database server is installed. Hereβs is how:
β€ Press the Windows Start button on your console
β€ Or simply, go to the Start menu and click βProgramsβ
β€ Select the βQuickBooksβ followed by the βQuickBooks Database Server Managerβ
β€ Choose the option βSystemβ and proceed the next to review the βSystem Informationβ for the system that has the database server installed.
Q3. Where can I use the Update feature of QuickBooks Database Server Manager?
Ans: The Updates feature can be used to download updates to the Server and to check the version of QuickBooks Server. To do so,
β€ Press the Windows Start menu on your keyboard and click βProgramsβ
β€ After that, select the βQuickBooksβ >>> QuickBooks Database Server Manager
β€ At last, select βUpdates” and carry out the prompts that appear on your screen to βCheck and Install availableβ updates.