Skip to content

QuickBooks Database Server Manager

QuickBooks Database Server Manager

In case you are trying to use your company file in a multi-user mode, it is important to have QBDSM (QuickBooks Database Server Manager working on your system. This particular tool is the main element of QuickBooks software and it has garnered huge attention in the accounting sector especially. QBDSM is important for the proper operation of several QuickBooks Desktop versions across a given network.

To set up a multi-user network in QuickBooks, you need to install and set up the QuickBooks database manager, which shares the company file over a network with multiple workstations. Apart from sharing the company file, the database manager manages and monitors the company file as well. After setting up the network, you need to keep the QuickBooks database server manager running to access the company file from multiple workstations. Also, it will help with QuickBooks Setup For Workstation users.

Note:: Only users who want to set up a multi-user network for QuickBooks desktop need to set up QuickBooks database server manager. If you don’t plan on using a multi-network setup for your accounting software, then you don’t need to install this database server manager on your system.

Do you know about the QuickBooks Server Utility Manager ? and how this tool helpful for multi-user setup checks out complete details by the team of AccountsPro.

What is the QuickBooks Database Server Manager?

Contents

QuickBooks Database Server Manager is the only proper way to access several versions of QuickBooks Desktop over a particular network. It creates the network data file (.ND) for the particular company file in the host system to share the specific file with several users. It is also termed the personal database management tool of Intuit.

What are the important points to remember about QuickBooks Database Server Manager?

Here is the list of the key points one needs to understand about the QuickBooks Database Server Manager:

  • It enables the use of several QuickBooks Desktop versions. However, it is not about different software versions, instead, it offers variations in the processes
  • Installing QBDSM includes a user to QuickBooks Desktop on your system
  • For several QuickBooks Desktop versions, you need to install QBDSM in consecutive order, from old to new
  • This tool makes Network Data Files (.ND) for all the company files on the workstation of the host
  • Installing the QuickBooks Desktop Server Manager on every QuickBooks Desktop version of your system is important
  • Having the current version of QBDBSM is important

What are the uses of the Database Server Manager Tool?

Before setting up QuickBooks Database Server Manager, you must understand the uses of QuickBooks Server Manager Tool:

  • For using several users, it is important to scan the particular company file and QuickBooks Database Server Manager assists in the automatic scanning of the company file
  • It is accessed by monitoring the local hard drive of your business
  • It assists in identifying the new company file by reviewing the local storage device
  • QuickBooks Database Server Manager also assists in developing the.ND files on the host server automatically

How can you Download and Install the QuickBooks Database Server Manager?

The installation files for the database server manager are included in the setup for QuickBooks Desktop. Once you’ve downloaded the setup for QuickBooks Desktop accounting software, You need to comply with the procedure to download the QuickBooks Database Server Manager and install it. on your system:

1st step: Database Server Manager Update Download

The QuickBooks Database Server Manager is a segment of the QuickBooks Desktop file. In case you have the QuickBooks Desktop, then you are not required to download the QBDBMS as a separate file. However, if you do not have the QuickBooks Desktop, then download the QuickBooks Desktop. However, make sure you do not forget the Database Server Manager update version is required for your computer.

2nd step: Install the personal Database Manager tool of Intuit

You must install the tool in the system of your server, where you host your company files. Here are the steps given below to install the tool in the right manner.

Note: In case you are a user, with hosting capability for several QuickBooks Desktop versions on a given network, then you must install them in consecutive order, right from old to new.

  • Step 1: First, shut down all the programs that are running, on your particular server system
  • Step 2: Now open the file downloaded, Setup_QuickBooks.exe to install the tool
  • Step 3: Post that, QuickBooks will ask you to implement some of the steps present on-screen. You need to implement them one by one.
  • Step 4: Make sure that your product number and license number are right with you
  • Step 5: QuickBooks will display two kinds of installation- Network or Custom options, and Express options
  • Step 6: As your installation type, choose the Network or Custom options. Then click the Next option
  • Step 7: Post that, choose any of the options for the network setup:
    • If you need QuickBooks Desktop along with Database Server Manager on your server system, then press on the option, I’ll be using QuickBooks Desktop on this system, and I will be storing. This option is highly recommended
    • If you require only Database Server Manager on your server system, press on the option, I will not be using QuickBooks Desktop
  • Step 8: Comply with the remaining onscreen guidelines. When you are all set, press on Install. Windows may seek your permission
  • Step 9: Enable these users to use the folders which have your company files. When the system-level permissions are set, you will be able to view the users

Note: QuickBooks issues a new Windows user for every Database Server Manager Version.

3rd step: Set up permission of the firewall

It is the most crucial step needed to set up the permission for the firewall to run the particular database server manager seamlessly. It will make communication clear between the server system and QBDMS.

Hence, make sure the permission can be used for the server manager, and in case it is not yet, then you must set the port for the firewall.

4th step: Update the Database Server Manager

This step is not required during the time of installation, however, it may be needed later on. However, whenever you want to update the database server manager, it can be done easily by updating the QuickBooks Desktop.

It has no specific process to update, it gets updated automatically when the QuickBooks Desktop version is updated.

How to set up the QuickBooks Database Server Manager?

Here are the important points to take care to set up the QuickBooks Database Server Manager:

  • To set up QBDSM, you must open the QuickBooks Database Server Manager first. It will assist you to scan the files which are configured to aid multi-users
  • You can include the new QuickBooks company file on the particular server. For this purpose, you need to press on the button, Add New
  • Access the Administrative tool to update the Database Server Manager
  • Ensure that the company files are linked to the server
  • Make sure that every user has signed in to the company files
  • Access the service administrative tool to alter the status of the user service
  • You need to include the function of uploading and upgrading in the QuickBooks Server

Note:: If you want to have access to multiple versions of QuickBooks on your server, then install the oldest versions first and move to the newer versions. This is very useful for professional accountants who need to manage company files for multiple clients.

How to configure the QuickBooks Database Server Manager?

Once the installation is complete, the configuration steps comprise:

  • If QBDSM and QuickBooks Desktop are installed on your system, open the QuickBooks Desktop on your server, access the multi-user mode to open the company file, and then sign out and access the database server manager
  • In case only QBDSM is installed, access the Windows start menu to use Services and configure the QuickBooksDBXX service

When everything is correctly set up, your system must be ready to configure without any problem:

  • Step 1: Press the Windows Start button
  • Step 2: Enter Services in the given search bar
  • Step 3: Now open the Services option and then launch the QuickBooksDBXX. XX is the version number
  • Step 4: Post that, locate the Services Status section in the General tab
  • Step 5: In case the service status is running, then stop it
  • Step 6: Navigate to the Startup Type to choose the Automatic option
  • Step 7: Choose the option, Local System Account from the tab for Login
  • Step 8: Now, go to the Recovery tab
  • Step 9: Now you must choose the option, Restart the Service from the menus stated below:
    • First failure
    • Second failure
    • Subsequent failures
  • Step 10: Now go to the General tab and press the option for Start to restart the database server manager

Now you’ve successfully configured and restarted the QuickBooks Database server manager. But the task isn’t finished yet. To use the database manager to sync data between the server and multiple workstations, you need to properly set up Windows Firewall.

Firewall Settings To Allow QBDSM

To set up a Windows firewall, follow the steps provided below:

  • Go to the Start
  • Type in Windows Firewall and hit Enter.
  • Click on Advanced Settings.
  • Click on Inbound Rules and then New from the right panel.
  • Select the Port through which you want to enable connections and hit Next.
  • Select TCP and enter the required ports which are required by QuickBooks for setting up a proper multi-network connection.
  • Click on Allow Connection and hit Next.
  • Enter a name and description for the Rule and click on Finish.
  • Repeat the steps to create outbound rules.

Now you can begin using QuickBooks Database Server Manager.

How To Use or Access QuickBooks Database Server Manager?

Once QuickBooks Database Manager Server is installed properly, you must scan the company files to use them on other systems over a network.

1st step: Open the Server Manager

  • Step 1: Navigate to the Start button
  • Step 2: Press on the options for Programs
  • Step 3: Now choose QuickBooks
  • Step 4: Now select QuickBooks Database Server Manager Option

2nd step: Scan the Folders

When you save all company files on the server, ensure that they are scanned to make sure that they are configured to enable other users to use the company files with ease.

  • Step 1: On the server system, open the QuickBooks Database Server Manager
  • Step 2: Press the tab for Scan Folders
  • Step 3: Now press the tab, Browse to choose the folder that holds the company files
  • Step 4: Post that, press the OK option
  • Step 5: Choose the Start Scan option to begin the scanning process
  • Step 6: Once the scanning process is complete, you can use the company files in the folder of QuickBooks Company files found
  • Step 7: If you fail to locate the file that you wish to scan, then you need to scan the complete disk.

Note: The 2019 QBDBMS version shares all the folders. Hence, you can set folder permission to provide access to certain files via the database server manager.

3rd step: Track the Drives

The monitor drives tab has all the scanned folders. Hence, you can track all the folders from the drive. In this manner, there will be no need to rescan the folders anymore, in case you make certain modifications to the company files.

  • Step 1: Navigate to the tab, Monitored Drives
  • Step 2: Put a checkmark on the box, where the company files are saved
  • Step 3: Ensure to include only drives which have the company files

Note: It is important to note that is not possible to monitor or display the mapped drive.

4th step: Handle the Database Server Tool

Other than the tabs stated above, some other options assist you in getting a smooth run for everything.

For instance:

  • Database Server Tab – It displays the real-time status of the tool. This tool will help you comprehend who is linked to the tool.
  • System Tab – It assists you to find the location of the data server manager tool installed on your system.

5th step: To include a Folder

  • Step 1: Press the button, Add Folders
  • Step 2: Choose the wish to add
  • Step 3: The location of this folder is below the folders that have the QuickBooks company file

6th step: To delete a folder

This is an option step. If you wish to remove any folder, it can easily be done by clicking the Remove the folder option on a particular folder.

7th step: Start the QuickBooks Database Server Manager again

Once the setting tab is set up, start the database server again. You need to implement the process to start it again:

  • Step 1: On the server, launch the QuickBooks Desktop
  • Step 2: Press on the option, Open a Restore Company from the provided File menu
  • Step 3: Choose the option, Open a Company File to open a file
  • Step 4: Press the Next tab
  • Step 5: Add a tick mark to the box, Open the file in the multi-user mode. Now open it
  • Step 6: Post that, sign in to the company file with the help of the ID and password
  • Step 7: From the File menu, choose the option, Close Company/Log off. It will close the particular file on the server
  • Step 8: Finally, navigate to the Start button. Enter Database and open the QuickBooks Database Server Manager

In case QuickBooks Desktop is installed:

  • Step 1: Open the Control Panel. Now choose the Administrative section
  • Step 2: Select the Services option available in the list and press right-click on the QuickBooksDBXX service.
  • Step 3: Finally, press on the option to Restart

8th step: How to fix QuickBooks Database Server Manager

To fix the QuickBooks Database Server Manager, you must implement the steps given below:

  • Step 1: Open QuickBooks. Now navigate to the file menu option
  • Step 2: Now, navigate to the Utilities for Rebuild the Data
  • Step 3: Navigate to the information screen and then choose the OK button
  • Step 4: Hold for some time till the repair is fixed
  • Step 5: Once the repair process is complete, you need to press OK

You can restrict the server manager from scanning all of the folders on your server. To do so, you’ll have to set up folder permission. This is especially important if you’re using Database Server Manager 2019.

AccountsPro suggests using QuickBooks Hosting Services , so user can get automatic update and upgrade of QuickBooks Database Manager without any issues and errors.

After the scan is finished, you’ll find the folders listed in the QuickBooks company files found section. These company files can now be accessed over the network from any connected workstation.

How to uninstall the QuickBooks Database Server Manager?

If you do not wish to run QuickBooks in multi-user mode and wish to uninstall the personal database server manager of Intuit, then you need to implement the steps given below:

  • Step 1: Navigate to the Programs and Features option in the Control Panel
  • Step 2: Now search for the option, QuickBooks Database Server Manager
  • Step 3: Press on the option, Uninstall/Change on the top of the screen. Now you need to execute with the instructions provided on-screen to Uninstall/Remove the program

QuickBooks Database Server Manager Failed to Start

If the database server manager fails to start or you see an error, then you need to follow one of the methods provided below to get it started.

If QuickBooks Desktop and Database Server Manager are installed on the Server

  • Launch QuickBooks Desktop on the server
  • From the File menu, select Open or Restore Company.
  • Click on Open a Company File.
  • Find the Company File and click on Next.
  • Click on Open file in multi-user mode and hit Open.
  • Log into the Company File.
  • From the File menu, click on Close Company/Log off.
  • Open the start menu and type in ‘Database’. Click on QuickBooks Database Server Manager.

This will restart the program on your system and resolve the error.

If only QuickBooks Database Server Manager is installed on the Server

  • Open the Control Panel through the start menu.
  • Click on Administrative Tools.
  • Select Services.
  • Right-click on QuickBooksDBXX, where XX is the version of the database server manager installed on your system.
  • Select Restart.

This will restart the database server manager and resolve the QuickBooks Error.

Error Troubleshooting QuickBooks Database Server Manager

If you are getting errors and issues like to mentioned below related to QBDSM then connect to QuickBooks Support Number to get help.

IssuesError
QuickBooks Database Manager Not RunningQuickBooks Database Server Manager Error 1069
QuickBooks Database Manager Conflicting With DNS ServerQuickBooks Database Server Manager Failed to Resolve Errors And Retry
QuickBooks Database Manager Service Failed To StartQuickBooks Database Server Manager Folder With This Name Is Already Shared
QuickBooks Database Manager Network Diagnostics FailedQuickBooks Database Server Manager Hosting Mode Is Off
QuickBooks Database Manager Not Running On This ComputerQuickBooks Database Server Manager Has Stopped Working
QuickBooks Database Manager No Files Are ConnectedQuickBooks Database Server Manager Wrong Ip Address
QuickBooks Database Server Manager Not AvailableQuickBooks Database Server Manager Keeps Crashing
QuickBooks Database Server Manager No Files Are ConnectedQuickBooks Database Server Manager Keeps Stopping
QuickBooks Database Server Manager Connection Sharing Not AllowedQuickBooks Database Server Manager Qbdbmgrn Not Running On This Computer
QuickBooks Database Server Manager CrashesQuickBooks Database Server Manager Qbcfmonitorservice Not Running
QuickBooks Database Server Manager Checking For File And Folder PermissionsQuickBooks Database Server Manager Running No Files Are Connected
QuickBooks Database Server Manager Disabled Exceptions Not DefinedQuickBooks Database Manager Started And Then Stopped
QuickBooks Database Server Manager Does Not StartQuickBooks Database Server Manager Unable To Retrieve Connected Files
QuickBooks Database Server Manager Disconnect User 

How do you need the database server manager of Linux?

If you wish to install the QuickBooks Desktop Enterprise or the Linux Database Server Manager, you must know the Linux operating system, comprehend network operations, and have administrator access to install the particular software and configure it.

Components

The Linux database server manager comprises three elements:

  • The qbmonitord daemon
  • The Database server files
  • The qbmonitord configuration file (qbmonitord.conf)

What are the system requirements for Linux?

Hardware and SoftwareMinimumRecommended
RAM1 GBAs much as possible
Processor1.2 GHz Intel Pentium 32 GHz Intel Pentium 4
Disk Space2.5 GBAdditional space for the QuickBooks company files

How to access the updated features?

Here are the steps to access the updated features:

  • Step 1: Press the Start button. Now click Program and then QuickBooks. Next, click QuickBooks Database Manager
  • Step 2: No, choose Updates
  • Step 3: Lastly, follow the screen directions to install the updates

Final Words

It is all about the QuickBooks database server manager. We hope that by now you will be able to download the QuickBooks Database Server Manager with ease and then update it.

Still, if you get stuck anywhere and need professional assistance, call us. Our team of QuickBooks experts will not only clear your doubts but will also resolve your issues with ease.

Frequently Asked Questions (FAQ’s)

How do I resolve network errors that I receive when using the database server manager?

If you’re getting network errors, you didn’t configure the Windows firewall properly. We’ve mentioned the steps to create inbound and outbound rules to configure the firewall properly. These rules create exceptions and enable QuickBooks to connect through certain previously blocked ports.

I cannot find the setup for QuickBooks Database Server Manager. How do I get the setup?

The setup for the database server manager is included in the setup for QuickBooks Desktop accounting software. When you install QuickBooks, instead of Express Install, select Custom or Network Options to install the database server manager on your system.

How much time would it take to scan the folders on the server for the company file?

The process is almost instantaneous if you select the folder which contains all the company files. Don’t simply select a whole drive to be scanned as that would take a lot of time.

Where can the QuickBooks Database Server Manager be located?

To open the QuickBooks Database Server Manager, implement the steps below:
✅ Press the Windows Start button, and enter QuickBooks Database
✅ You can locate the QuickBooks Database Server Manager file. Press it to open

How to set up QuickBooks Server?

To set up the QuickBooks server, you must modify settings in QuickBooks, your server, and Windows, with the help of the steps given below:
✅ Set up QuickBooks. Set Folder permission
✅ Now install Database Server Manager
✅ Set Admin rights
✅ Now use Database Server Manager
✅ Switch on Hosting

Do QuickBooks use a Database?

QuickBooks makes use of a robust SQL database that is industry standard. Sharing the corporate file with a nearby or distant server over a network is beneficial. The multi-user option of the SQL database employs client-server technology to control access to company files.

Speak to A Specialist about QuickBooks Software

Headache🥺. Huh, Save time & money with QuickBooks Support 24×7 @ +1-800-983-3087, we provide assistance to those who face problems while using QuickBooks (Support all U.S. & Canada Editions)

 Support – We provide solutions for the following QuickBooks (Pro, Premier, Accountant, Enterprise, Payroll, Cloud) 

  • Error Support
  • Data Import
  • Data Conversion
  • Payment Solutions
  • Upgradation
  • Payroll Support
  • Data Export
  • Software Integration
  • QuickBooks Printer Support
  • Complete QuickBooks Solutions
  • Tax-Related Issues
  • Data Damage Recovery
  • Installation, Activation Help
  • QuickBooks Windows Support
Phone

+1800-983-3087

Accountspro Tollfree Number
Toll Free: 1800-983-3087