QuickBooks Database Server Manager – Install, Update & Setup

|

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:

  • 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.  

Also Read: How to Resolve Damaged QuickBooks Database Error

Steps to Update the QuickBooks Database Server Manager:

QuickBooks Database Server Manager - Install, Update & Setup

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.

Implement the Below-Instructions to Set-up 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
    • QB Desktop 2018: 8019, 56728, 55378-55382
    • QuickBooks Desktop 2019: 8019, XXXXX
    • QB 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:

QuickBooks Database Server Manager - Install, Update & Setup

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.

QuickBooks Database Server Manager - Install, Update & Setup

πŸ”” 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.

Summary

QuickBooks Database Server Manager
Article Name: QuickBooks Database Server Manager – Install, Update & Setup
Description: Learn how to Install, Update, uninstall & Download the latest version of QuickBooks Database Server Manager in simple steps. QB Database Server Manager....
Author Name: Shawn
Publisher Name: Accountingguide.co

Further Reading

Phone

+18583006463

Book a meeting
Chat Now