Download And Update QuickBooks Database Server Manager

QuickBooks Database Server Management

Last Updated on February 12, 2021 by Editorial Team

Numerous QuickBooks clients think that it’s hard to introduce, update, and set up a QuickBooks database server manager. Consequently, remembering each one of those realities. In this article, we will talk about the QuickBooks database server manager how to download and install the to allow multi-client access. This article will brief you about introducing, refreshing, and setting up QuickBooks database server manager.

What Is QuickBooks Database Server Manager

QuickBooks Database Server Manager is an extremely accommodating device in the QuickBooks application offered by Intuit. This apparatus empowers the client to sort out applications for different clients. The database server director establishment is basic as without this. The client won’t have the option to utilize various renditions of the QuickBooks work area.

Besides, QuickBooks database server chief empowers the client to make the ideal use of QuickBooks work area programming. And furthermore causes the clients to arrange information records (.ND) for any organization document on the host PC. QuickBooks database server manager is obtaining by multi-client or you can say it is a multi-user network in any case. It is fundamental that the record is in a similar framework or spot where the apparatus is. It is conceivable that the instrument has been introduced in one PC while the document is in another PC.

QuickBooks Database server Manager

QuickBooks database server is an apparatus that allows the QB clients to appreciate the various forms of the QuickBooks process. This apparatus makes the system information documents to get the guarantee. That the client has the present year’s administration running as a foundation application. This, yet additionally this apparatus makes a system of information document (.ND) for any organization record on the host PC. 

QuickBooks Database server Manager system of information document

QuickBooks database server chief permits a client to synchronize organization records with other PCs. This capacity is helpful and amazing is the plane by Intuit. It likewise encourages you to screen your multi-client organization. QuickBooks Database Server Management supports multi-client access to where numerous clients can access on a similar organization records simultaneously. It additionally encourages clients to make a (.Nd) document for any organization record over your system.

How To Download Database Server Manager

Firstly you need to download the QBDBMS with the help of any of the two methods discussed below. It should be also known that the database server manager is also a part of the QuickBooks Desktop file.

  • Firstly, you have to download the QuickBooks tools hub and then you have to go to your downloads by squeezing CTRL+J. 
  • Then, you can see under your downloads list click on QuickBooksToolsHub.exe. 
  • In this step, you have to click on Yes to permit this application to make changes. 
  • Now you need to click on Next to introduce it and afterward click Yes again for tolerating the permit understanding. 
  • After that, you have to snap-on next and afterward installation of it might take some time. 
  • Now you have to click on the Finish button and you have to open QuickBooks.
  • At last, you have seen under the network issues tab and then click on QuickBooks database server management.

By this, your QuickBooks database server or QBDBMS will get downloaded.

Alternative Method

You can even download the QuickBooks database server manager directly from the Intuit official website.

How To Install QuickBooks Database Server Manager  

You need to install the QB database server manager on your computer. But if you are an accountant who used to host multiple versions of the QuickBooks Desktop, then you need to install them in order as the old version should be installed at first and then end up the installation with the new version. The database server is the computer that hosts your company files.

  • Firstly, you need to close all the programs which are opened on your computer, and then you have to close QuickBooks.
  • After that, you have to open the install file which you have downloaded and is also named Setup_QuickBooks.exe.
  • Now, you have to follow the onscreen instruction. But if you require to find your product or license number then you can follow the steps which are discussed below:
    • For QuickBooks Desktop (QuickBooks Pro, QuickBooks Premier, or QuickBooks Enterprise)
      • First, you need to open the QuickBooks Desktop.
      • Then you have to press the F2 key with the help of your keyboard.
      • After that you have to look for the product name, product number, license number which is present in the product information window.
      • In this step, you have to see for your release which is present at the end of the product name.
      • At last, you have to see your version in the version used on file. This will be the sorted list by date with the oldest version present at the top and also the most recent presentation at the bottom.
    • For QuickBooks Basic and Enhanced Payroll for QuickBooks Desktop
      • First, you need to open the QuickBooks Desktop.
      • After that, you have to go to the employee’s menu and then you have to click on the Payroll center.
      • At last, you have to click on the Payroll option and you can able to see your version in the subscription statuses window.
    • For QuickBooks Desktop for MAC
      • Firstly, you have to open the QuickBooks for Mac.
      • Then you have to go to the help menu.
      • And at last, you have to click on the product information.
  • After that, when the QuickBooks will be asking you to choose the install type, then you have to click on the custom or network options. And then click on next but you don’t have to click on express.
  • In this step, you need to choose the best option which will be good for your network setup, and then you have to click on next. Both options will be going to install the database server manager. But if QuickBooks Desktop is already installed on your computer, then this will not be overwriting any of your existing company data.
    • As if you want QuickBooks Desktop and the database server on your computer then you have to click on I will be using QuickBooks Desktop on this computer and I will be storing…
    • But if you only want a database server on your computer then you have to click on I will not be using QuickBooks Desktop.
  • At last, you need to follow the rest of the onscreen instructions, And when you will be ready then you have to click on the install option and then a window will be asking you for permission for installing.

When you introduce the apparatus, remember to give all the clients consent to get to the organization envelopes. As a matter of course, the QuickBooks database server chief makes a special client for every establishment.

Steps to Configure Database Server Manager

If you want to configure the database server manager then:

  • Firstly, you have to open the window start menu.
  • After that, you have to type services into the search bar and then you have to open the services.
  • Now you have to click and then open QuickBooksDBXX. Here XX denotes the version number.
  • In this step, you have to go to the general tab and then you have to find the service status. If this service is started or running then you have to click on stop.
  • After that, you have to go to the startup type drop-down menu and then from there, you have to click on automatic.
  • After this, you have to go to the login option where you need to click on the local system account option.
  • Now, you have to go to the recovery option where you need to click on restart the service from the drop-down menu: First failure, Second failure, and the subsequent failure.
  • At last, you have to go back to the general section, and then from there, you have to click on start for restarting the database server manager.

How to Set your Firewall and Antivirus Permissions

You have to check that you have provided the firewall and antivirus permission to the database server manager to run on your server computer. You can check or create as:

  • First, you have to open the window start option.
  • Then you need to enter the window firewall into the search bar and then you have to open the windows firewall.
  • After that, you have to click on the advanced settings.
  • In this step, you have to right-click on the inbound rules and then click on the new rule.
  • Now you have to click on the port and then you have to click on the next option.
  • After that, you have to make sure TCP is selected or not. If not then select it.
  • Then you have to go to the specific local ports field where you need to enter the specific ports which are required for your QuickBooks year version:
    • 2020 QuickBooks Desktop: 8019, XXXXX.
    • 2019 QuickBooks Desktop: 8019, XXXXX.
    • 2018 QuickBooks Desktop: 8019, 56728, 55378-55382.
    • 2017 QuickBooks Desktop: 8019, 56727, 55373-55377.
  • In this step, when you have entered the port number you have to click on next.
  • After that you have to click on allow the connection option and then click on next.
  • Now you will get a prompt where you have to verify that all the profiles are marked and then click on next.
  • Here, you have to create a rule and then give it a name as QBPorts(year).
  • At last, when you will be providing it a name you have to click on finish option.

How To Update Database Server Manager

QuickBooks database server manager can be updated by two methods update automatically and update manually.

Update QBDBMS Automatically

For updating the QuickBooks database server manager automatically you have to:

  • First, you have to go to the help menu and then you have to select the update QuickBooks Desktop option.
  • Then you have to go to the update now option. But yes one thing you should know that you can click on the reset update checkbox for clearing all the previous update downloads.
  • After that, you have to click on the get updates for starting the downloads.
  • In this step, when the download will get the finish you have to click on the restart QuickBooks option.
  • At last, you will be getting a message which you have to accept for installing the new release.
Steps to schedule the Future Automatic Updates

If suppose you don’t require to update your database server manager now then you can plan for scheduling it to download later as:

  • First, you have to go to the help menu and then you have to click on the update QuickBooks Desktop option.
  • Now you have to go to the options menu.
  • After that, you have to click on yes for turning on automatic updates. But if you want to share automatic downloads with other computers on your network then you have to click on yes for each computer.
  • At last, you have to click on the close option.

By this your all the updates will be downloaded automatically whenever they will be available.

Update QuickBooks Database Manager Manually

For updating the QuickBooks database server manager manually you have to follow the steps which are discussed below:

  • First, you have to close your company files and QuickBooks.
  • Then you have to open the windows start menu.
  • Now, you have to search for the QuickBooks Desktop and then right-click the icon, and then click on the Run as administrator option.
  • After that, you can see the No Company Open window, and then you have to go to the help menu and click on the update QuickBooks Desktop option.
  • In this step, you have to go to the options menu and then you have to click on the mark all, and finally, you have to click on the save option.
  • Now, you have to go to the update now option and then you have to click on the reset update checkbox.
  • At last, when you are done will the above process, you have to click on the get updates. And when the updates will get the finish and you will be reopening the QuickBooks Desktop then you have to click on the yes option for installing.

How to Use Database Server Manager

You can use the database server manager for the following methods:

Steps to Open the QuickBooks Database Manager

Here are steps mentioned for opening your QuickBooks database manager:

  • Firstly, you have to click on the Start menu.
  • After that, you have to go to the Programs.
  • Now you have to click on the QuickBooks.
  • At last, you have to click on the “QuickBooks Database Server Manager”.

Steps to Scan your Folders

You should scan the file before you are sharing the file to others, so that you can know that which folders is hold by the file:

  • First, you have to open the windows start menu.
  • Then you have to type the database into the search bar and then you have to go to the QuickBooks database manager.
  • After that, you have to go to the Scan Folders option. But you have to keep in mind one thing that this database server manager 2019 will be sharing all the folders. If you want to send only a few folders then you have to set your folder permission.
  • In this step, you have to click on the browser and then you have to click on the folders that are holding your company files.
  • Then you have to click on ok.
  • At last, you have to click on the start scan option.

How can you Monitor your Drives

After scanning your folders you will be shown those files which are going to hold then. You need to select that drive to monitor the folder and you don’t require to rescan the folders.

  • Firstly, you have to go to the monitored drives option.
  • After that, you need to click on the checkboxes for the hard drives that will be holding your company files. You only have to add files that are holding your company files.

How can you Manage the Database Manager

For running everything smoothly there are many other tabs in the database server manager.

  • In this, the system option will tell you where the database server manager is installed on your computer.
  • The database server option will be giving you the real-time status of the tool and who is connected to it.

Why Restart DBMS

When you try to open DBMS and you are facing an error at that time QuickBooks will be recommending you restart it on your computer. For restarting it you need to follow your current setup.

If you are having QuickBooks Desktop and Database Server Manager
  • Firstly, you need to open the QuickBooks Desktop on your computer.
  • Then you have to go to the File menu and then you need to click on the open or restore company.
  • After that, you have to click on the open a company file and then you need to find and open your company file and click on the next option.
  • Now you need to click on the open file in the multi-user mode checkbox and then you have to click on open.
  • In this step, you have to login into your computer file.
  • Now you have to go to the File menu and then you have to click on the close company or log off and this will be closing your company file on the server.
  • Then you need to open the windows start menu.
  • At last, you have to type database in the search bar and then you have to open QuickBooks database Server Manager.
If you are having Database Server Manager
  • Firstly, you need to click on the windows start menu.
  • Then you have to search for the control panel and then you have to open it.
  • After that, you have to click on the administrative tool and then you have to open it.
  • Now you have to click on the services from the list.
  • At last, you need to right-click on the QuickBooksDBXX service and then you have to click on restart. Here XX denotes the database server manager.

How can you use the features of QuickBooks Database Manager

For using the features of the QuickBooks database server manager you have to:

  • Firstly, you have to decide how many company files are attached.
  • Then you have to keep track of how many clients are signed in.
  • And then while the service is running, users can even keep track of its status.

How to Use the System Feature

Steps are mentioned below which tell you the use of system features:

  • Firstly, you have to go to the start menu.
  • Then you need to select Programs.
  • After that, you need to choose the QuickBooks, and then click on the QuickBooks database server manager.
  • In this step, you have to click on the System.
  • At last, you can now review your system information. You can see the location of the database server.

Conclusion

QuickBooks Database Server Manager is an extremely viable instrument for multi-client record access on QuickBooks. We trust you are currently all around educated on the most proficient method to utilize. The database server manager for arranging up your own multi-client organization records.

You can QuickBooks work area database server administrator on your PC. So in the event that you need any help with the QuickBooks work area, kindly talks with our specialists.

Didn't find your solution?

Don't get stressed out? We are here for help. Find a QuickBooks ProAdvisor or CPAs who can help you get rid of your problem. Dial our toll-free number.

Call us: +1-888-461-1545

unable-to-resolve-problem.jpg

Leave a Reply

Your email address will not be published. Required fields are marked *