How to Install, Update, and Set up the QuickBooks Database Server Manager?

Guide to Installation, Update and Set up of QuickBooks Database Server Manager

With the emergence of QuickBooks in the market, there is a stark change in the way accounting is done. As this new age software consists is of very advanced features helping in accounting, bookkeeping, payroll, sales and inventory, in no time it has become a popular accounting software. Today, it is being used by big multinational organizations, mid-level companies, small businesses, entrepreneurs and even individuals. What is best about this software is users can easily use it because of its simple interface. In fact, guidelines are available in the internet as well as QuickBooks Support services. One of the main aspects of this is the QuickBooks Database Server Manager.

In today’s article, we are going to discuss the various aspects related to QuickBooks database server manager. Thus, make sure to read this post till the end. However, if you are looking for expert assistance, then in that case you can get in touch with our QuickBooks desktop support team via our toll-free number i.e. 1-844-405-0907. We are a hub of experts and certified professionals, who will ensure to provide the best possible support to QB users.

You may also like: Condense Data Utility and Repair your QuickBooks File

What is QuickBooks Database Server manager?

It basically allows users to configure QuickBooks server for the multi-user access. This tool develops network data file (.ND) for the company file in the host computer. It is also fanous as Inuit’s personal database manager tool. This amazing tool makes it easy for the users to create network data files for the company file present on the host system or on the host workstation. In case the user wants to use multiple desktop version of QuickBooks, then the user will have to install this effective tool. Note that without this tool, it is not possible for the user to access multi-user mode. Each version of QuickBooks database server manager installed on the system adds to a new user to the desktop version. Later in this article, we will discuss how to install, update and setup the QuickBooks Database Server Manager.

Following are the activities it can perform:

• Scan the QuickBooks company file as it is important for the multi-user access
• Check the local storage device so as to detect new company file automatically

Important Note: The QuickBooks Desktop needs the optimum file performance on the network and so you can install and set up the tool on your system in the location of the company files.

Easy and Quick Tips to follow

• The QuickBooks Database Server Manager develops Network data files and stores the company file in the host computer. In case, you want to use the multiple version of QuickBooks Desktop it is important to install each version of the Database server manager.
• If you are planning to install multiple versions of Database Server Manager then it will provide you with only multiple versions of processes. However, it cannot provide multiple versions of the software.
• Install the Database server Manager in a chronological order, which is from the oldest to the newest version, when you want to use multiple versions of QuickBooks Desktop.
• Be informed that the year’s database services are running in the background when the server works for each year. Ensure that the services of the windows interface that can be accessed through the Windows and the Control Panel than this service is mentioned in the QuickBooks DBXX where the xx shows the number of versions.
• Each of the QuickBooks versions add one user when the QuickBooks Database Manager is installed. (ex. QBDataServiceUser28 for 2018 and QBDataServiceUsers27 for 2017).

See Also: How to Fix QuickBooks Install Error Code 1722?

Steps to Install QuickBooks Database Server Manager

1. In order to install QuickBooks database server manager, the initial step is to double-click on the installer and the “Start” with the installation of the “Wizard“.
2. If your computer has internet then to download an update click on “Next“. In case the computer is not connected with the internet then tap on “No” and then on “Next“.
3. Now, the user will have to close “All programs” that are open and click on “Next“.
4. The user is also required to carefully read the “Terms of the software license agreement” and if you agree with the “Terms and conditions” then select “I accept the terms and license agreement” and click on “Next“.
5. Once done with that the user needs to opt for “Custom or Network options“
6. After this click on the installation type
   • Select “I’ll be using QuickBooks on this computer And I’ll be storing“….and when you want to run the program in your system.
   • Opt for the “I will not be using QuickBooks on this computer…” when only QuickBooks data will be stored on this computer.
7. The next step in the process is to click on “Yes“, Allow “Access“.
8. And then enter your “License Number” and “Product Number“
9. In order to complete the whole installation process follow the instructions that are displayed on screen.
10. And then, when the installation part is done, make sure to carry out the relevant steps to set up the QuickBooks Database Server Manager.

You may also read: How to Fix QuickBooks Error code 1920?

Steps to Update QuickBooks Database Server Manager

It is necessary to update QuickBooks Database Server Manager. It is important because when a critical update is released or when the new version of QuickBooks Desktop is installed in the computers.

1. To begin with download the patch.
2. After the completion of the installation, you have to reboot the server and it is very important to do so.
3. Once the server is updated on each of the workstations you will get the message: The Company File needs to be updated to work with this “version of QuickBooks Desktop.”
4. After that, the updates can modify the database structure and in such instances, you will get the message to “Create a backup“.
5. This will allow the users to open the file when you follow the prompts once you complete the backup.

You may also like: How to Clean Up before you upgrade to QuickBooks desktop 2019?

Steps to Set up and Use the QuickBooks Database Server Manager

The Database Server Manager tool can do the following:

1. The folders and QuickBooks company files that needs to be configured for multi-user access are scanned
2. The local hard drives are used so as to automatically configure new company files

“Hope this infographic will be informative for you to understand about set up of QuickBooks Database Server Manager”

Step 1: Open QuickBooks Database server manager

