Last Updated on February 16, 2021 by Editorial Staff
The QuickBooks database server manager network diagnostic failed issue appears while a user tries to access your company file in multi-user mode. It always appears with an error message ‘Network Diagnostics: Failed. Resolve Errors and Retry!!’. Because of this, the users face a lot of problems using QuickBooks in multi-user mode. Today’s article is all about this, here we will discuss how to fix the QuickBooks database server manager issue, and the way to use the tool in the right way.
Save Time & Effort
Get help from expert
Get your accounting work done by experienced accountants. Fix all your accounting software errors & problems. Dial our toll-free number +1-888-202-8743.
Obviously we will know about the solution to this problem, but before that it will be good to give a little overview about the server manager tool. So that, the new users will be able to get some idea regarding this tool, those who have no enough idea about this.
- What is QuickBooks Database Server Manager
- Why we Use QuickBooks Database Server Manager
- How to Set Up QuickBooks Database Server Manager
What is QuickBooks Database Server Manager
QuickBooks database server manager is a tool that helps you to share your company file among all users in a connected network, and it also allows you to make any QuickBooks database usable over the network easily. This is the topic for today, let’s start the blog, to know more deeply regarding this tool.
Network Diagnostic Issue in QBDMS
While we need to use QuickBooks in multi-user mode, it is always mandatory to use the QuickBooks database server manager to allows the users to access the company file from the server on the particular network. But sometimes it doesn’t function with Windows, and the database server issue stops you to access the QuickBooks company files.
And sometimes, this issue displays on your screen, after the QuickBooks update. Actually, the database server manager issue varies in different situations, reasons, with different error messages.
Variation of database server issue:
- Firewall: Disabled exceptions not defined. Resolve errors and Retry!!- Network Diagnostics: Failed.
- Network Diagnostics: Issues detected, trying to resolve- QuickBooks
- 20XX Server Running- Windows
- QuickBooks database server manager stopped- Network server failure
- QuickBooks database server manager no files are connected- Company file issue
How to Fix QuickBooks Database Server Manager Status Stopped
Fix the database server manager by updating the new verson of the tool, and by resolving the connection issues in QuickBooks. Follow the procedures to fix the problem.
Solution 1: Use the Latest Version of QB Database Server Manager
- Launch the run window, and type ‘Service.msc’ then run it.
- Now will get the list of installed service.
- Search for the ‘QuickBooksDBXX service’ file, and verify the last 2 digits of the file is matched with the current using QuickBooks Desktop version.
- If the versions of the server manager and Desktop are different from each other then update the tool to the appropriate version.
Solution 2: Repair the Network Connection Issues
- Download QuickBooks tool hub in your system, and save it in a portable place, where you can easily access it from your Windows.
- Save the file, and install it.
- Now open the tool, and search for the network connection issue section.
- Go to the section, and run QuickBooks connection diagnostic tool.
- It will take some time to diagnose the problem.
- After the complete process, check for the error.
We hope, you have no trouble to use the tool properly.
if you are new to this tool then read the following and start getting knowledge by why the users use this tool in a high demand.
Why we Use QuickBooks Database Server Manager
QuickBooks database server manager has high demand because its usability user-friendly functions. Here we have mentioned some of the functions, you can check all the points to know more about this.
- It will help you to track the local drive and it makes the company file useful for another user on QuickBooks hosting.
- QBDMS allows you to create a network data file to save it on the micro host workstation.
- You can get options to use different QuickBooks versions through this tool. But here you need to install the tool for each Desktop version to access the company file at the same time.
- Database server manager is also available for Mac users as the QuickBooks Linux database server manager.
System Requirements to Use QBDSM
In order to use QBDSM, it is necessary to use a compatible system for it. So let’s see QuickBooks database server management requirements for your system.
- First of all, you need a dual-core processor for the fine work.
- Strong broadband (having good speed internet)
- Supported OS (Operating System) – All Windows version, and OS, Linux OS (For Mac)
- The minimum space in RAM must be 1 GB, and the free space must have 2.5GB.
How to Set Up QuickBooks Database Server Manager
Here in the below we have provided the all the procedure that you will need to use the tool, so read and follow the instruction carefully.
How to Download & Install QuickBooks Database Server Manager
If you want to share your company file over network amongst all the users. Then you have to download QuickBooks desktop. Because QuickBooks database server manager is a part of QuickBooks desktop. And without this tool, you can’t share your company files amongst all the users. You can also use the database server manager tool through the QuickBooks tool hub.
Step 1: Download the QuickBooks Database Server Manager
The QuickBooks database server manager is a part of QuickBooks Desktop, so if you want to use the tool then you need to download QuickBooks Desktop first.
Step 2: Install the Tool Properly
Install the database server manager tool in the server system, where all the company file hosts. Follow the procedure to install the database server manager tool:
- First of all, close all the running programs on the server system. even the QuickBooks also.
- Open the downloaded file ‘Setup_QuickBooks.exe’ file and follow the prompted instructions to install it.
- During the installation process, keep your license, and product number.
- Choose installation type as the ‘Custom or Network Options’, and click the ‘next’ option.
- After that you need to choose any one of the options from the below:
- ‘I’ll be using QuickBooks Desktop on this computer, AND I’ll be storing…’ – Choose this, if need the database server and the QuickBooks Desktop on the server system.
- ‘I will NOT be using QuickBooks Desktop…’ – Choose this option, if you only want to database on the server.
- It will be good to first one because QuickBooks recommend to choose the first option for the best facility.
- Complete the installation process step, by step, and click the ‘Install’ option at the last.
Configure the Database Server Tool
If you want to use the default setting of database server manager, then you can skip it.
- Click on the ‘Start’ menu from the windows.
- Now in the search space type ‘services’, and open it.
- Open the file ‘QuickBooksDBXX’ (here the XX is version number of your database server manager tool).
- Then find the ‘Service Status Section; from the ‘General’ tab.
- Click on the ‘Stop’ option if it’s started running.
- From the ‘Start Up type’ menu, select the ‘Automatic’ option, and from the ‘Logon’ tab, select the ‘Local System Account’ option.
- Choose the ‘Restart the service’ option for each menu from the ‘Recovery’ tab.
- Again go back to the ‘General’ tab, and restart the tool by clicking on the ‘Start’ option.
Step 3: Set Up the Firewall Permissions
- Check your firewall, and anti-virus permission.
- And make sure that, you have given permission to the database server manager to run on the server computer.
How to Use QuickBooks Database Server Manager
Use the QuickBooks database server manager properly by following the below methods:
Open QuickBooks Database Server Manager
After downloading and installing QBDSM, you must know how to open QuickBooks database server manager. So that you can use it to make the company file public protection. So that anyone can use the company files on their system.
- First, you need to go Start button from taskbar
- Then click on the Program option >and click on QuickBooks database server manager
- You will see the QBDSM window open.
Make Your QuickBooks Company File Available To your User
In a firm, it’s necessary to avail the company file to all users. So that work will complete fast. So in order to avail Company files to use. You must know the steps for it.
- First, open your QuickBooks and login to your company file
- Now you will see rock construction, click on Open
Now let’s see where your company file is located.
Procedure to Find Company File Location
If you want to make the company file available to your user. Then you need to press
F2, now you can see a Popup window where you will get the path of the company file. That is currently saved in your personal document folder.
- So first you need to save this company file as a backup, go to the File menu.
- And create a local backup
- Now click on Next then again Next button
- Then save it on the desktop and give a unique name.
- It will take a few seconds to save your company file as a backup.
- And this file you can copy and paste and share on the cloud easily
- Now you have to close the company file that is available in your private document folder.
- Now you have to restore it on a new location
- To do so you need to open the existing company file and select Restore and Backup copy
- Find that file that we just saved by clicking on the browse button, select the file, and click Open.
- Click on Next, now choose the location where you have to save.
- Select C drive>, users >public> public document> Intuit> QuickBooks> company files and save hare
- Via this process, your company file unzip here
- Now you can check your company file location by pressing F2,
How to Manage Database Server Manager in QuickBooks
In the database server manager tool, you can get many other tabs to run everything perfectly, such as, system tab, database server tab, dynamic ports, and etc
- System Tab:- This tab will help you to know that ‘where the database server manager is installed on your system?’.
- Database Server Tab:- the database server manager tab will show the real-time status of the tool like ‘Who is connected to it now?’, and etc.
How To Scan Your Folder
- To scan the folder using the QuickBooks database server manager, at first, you have to go to the ‘Start’ menu of the Window of the server.
- Then in the search bar type ‘Database’ and then click on the ‘QuickBooks Database Server Manager’ option.
- After that click on the ‘Scan Folders’ tab. But here you have to remember that if the database server manager is in 2019 version then this process will share all the folders you have, you may need to set up your folder permission to give access to some specific users.
- Now go for the ’Browse’ option and select the folders which are included with the QuickBooks company file.
- Click on the ‘Ok’ option and at the last, click the ‘Start Scan’ option.
After the complete scanning process, you will be able to see the folder of ‘QuickBooks company files found’, and now you can able to access the files in these folders from other systems.
How to Monitored the Drives
- First of all, you have to scan the folders by following the above steps.
- Then go for the ‘Monitored Drives’ tab and checkmark on the box of ‘Monitored’.
- You will not need to rescan the folders if you want to change or move company files on the drive.
- Remember that if you want to monitor mapped drives, then you will not able to do it.
How to Restart QuickBooks Database Server Manager
This process will help you, whenever you found any error or problem to open the database server manager in your server. Here we have mentioned to methods to restart the tool.
The first restarting process is for those who have installed the database server with QuickBooks desktop. Let’s start the method:
- From the server system, open the QuickBooks Desktop and go to the ‘File’ menu.
- Select the ‘Open or Restore Company’ option from the ‘File’ menu, and go for the ‘Open a company file’ option.
- Now search and open the company file.
- Then click on the ‘Next’ option.
- After that select or mark on the ‘Open file in multi-user mode’ checkbox, and open it by clicking on the ‘Open’ option.
- Now login to the company file, and select the ‘Close Company/Log off’ option from the ‘File’ menu.
- Now the company file will be closed on the server.
- Then come to the ‘Start’ button of the windows, and type ‘Database’ in the search bar.
- ‘QuickBooks Database Server Manager’ option will appear, just click on it to open it again.
And the second method is for those who have only installed the database server manager.
- From the server windows, go for the ‘Start’ menu, and click on it.
- Now in the ‘Search programs and File’ bar type ‘Control Panel’ and select it.
- Then open the administrative tools, and go for the ‘Services’ option from the list.
- Now in the ‘QuickBooksDB_ _’ service right-click on it, and select the ‘Restart’ option from the list.
(Here _ _ is the version of database server manager)
How to Update QuickBooks Database Server Manager Tool
QuickBooks database server manager does not need any update manually, it updates itself automatically, and also update during the update of QuickBooks Desktop. Because this tool is part of QuickBooks Desktop.
So, this was the blog we hope now you will be able to manage (download, install, use, update) the QuickBooks database server manager easily. Still, if in case, you face any problem to manage the tool properly then, you can get our ProAdvisor support through the toll-free number +1-888-202-8743 .