QuickBooks Database Server Manager

By :
Category : Technology

Technology

QuickBooks Database Server Manager Installation, Update, and Setup Guide

The advent of QuickBooks has revolutionized the field of accounting. This modern software is packed with a multitude of remarkable features that facilitate bookkeeping, payroll, sales, and inventory. It’s user-friendly interface has made it an instant success among multinationals, mid-level companies, small businesses, entrepreneurs and even individuals. There are plenty of tutorials online as well as Intuit QuickBooks Support services to help users get up and running in no time. One noteworthy feature built into this program is the QuickBooks Database Server Manager.

The purpose of this article is to cover the various aspects of QuickBooks database server manager. Please read until the end of this post. Nevertheless, if you need expert assistance, you can contact our QuickBooks desktop support team at 1-800-986-6821. Using our toll-free number, we provide the best possible support to QuickBooks users. We are a hub of experts and certified professionals.

What is QuickBooks Database Server Manager?

The QuickBooks Database Server Manager (known also as Inuit’s personal database manager tool) makes it easier for users to configure the QuickBooks server for multi-user access and create/manage network data files (.ND) which are necessary in order to have access to the company file. Without this tool, it would be impossible to access the multi-user mode and should you wish to include multiple desktop versions of QuickBooks, each one will require its own installation. Further down the article, we’ll look at how to install, update and setup the QB Database Server Manager.

It can perform the following activities:

For multi-user access, it is important to scan the QuickBooks company file
Detect new company files automatically by checking the local storage device

Important: To ensure optimum file performance, you can install and set up QuickBooks Desktop in the location of the company files on your computer.

Simple Tips to Follow

When you want to use multiple versions of QuickBooks Desktop, it is important to install each version of the QuickBooks Database Server Manager.
When you install multiple versions of Database Server Manager, you will receive multiple versions of processes, but not multiple versions of the software.
If you want to use multiple versions of QuickBooks Desktop, install the Database Server Manager chronologically, starting with the oldest version.
When the server works for each year, the database services are running in the background. Ensure that the services of the window interface that can be accessed through Windows and the Control Panel are referred to in QuickBooks DBXX where the xx shows the number of versions.
The QuickBooks Database Manager adds one user for each version of QuickBooks (ex. QBDataServiceUser28 for 2018 and QBDataServiceUsers27 for 2017).

Install QuickBooks Database Server Manager

Installing QuickBooks database server manager begins by double-clicking on the installer and selecting “Start” with the Wizard installation.
Click “Next” to download an update if you have internet access. If you do not have internet access, tap “No” and then “Next”.
After clicking “Next”, the user will have to close “All programs” that are open.
The user must also carefully read the “Terms of the software license agreement”. If you agree with the “Terms and conditions”, select “I accept the terms and license agreement” and click on “Next”.
Once that is done, the user must choose “Custom or Network options”
Click on the type of installation after this.
o You can also select “I’ll be using QuickBooks on this computer and storing”…and when you want to run the program.
o When only QuickBooks data will be stored on this computer, select “I will not be using QuickBooks on this computer…”.
Next, click on “Yes”, Allow “Access”.
Enter your “License Number” and “Product Number”
Follow the screen instructions to complete the installation process.
After the installation is complete, set up the QuickBooks Database Server Manager by following the relevant steps.

How to update QuickBooks Database Server Manager

Whenever a critical update is released or a new version of QuickBooks Desktop is installed on a computer, QuickBooks Database Server Manager needs to be updated.

Start with download the patch.
It is very important to reboot the server after the installation is complete.
On each workstation, once the server is updated, you will receive the message: The Company File needs to be updated to work with this version of QuickBooks Desktop.
In such cases, you will receive a message that says “Create a backup” after the updates.
The users will be able to open the file once the backup has been completed if you follow the prompts.

The QuickBooks Database Server Manager Setup and Use Guide

Database Server Manager can do the following:

The folders and QuickBooks company files that need to be configured for multi-user access are scanned
The local hard drives are used to automatically configure new company files

Step 1: Open the QuickBooks Database server manager

Learn How to Open the QuickBooks Database Server Manager:

