How to Install QuickBooks Database Server Manager Like a Pro

If you’re looking for detailed instructions to install QuickBooks Database Server Manager on your system, consider this step-wise guide. This post covers complete details regarding the installation procedure and guides you on how to update after installation. So stay tuned to find all the sections within the article.

Intuit has released different tools for better user experience, and QuickBooks Database Server Manager tops the list. When you connect to QuickBooks DB Manager, multi-user access can be enabled. Additionally, by utilizing QB Database Server Manager, multiple users can work on a common company file in a multi-user environment in a network. The only thing is that the tool is to be installed for each QuickBooks Desktop version. In this detailed blog, we cover the widely asked question of how to install QuickBooks Database Server Manager on your system. Eventually, you will figure out the ways to use it to let multiple workstations access the company file at the same time.

Are you facing challenges in installing the QuickBooks Database Server Manager on your system? Consider getting in touch with the QuickBooks specialists at 1.855.738.2784. One of our tech experts will help you set up and run QuickBooks Manager and solve any errors related to it

Getting Started with QuickBooks Database Server Manager Download Procedure

You will not come across any special provision to download QuickBooks Database Server Manager. QB Database Server Manager is part of the QuickBooks Desktop. Hence, when you download the QuickBooks desktop, QuickBooks Database Manager is downloaded with it. Here are the quick steps to install QuickBooks Desktop and database server manager on the server computer

Step 1: Install Database Server Manager on the Server Computer with QuickBooks Desktop

1. Download QuickBooks Desktop from the QuickBooks Product Download Page.
2. Save the file to an easily accessible location.
3. Close all the running programs on the server computer, and that includes QuickBooks as well.
4. Search for QuickBooks.exe and follow the installation instructions as they appear on the screen.
5. On being asked about the install type, choose Custom or Network Options.
6. Press Next without selecting Express.
7. Choose the option best for network setup and then click Next.

For the users who will make use of DB Manager as well as QB Desktop on the server computer, choose:  I’ll be using QuickBooks Desktop on this computer, AND I’ll be storing… 

In the second scenario, where only the Database Server Manager will be put to use on the server computer, choose: I will NOT be using QuickBooks Desktop…

1. Once done with the instructions, hit Install to get QuickBooks on a server.
2. After that, Activate and Update QuickBooks Desktop.

Note: If you host multiple versions of QuickBooks desktop on your network, install them in order from the oldest first to the most recent at the end.

Step 2: Proceed by Configuring the Database Server Manager

This step is optional if you want to keep the default settings of the QuickBooks Database Server Manager.

1. Search ‘Services’ in the Windows Start menu and select the same from the search results.
2. locate and open the ‘QuickBooksDBXX’ service in the list of services where XX represents the version of QuickBooks Desktop.
3. Under the General tab, look if the service status is Started or Running. If so, select Stop, and from the Startup Type drop-down, select Automatic.
4. Move to the Logon tab and choose the Local System Account option.
5. Now, from the Recovery tab, select the option to Restart the Service for First Failure, Second Failure, and Subsequent Failures.
6. Now select Start from the General tab to restart the Database Server Manager.

Step 3: Provide QuickBooks Database Manager Permission to Run on the Server Computer

If you have to install QuickBooks on multiple computers, ensure you get the necessary permissions. Configure the Firewall manually so as to let QuickBooks Database Manager run on your server computer.

1. Click on the Start menu and search for Windows Firewall. Click on it to open it.
2. From the Advanced Settings, right-click on Inbound Rules and select New Rule.
3. Choose Port and hit Next.
4. Ensure that TCP must be selected. After this, enter the specific ports in specific Local Ports. The port format is as per the QuickBooks version you are using.
   • QuickBooks Desktop 2020: 8019, XXXXX.
   • QB Desktop 2019: 8019, XXXXX.
   • QuickBooks Desktop 2018: 8019, 56728, 55378-55382.
   • QuickBooks Desktop 2017: 8019, 56727, 55373-55377.
5. Once you have entered the port number, click Next and Allow the Connection.
6. Hit Next, and when asked, mark all the profiles. Click Next once again.
7. Finally, create a rule. Give it a name like “QBPorts (year).”
8. When you’re done, select Finish.

*The same steps are to be repeated to create Outbound Rules. In step 3, choose Outbound Rules and move forward as above.*

Step 4: Create an Exception for the QuickBooks Database Server Manager

After you download QuickBooks database server manager, create exceptions in the firewall for uninterrupted running of the application:

