QuickBooks is a famous accounting & bookkeeping solution for the world’s leading business houses and corporations. With this software, you can easily perform your day-to-day business operation on regular interval of time. Through this article, learn how to configure the QuickBooks Database Server Manager to permit multi-user access.
However, for expert guidance the user can make a call at our toll-free number +1-800-969-7370, and discuss the issue with our QuickBooks desktop support team.
Note: To fulfill the QuickBooks Desktop demands that are recommended to install this tool. This QBDSM tool should be installed on the computer in which the QuickBooks Desktop company files have been stored.
What is QuickBooks database server manager?
QuickBooks Database server manager is a very helpful tool in QuickBooks application. This tool enables you to organize applications for multiple users. Database server manager installation is important because without this, you cant use multiple version of QuickBooks Desktop. However, this tool enables you to make optimal usage QuickBooks Desktop software and helps users to create network data file (.ND) for any company file on the host computer.
In this article, we will let you know about the procedure to configure QuickBooks database server manager (QBDSM) in multi-user mode.
Facts related to QuickBooks database server manager
- QuickBooks Database Server Manager is accountable for generating Network Data documents (*.nd) for almost any provider files saved on the server computer. Install each version of the Database Server Manager, if you’re using a number of versions of QuickBooks Desktop.
- Installing multiple versions of Database Server Manager can provide you multiple variations of processes but not multiple versions of software.
- If you’re using multiple versions of QuickBooks Desktop, then it’s a must to set-up the Database Server Manager for every version in chronological order (from oldest to latest).
- Loading the Database Server Manager guarantee that the year’s database service is currently running in the background. In the Windows Services interface (accessible via the Windows Control Panel), these services are listed as QuickBooksDBXX, where XX represents the version number (ex. “28” is for QuickBooks Desktop 2018 and “27” for QuickBooks 2017).
- The QB Database Server Manager installed for every QuickBooks variant adds a user (ex. QBDataServiceUser28 for 2018 and QBDataServiceUser27 for 2017).
Learn how a user can install, update and setup the QuickBooks database server manager with the help of following infographic
How to Install QuickBooks Database Server Manager?
Step 1: First of all, You need to double-click the installer to the QuickBooks and then start the “Installation Setup Wizard”.
Step 2: After that Select the “Next” option, if the system is on the Internet and equipped to download an upgrade. Otherwise, select the “No” icon, then hit the “Next” tab.
Step 3: Shutdown the active application and hit onto the “Next” icon.
Step 4: Read the terms of the “Software License Agreement“. If you agree, select I accept the terms in the license agreement, then choose the “Next” tab.
Step 5: Choose the “Custom or Network Options” icon.
Step 6: Now choose a setup type:
- Select the ‘I’ll be utilizing QuickBooks on this computer AND I will be saving’… if you will run the QuickBooks program on this computer system.
- Select the ‘I will NOT be using QuickBooks on this computer’… if you’ll just store QuickBooks information on this computer.
Notice: If you choose I won’t be using QuickBooks with this computer… then, you do not need to enter a license number.
Step 7: Now choose the “Yes” icon, and then click allow access.
Step 8: Enter the ‘License Number and Product Number’ (the text at the bottom of the window lets you know where to look for this).
Step 9: Follow the on-screen instructions to complete the installation.
Step 10: Setup the Database Server Manager after it has been installed.
How to Update the QuickBooks Database Server Manager (QBDSM)?
It may be required to upgrade the Database Server Manager. It is necessary when a new year of QuickBooks Desktop is installed on the workstations OR if a critical update to a year is released.
Step 1: First of all download the patch from “Update QuickBooks Desktop to the release“.
Notice: The patch for the host is the same as the patch for the workstation.
Step 2: Now Reboot the host after the patch setup completes. (This is strongly recommended).
Step 3: On the workstation, once the server has been updated, you might get the following message: “The company file has to be updated to work with this version of QuickBooks Desktop“
Step 4: There’ll be a prompt to “Create a backup” which is required since these updates can modify the database structure.
Step 5: You should be able to open the company file when you follow the prompt messages after finished the backup.
How to Use and Set-up QuickBooks Database Server Manager (QBDSM)?
Step 1: First of all, open “QuickBooks database server manager” and then scan the files which you want to use use for the multi-user access.
Step 2: After that scan the “Company files” on the server to ensure that the files are configured properly to give them access to the multiple users.
- The user is required to visit the Start button, and then click on All Programs option and also on QuickBooks folder.
- The next step is to tap on Scan folders.
- And then, scan folders, and verify the folders that contain the QuickBooks company files. In case, the user is unaware of the file location, then he/she can select to Scan the entire disks.
- The next step is to click on the Scan button and begin the scanning process.
- Once all the folders are scanned, the other users will be able to open company files remotely.
Step 3: Now in order to “Add new company files” to the server, you can use “Monitored drivers feature” and keep the database server manager to date.
- Move to the start button, and then click on the Programs option.
- After that, click on QuickBooks and also on QuickBooks database server manager.
- If the user wants all the local drives to get monitored for the company file, especially the ones that are added, removed, or renamed, then the user is required to click on the select option.
Step 4: Ensure that the company files are connected to the server and users are logged into the company files.
Step 5: If you want to change the “Status of the service “then implement the “Service administrator tool” and configure the service.
Step 6: Now finally, you can use the “Updates features” and download the recent updates to the QuickBooks server.
- Visit the Start button, then click on the Program option.
- Followed by clicking on QuickBooks and also on QB database manager.
- Tap on updates.
- And then, install updates by following the instructions.
QuickBooks Desktop 2019 currently uses dynamic ports! These are specific port numbers (not an array) assigned during installation to ensure QuickBooks Desktop uses a given port entirely. You’ll get these numbers in QuickBooks Database Server Manager.
QuickBooks database server manager tool can:
- Scan the folders and QuickBooks company files which is necessary for multi-user access.
- This tool examine the local storage devices to detect a new company file automatically.
Winding up..!
I hope the steps given for Installing, updating & setting-up QuickBooks Database Server Manager will help you to understand everything about it.
In case, you face any problem associated with the QuickBooks Database Server Manager – you can freely contact the QuickBooks enterprise support experts at their toll-free helpline number .i.e. +1(800)969-7370.
Frequently Asked Questions
Question 1: When is QuickBooks database server manager required?
Ans: QuickBooks database server manager creates the Network data file for each of the company file that is stored on the workstation. Also, it is required when the user is using multiple versions of the QuickBooks software.
Question 2: What is the process to restart QuickBooks database server manager?
Ans: The steps involved in the process of rebooting the QuickBooks database server manager are as follows:
- The very first step is to tap on the Windows start button and choose Control Panel.
- After that, double-tap on Administrative tools.
- The next step is to double-tap Services option.
- And then, right-click the suitable data manager.
- To save changes, reboot the service.
Question 3: Where can I find QuickBooks database server manager?
Ans: To locate the QuickBooks database server manager, the user is required to visit the start button and then tap on All Programs. After that click on QuickBooks database server manager tab. Then, scan the folders and find out the folder with company file.
Question 4: What does the QuickBooks database server manager do?
Ans: QuickBooks database server manager lets the users to share company files with other systems. Not only this, but it also helps the users to monitor their multi-user network. If you want your company file to be accessed by other users as well, then you must have QuickBooks database server manager.
Question 5: How to download QuickBooks database server manager 2019?
Ans: If the user wishes to download QuickBooks database server manager, then the following steps can be followed:
- Firstly, open QuickBooks installer, followed by initiating the Installation Wizard.
- Then, connect to the internet, and tap on Next.
- Now, the user is required to go through the software agreement and agree to terms and conditions, followed by tapping on to Next.
- Hit Custom or Network options.
- And then, choose the installation method.
- Now, type in license number if needed.
- The next step is to tap on Yes, and allow access.
- Lastly, carry out the on-screen prompts.
Question 6: What is the system requirement of QuickBooks database server manager?
Ans: The system requirements for QuickBooks database server manager, includes the following:
- Operating system: Windows 10 64-bit and Natively installed, Windows 8.1 64-bit natively installed, Microsoft Windows 7 SP1, Windows Server 2016, Windows Server 2012 R2.
- Database server manager: Windows server 2016, Windows server 2012 R2 and windows server 2011. Windows 8.1 or windows 7 SP1, etc.
- Hardware and OS requirements: 2.4 GHz minimum, 4GB minimum, Sever RAM requirements.
- Optical Drive: 4X DVD-ROM drive required for CD installations.
- Software Compatibility: QuickBooks software is compatible and is easy to interact with hundreds of third-party applications.
You may also like: