What is QuickBooks Database Server Manager?
The QuickBooks Database Server Manager is a specific tool that allows you to use a combination of several different QB products in the multi-user mode. That means that it manages all the applications that your business requires for multiple users that need access to working on the bookkeeping.
This makes the installation of the DSM for each of the QB versions you are using mandatory because without this tool you will not be able to use several products of the QB software at the same time.
To enable the multi-user mode, the DBSM creates the so-called ‘Network Data File’ for all the company files, which are then stored on the host computer. The tool also automatically scans the local storage device for new company files.
Note: If you are using different versions of QB Desktop, it is advised to install the DBSM in the chronological order from the oldest to the latest for each version.
Each DBMS of each QB version is going to add a user individually. For example QBDataServiceUser27 for the year 2017 and QBDataServiceUser28 for the year 2018.
Who should use the database manager?
QuickBooks online and desktop are only two out of the several accounting solutions offered by Intuit.
QuickBooks online is a cloud based solution that easily function overs the internet through browsers like google chrome or internet explorer. while using the online versions of QB your data is getting backed up on servers with intuit and the online version can be accessed on any device with up to limitation of 5 users at the same time.
QuickBooks desktop is a software solution and comes in 3 different versions. Pro, premier and enterprise 2021. The QuickBooks database server manager is useful when you are using the desktop version of QB to store your company files on a server and share your files across a network with other users also known as QuickBooks multi-user mode setup.
How to correctly install the QuickBooks Database Server Manager?
- Search for the QuickBooks Installer on your host computer.
- Open the installation Wizard by double-clicking on the QB installer.
- Should the host computer be connected with the internet, you can go ahead and download the QBDSM update. Continue with clicking on the ‘Next’ button.
- In case your host computer has no connection with the internet, select ‘No’ and continue with ‘Next’.
- Select the option ‘end other programs’ that are running in the background. Continue with ‘Next’.
- The ‘Software License Agreement’ is going to come up. Read them carefully and accept the terms by clicking the ‘Accept’ button. Continue with ‘Next’.
- Choose the installation type that you need from the ‘Custom / Network Options’ menu. You have the option between „I will be using QuickBooks on this computer AND I’ will be stored “ if you want to use this QuickBooks program on the computer you are currently using OR „I will NOT be using QuickBooks on this computer“ if you should decide to ONLY STORE data on the computer.
- Select the option ‘Yes, allow access’ and enter the license and product number. Now follow the given instructions to complete the installation of the QuickBooks DSM.
- If the installation was successful, you can continue with the Set up of the DSM.
How to correctly set up the QuickBooks Database Server Manager?
- Open the QuickBooks Database Server Manager. Scan your folders or company data files that require the configuration to be accessible in the multi-user mode.
- If the scan is completed, save your files on the server. This step ensures that the configured files are going to be accessible for every user.
- Should you want to add new company data files to your server, you can use the ‘Monitored Drives’ feature, to keep the Database Server Manager always updated.
- To change the status of the service, use the ‘Service Administrative’ tool for organization
Now you are able to use the ‘Updates’ feature to download the latest updates to your QuickBooks Server.
How you can update your QuickBooks Database Server Manager ?
Updating your QuickBooks Database Server Manager regularly is an important task in order to ensure that all the processes are running smoothly and without any errors. So whenever an update for the current year is released from Intuit, or you want to install the latest version of the QuickBooks Desktop software on your devices. Follow the steps below to successfully run the update.
- Usually the Database Server Manager gets updated automatically, but only if you also update your QuickBooks Desktop to the latest version. So naturally this would be the first step.
- Make sure that the patch for the server and the workstation is the same.
- Follow the given steps for the software update and then reboot your server.
- Once the server on the computer has been updated, the message „Company file needs to be updated“ will appear on your screen.
- The software is going to ask you to make a back-up for the company files. This step is very important to avoid any data loss, since updates can change the structure of the database.
- Follow the upcoming prompts for the update and complete the backup. Now you should be able to open your company data files.
How to use the QuickBooks Database Server Manager ?
The Scan Folders feature
To enable other users access to the company data files, all the files on the server have to be scanned at least once. This will guarantee that they are configured correctly for multi-user mode access. Here is a step by step guide on how to scan your folders with the data files.
- Start your QuickBooks application and open the Database Server Manager.
- Choose ‘Scan Folders‘ from the horizontal menu and add the folder that needs to be scanned by clicking the button ‘Add Folder’. In case you do not know where to find the correct folder, you can also scan the entire disk. On the other hand, should you have chosen the wrong folder accidentally, you can always remove an already added folder. Just click on it and the hit the ‘Remove Folder’ button.
- Now hit the ‘Scan’ button and sit back while the Database Server Manager is doing its work.
- That’s it! Now all the other user will have access to the company files when you are in the multi-user mode.
The Database Server feature
This feature enables you to determine which company data files are connected with the server and also gives you a list of all the users that are working each file at the moment. Should you want to change the status of the services, you can always do so by using the QuickBooks Service Administrative Tool.
The Monitored Drives feature
This feature keeps your QuickBooks Database Server Manager always updated when new company data files are added to the server. All the local drives on your computer can be monitored for company data files that are added, renamed or removed. Displaying and monitoring the mapped drive is not possible though.
The Updates feature
To download recent updates for your QuickBooks Server, and also check on the different versions of the QuickBooks Server, use this feature and simply follow the given instructions.
The System feature
This feature provides you with all the information about the computer on which your Database Server is installed. It displays the Computer Name, I.P. Address, Processor, OS (Operating System) Version as well as the physical memory (total MB and free MB).
The QuickBooks Database Server Manager is a specific tool that allows you to use a combination of several different QuickBooks products in multi-user mode. That means that it manages all the applications that your business requires for multiple users that need access for working on the book keeping.
Using QuickBooks on multi-user mode requires the following file named QBDBMgrN running on your client PC, Incase you come across the following error QBDBMgrN not running on this computer issue follow this article.
If you were unable to setup the database manager than their maybe additional settings or components required to complete the installation and to access your company files in multi-user mode.
We recommend that you get in touch with our QuickBooks experts for further help.
Send your queries to email@example.com or simply speak to our customer service representative Call : +1 971 205 3827