1. From the Start menu, search for Windows Firewall and click on it.
2. Select Advanced Settings and right-click on Inbound Rules (Follow the same for Outbound Rules later). Click on New Rule.
3. Select the Program and then Next to Choose This Program Path.
4. Using Browse, select the following files

• DBManager.exe-C:\Program Files\Intuit\QuickBooks YEAR
• QBDBMgrN.exe-C:\Program Files\Intuit\QuickBooks YEAR

5. Hit on Next and select Allow the Connection.
6. When prompted, see that all files are marked and select Next.
7. Finally, create a rule with a name like QBExceptFirewall with a .exe
8. Lastly, to Provide QB Database Manager permission to run on the server computer, repeat the steps for Outbound Rules. Hopefully, you have learned how to connect QuickBooks to the server.

Step 5: Check for QuickBooks Database Server Manager Update

QBDB Server Manager Update is not to be done separately. Whenever you update your QuickBooks Desktop, it automatically installs the latest updates. To manually update it, you can follow the method given below:

1. Launch QuickBooks Desktop and move to the Help tab, where you will find the Update QuickBooks Desktop option.
2. Select it, and move to the Update Now tab.
3. Select Get Updates and restart QuickBooks Desktop to prompt it to install the updates.
4. Click Install Now, and this is how QuickBooks Database Server Manager is updated.

Step 6: Putting DB Server Manager for QuickBooks Desktop to use

Now, let’s dive into how to use QuickBooks Database Server Manager. Given below are the steps to host the company file over a network using QBDBMgrN for QuickBooks Desktop.

Scan the Folder

1. This step is to be done only once before you share your company files.
2. From the server computer, open QB Database Server Manager.
3. Navigate to the Scan Folders tab and click on Browse.
4. Choose the folders that hold your company files (QBW).
5. Click on OK after selecting the folder and select Start Scan.

*On completion of the scan, the folders become available in the “QuickBooks company files found” section. They then become accessible on other computers on the network.*

Monitor your Drives

The scanned folders are held in the drives that appear under the Monitored Drives tab. Monitoring your drives will ensure that a re-scan won’t be needed if you move or change your company files in them.

1. Choose the Monitored Drives. From there, checkmark the boxes next to the Hard Drive that holds your company files.
2. At last, close it, and if you ever change or move the company file on the drives, re-scanning won’t be required.

Manage the Database Server Manager

Check the other tabs in the Database Server Manager that keep everything running smoothly.

1. Locate the Systems tab that helps you know where the database server manager is installed on the computer.
2. The Server tab of the database manager tells the real-time status of the tool and who is connected to it.

Solutions for error related to QB DB Server Manager

If any error crops up while you are using the database manager, consider the following points:

Restart the QuickBooks Database Server Manager

Sometimes, just restarting the program can help you get rid of any glitch that might crop up. Ensure to restart it on your server computer that hosts the company file. Follow the steps in your current setup to restart.

Condition 1: When both QB Desktop and Database Server Manager are installed on the server computer:

1. Open QB Desktop on the host computer, and from the File menu, select Open or Restore Company.
2. Click on Open Company file and open your company file.
3. Hit on Next and check-mark Open file in multi-user mode option.
4. Select Open and log in to your company file.
5. With the use of Close Company/Log off, close the company file on the server.
6. After this, you need to type Database in the Windows Start menu and run QBDB Server Manager.

Condition 2: If only the Database Server Manager is installed

1. Search and open the Control Panel from Windows Start
2. Click on Administrative Tools to choose Services from the list.
3. Right-click the QuickBooksDBXX service and then select Restart.

With complete detail into QuickBooks Database Server Manager, we hope you can successfully install and use it. If you feel like contacting the QuickBooks Experts to solve your query related to Intuit Network Manager, talk to our experts at 1.855.738.2784 and get an instant fix.

FAQs

Here, take a quick look at FAQs on QuickBooks Server Manager to get the answers to some of the most common questions:

Edward Martin

Edward Martin is a Technical Content Writer for our leading Accounting firm. He has over 10 years of experience in QuickBooks and Xero. He has also worked with Sage, FreshBooks, and many other software platforms. Edward’s passion for clarity, accuracy, and innovation is evident in his writing. He is well versed in how to simplify complex technical concepts and turn them into easy-to-understand content for our readers.

Summary

Article Name

How to Install QuickBooks Database Server Manager Like a Pro

Description

Here is your perfect guide on how to install QuickBooks Database Server Manager, along with the instructions to set it up and use it to host the company file

Author

Accounting Helpline

Publisher Name

Accounting Helpline

Publisher Logo