Get to know how you should open the QuickBooks Database Server Manager:

• The initial step in the process is to Go to “Start” button then click on “Programs”, then click on QuickBooks, and then click on “QuickBooks Database Server Manager“.

See Also: Easy steps to restore files in QuickBooks desktop?

Step 2: Scan your Folder Features

The company files that you store on the server should be scanned to ensure that they are configured to permit other users to access these company files easily.

• Go to the “Start” button and then click on “Programs“. After this click on QuickBooks. Then on QuickBooks Database Server Manager.
• And then click on “Scan Folders“

• After this look for the folders that contain “QuickBooks company files“. In case you don’t know which files then scan the entire the whole disk.
• Lastly click on the “Scan” button.

All the company files that are configured in the scanned folders for multi-user access when they are completely scanned.

Step 3: Steps to Add Folder

• Click on “Add folders” button and then select the “folder” you wish to include there.
• The location of the folder under the folders which contain the “QuickBooks company file“.

Read this also: How to Fix QuickBooks Error 404?

Step 4: Remove the folder

• The user can “Remove” the folder by clicking the folders that contain QuickBooks Company file and afterwards click to the “Remove Folder“.

Step 5: Click on Scan Button

• Finally, click to “Scan the folders” button that is present under the folders that contain QuickBooks company files.
• After finishing the scanning, you will see the “list of company files” found on that folder.

See Also: How to Fix QuickBooks Error 6000 77?

Step 6: Monitored Drive Features

When you add new company file to the server, you can use the
“Monitored Drive features” which keeps your QuickBooks Database Server Manager updated

• First of all, go to the “Start” button and then click on “Programs“, then on QuickBooks and then click on QuickBooks Database Manager.
• And then, click on “Monitored Drive tab“
• “Remove and rename” and then click on “Select“, in case you want all the “local drives” that you want to monitor for company files.

What are the features of QuickBooks database server manager?

Following are the features of QB database server manager.

Database Server Features

To determine open your QBDSM:

• The list of users who are log into each company file and the company files that connect to the server.
• The status which displays the services of the QuickBooks Database Server. All the services should be running when the server is hosting the company files.
• In case, you want a change in the status of the services then use the Services Administrative Tool to configure the services QBDBXX.

Read Also: How to Fix QuickBooks Error 6129, 0?

Update Features

To download QuickBooks Server updates, use the updated features and view the versions of QuickBooks Server.

• First go to the “Start” button and then click on “Program“, then on QuickBooks and click on QuickBooks Database Manager.
• After this click on “Updates“
• In order to install the updates, follow the instructions displayed on the screen

System Features

In order to find any kind of information about the computer where the database server installation use the system feature.

• In the “Start menu” click on “Program” then on QuickBooks and finally on QuickBooks Database server manager.
• On the next step, click on the “System” option.
• And lastly, check the “System information“ for the computer which has the “Database server” installed.

How to configure QuickBooks database server manager?

Once you have installed the QBDSM, it is time to configure it. You can follow the below steps to successfully configure the database server manager.

In case you only installed the database server manager, then follow the steps below:

• To start with, click on the windows start menu
• Type services in the search field and then choose services tab
• The next step is to select and open the QuickBooksDBXX.XX service. Note that here xx stands for the version number you use
• Now head to the general tab and look for the server status section
• Choose the stop option if it is running
• The next step is to click on automatic tab from the startup type
• Followed by heading to logon tab and selecting local system account option
• Head to the recovery tab and select restart the service option there from each of the dropdown menu
• Head back to the general tab and select start to reboot the database server manager

In case you installed QuickBooks desktop and database server manager

• At first, open the QuickBooks desktop on the server system
• Once done with that, the user needs to head to the file menu and also select open or restore company
• The next step is to select open company file
• And also view the open company file
• Hit the next tab
• Now, select the open file in multi user mode option
• And also, click on open tab
• The next step is to login the company file
• And move to the file menu
• Go for close company/ log of
• This will close the file on the server
• The user should then open the windows start menu
• And enter database in the search bar followed by opening the database server manager

How to fix QBDSM?

The below stated set of steps can help in repairing the QuickBooks database manager:

• The very first step is to head to the file menu options of QuickBooks.
• Later on, navigate to the utilities tab and also choose it to rebuild the data
• Followed by, navigate to the information window and choose ok tab
• Moreover, wait till the time the process ends.
• The last step is to click on ok tab when the process ends.

Read Also: How to access QuickBooks desktop remotely?

To wrap up!

We hope that this article has helped you to Install, Update and Set up of QuickBooks Database Server Manager. In any case, you have any query regarding Database Server Manager then seek assistance from QuickBooks enterprise technical support team.

Host Docket is a team of Intuit Certified ProAdvisors and available for 24/7 to help you. Our experienced technicians are available to provide you with any kind of guidance or solve any error faced by QuickBooks or database server manager. Dial our toll-free support number i.e. 1-844-405-0907

Frequently Asked Questions!

 

Read Also

How to Print Form 1099 and 1096 in QuickBooks Desktop?

How to Fix QuickBooks Error Code 80070057?

Steps to Fix QuickBooks Error 6000 304