Click on “Start”, then click “Programs”, then click on QuickBooks, and then click on “QuickBooks Database Server Manager”.

Step 2: Scan The Features of Your Folder

You should scan the company files on the server to ensure that they are configured so that other users can access them easily.

Click on the “Start” button, then click on “Programs”, then on QuickBooks, then on QuickBooks Database Server Manager.
Then click “Scan Folders”
If you don’t know which files contain QuickBooks company files, then scan the entire disk.
Last but not least, click the “Scan” button.

When the scan folders completely scanned, all the company files configured for multi-user access will be available.

Step 3: Step to Add a Folder

Choose the “folder” you wish to include by clicking the “Add folders” button.
The location of the QuickBooks company file folder under the folders containing QuickBooks.

Step 4: Remove the Folder

A user can “Remove” a folder by clicking on the folder that contains the QuickBooks Company file and then clicking “Remove Folder”.

Step5: Click on the Scan Button

Lastly, click on the “Scan the folders” button under the folders containing QuickBooks company files.
The “list of company files” found in that folder will appear once the scanning is complete.

Step 6: Monitored Drive Features

In order to add a new company file to the server, you can use
Your QuickBooks Database Server Manager is always up-to-date with the “Monitored Drive features”

Go to the “Start” button, click “Programs”, then QuickBooks, and then QuickBooks Database Manager.
Then click “Monitored Drive”
In case you want to monitor all the “local drives” for company files, click on “Remove and rename” and then click on “Select”.

How does QuickBooks database server manager work?

QB database server manager has the following features.

Features of a database server

In order to determine whether your QBDSM is open, follow these steps:

There is a list of users logged into each company file, as well as the company files that connected to the server.
When the QuickBooks Database Server is hosting company files, all services should be running.
Use the Services Administrative Tool to configure the services QBDBXX if you want to change their status.

Update Features

Click here to download QuickBooks Server updates, use the updated features, and view QuickBooks Server versions.

Click on the “Start” button, then on “Programs”, then on QuickBooks, and then QuickBooks Database Manager.
Click on “Updates” after this
Follow the instructions on the screen to install the updates

System Features

You can use the system feature to find any information about the computer where the database server is installed.

On the “Start menu”, click on “Program”, then QuickBooks, and finally QuickBooks Database Server Manager.
The next step is to click on the “System” option.
In addition, check the “System information” for the computer that has the “Database server” installed.

What is the best way to configure QuickBooks database server manager?

Follow the below steps to successfully configure the QBDSM once you have installed it.

Follow these steps if you only installed the database server manager

Start by clicking on the Windows start button
Choose the services tab after typing services in the search field
In the next step, select and open QuickBooksDBXX.XX. The xx stands for the version number of your QuickBooks database.
Look for the server status section under the general tab
If it is running, choose the stop option
Click on the automatic tab from the startup type menu
Then select the local system account option from the logon tab
From each of the dropdown menus on the recovery tab, select restart the service
To reboot the database server manager, return to the general tab and select start

If you have installed QuickBooks Desktop and database server manager

The first step is to open the QuickBooks Desktop on the server
Following that, the user needs to select open or restore company from the file menu
Select open company file as the next step
View the open company file as well
Click on the next tab
Select the option to open the file in multi-user mode now
Click on the open tab as well
Logging into the company file is the next step
Go to the file menu
Close the company
This will close the server’s file
After that, the user should open the Windows start menu
Open the database server manager after entering database in the search bar

What can be Do to fix QBDSM?

In order to repair the QuickBooks database manager, follow the steps below:

In QuickBooks, the very first step is to go to the file menu options.
To rebuild the data, navigate to the utilities tab and select it
Then, select the ok tab in the information window
Furthermore, wait until the process is complete.
At the end of the process, click on the ok tab.

Final Thought

I hope this article helped you to install, update, and set up QuickBooks Database Server Manager. If you have any questions, please contact QuickBooks enterprise technical support.

At RepairContact, we are a team of Intuit Certified ProAdvisors who are available 24/7. Our experienced technicians are available to provide you any kind of guidance or fix any error encountered by QuickBooks or database server manager. Dial our toll-free support number at 1-800-986-6821.

QuickBooks Database Server Manager