QuickBooks-Database-Server-Manager-Tool

QuickBooks database server manager 2022

QuickBooks Database Server Manager makes it easy to share company files with remote computer over your network. Monitor the multi-user network and use the software to send information to the QuickBooks desktop editions.

What QuickBooks Database Server Manager tool Does?

It can operate the following tasks for you:

  • Scan the QuickBooks company file which is compulsory for multi-user access.
  • Study the local storage device to detect a new company file automatically.

NOTE: The QuickBooks Desktop requires for optimum file performance on the network, you can install and set-up this tool on the computer where the company files are located. The below given image shows how QuickBooks Database server manager tool looks like:

QuickBooks-Database-Server-Manager-QBDSM-Screenshot.gif

Some Important Points

  • Add a User: Each QuickBooks versions will add a user when the QB Database Server Manager is installed. (For Example- QBDataServiceUser28 for 2018 and QBDataServiceUsers27 for 2017).
  • Multiple Versions: If you are installing various versions of Database Server Manager it will grant you only numerous versions of processes, but it cannot provide multiple versions of the software.
  • Dump that the year’s database services are running in the background when the Database Server Manager works for every year. Make sure that the functions of the Windows interface which are accessible via the Windows and the “Control Panel” than this service are labeled as QuickBooks DBXX, where the XX shows the number of versions (example- “27” is for QB Desktop 2018 and “28” for QuickBooks desktop 2019).
  • QuickBooks Database Server Manager (QBDBMS): QBDBMS created a Network Data files and stored the company files on the host computer. If you wish to use multiple versions of QB Desktop, then you should install every version of the Database Server Manager.
  • You may install the QB Database Server Manager in a chronological order from oldest to newest for each version when you want to use multiple versions of QuickBooks desktop.

How to set up QuickBooks database server manager?

In this section, we will talk about the steps that are required to use the tool. We will also talk about the setting up process.

  • First, you need to configure the firewall manually. This will allow the tool to run on the server.
  • Open the database and hit the ‘port monitor’ tab.
QuickBooks Database Server Manager Port monitor tab - Screenshot
  • Click start and then on the windows firewall tab.
  • Go to advanced settings and then inbound rule. Then click on ‘rule’
QuickBooks Firewall Port (Create a New Rule) - Screenshot
  • Select port and then hit next.
  • Make sure that you select TCP and specific local ports option.
Ensure TCP option is Checked - Screenshot
  • Then click on next then ‘allow the connection’.
Allow the connection - Screenshot
  • Mark all the profiles and hit next.
  • Create your rule and then hit the finish.

Your QuickBooks database server manager is now set up. All the company files which are designed in the scanned folders for multi-user access they will be scanned automatically.

Monitored Drive Features

Whenever you add a new company files to the server, you can use the Monitored Drive features which keeps your QuickBooks Database Server Manager update.

  • Click on Start button and then click on Program and then select on QuickBooks Database Manager.
  • Click on the Monitored Drive tab.
  • Rename and remove and then select in case you want all the local drives which you want to be monitored for company files that are added.
quickbooks-database-server-manager.gif

Database Server Features

Determine open your QB Database Server Manager

  • List the users who are logged into each company file and the company files which are connected to the server.
  • The status will be displayed on the services of the QuickBooks Database Server. All the services would be running when the server is hosting the company files.
  • In such case, if you want to change in the status of the services and then use the Services Administrative Tool to repair the services QBDBXX.
quickbooks-database-server-manager-2

Features of Update

quickbooks-database-server-manager-updates-features

In reason to download the QuickBooks Server updates use the updated features and check the versions of QuickBooks Server.

  • Firstly, click on the Start button and then immediately click on Program.
  • Click on QuickBooks Database Manager.
  • Hit a Click on Updates.

Follow the instructions displayed on the screen so that you can install the updates.

Also Read: Fix QuickBooks Server Busy Error

Quickbooks-database-server-manager-System-Feature
  • Firstly, hit a click on the Start menu.
  • Now hit a Click on Program.
  • Choose the QuickBooks Database Manager option and then hit a click on System.
  • Check on system information for the computer which has the database server installed on it.

Guide to install QuickBooks database server manager

Undermentioned are the steps that will help you to install the tool without any hassle.

  • First double-click on the installer to begin with the installation of the “Wizard“.
  • You will get an option asking your computer if they have an active internet connection. Press yes or no accordingly and hit next.
  • Next, close all the programs that are already running on your computer and hit next.
  • Read the terms and conditions on the following page and accept them when you are done.
  • Click next.
    • Now you will have to choose the “Custom or Network options“ and then the installation type.
    • When you are done, you can either choose to be the host computer or otherwise.
    • The options you will get are: I’ll be using QuickBooks on this computer And I’ll be storing and “I will not be using QuickBooks on this computer“.
  • Choose accordingly and then allow access.
  • After that, you will be asked to enter your product key and license number.
  • Follow the next steps according to the installation process.

Your tool is now installed. For the best results, set up your QuickBooks database server manager. this will be according to your preferences and you are done.