cancel
Showing results for 
Search instead for 
Did you mean: 
nhm_shb
Level 1

Quickbooks Database Server Manager Status STOPPED

We have 4 company files on a dedicated computer running Quickbooks Database Server Manager. It's been working perfectly for over a year. Suddenly 7 days ago all users began getting kicked out of all company files at the same time. For Desktop users, Quickbooks either closes or shows an error message with only the option to "Abort".

Each time, Over on the dedicated host. Quickbooks Database Server Manager shows a status of "STOPPED" (on the "Database Server Tab"). Each time, I can go to the "Scan Folders" tab and "Start Scan" and it always works again but only for what seems like a random time period from 5 minutes to as long as 4 hours before once again kicking everyone out and showing a status of "STOPPED".

I have done the following troubleshooting so far.

I replaced the computer running Quickbooks Database Server Manager with a completely new computer and new installation of Quickbooks Database Server Manager. The result, is that the identical problem occurs. To me the seems to indicate that the issue is either with one or all company files or with a computer that accesses the shared folder or logs in to the company file...

I ran rebuild on all company files before the host computer change.

I have gone through all the typical troubleshooting steps. Setting the to services to restart after failure (which has no affect at all) and giving full access permissions etc.

I have checked Quickbooks logs on the host, but there is not enough information. It does not log anything when Status changes from "RUNNING" to "STOPPED". If there is a way to get more detailed logging I would like to know that..

I have contacted Intuit by phone and chat. Unfortunately, I keep getting the same suggestions that I have already tried.

I am checking log, taking screenshots of logged in users. Checking "Computer Managment" Shared sessions and open files. If there are other logs that might be helpful I would like to know that.

My next steps will be to try turning back on the old Host and move company files so see if I can determine if it only happens when the host running Quickbooks Database Server Manager is hosting a particular company file (or being accesses by certain client computers). I'm posting this in case someone is familiar with this issue and can share a better next step..

8 Comments 8
KathyS296
Level 4

Quickbooks Database Server Manager Status STOPPED

You don't say what  operating system (and version) you are running or what QB version you are running. Since you seem to have done a good job of troubleshooting I'll assume both the operating system and QB have been updated.

KathyS296
Level 4

Quickbooks Database Server Manager Status STOPPED

Also please let me know if any third party software is accessing QB through ODBC

nhm_shb
Level 1

Quickbooks Database Server Manager Status STOPPED

Quickbooks Enterprise 19.0 R12P
As mentioned.. same result with Quickbooks Database Server running on Windows 7 and 10
Quickbooks users are set to auto update and are all on R12P.
None of the Desktop users are in Hosting Mode.
Third party programs include Corrigo and The Loan Office (Loan Office is used once a month to import transactions).

ShiellaGraceA
QuickBooks Team

Quickbooks Database Server Manager Status STOPPED

Hello @nhm_shb,

 

You can uninstall your database server manager, rename the installation folder, and then reinstall the server manager again. Let me walk you through the process.

 

  1. On your keyboard, press the Windows key + R.
  2. Tyoe appwiz.cpl in the Run dialog box and then OK.
  3. Select the QuickBooks Database Server Manager. Then, Uninstall/Change.

Next, rename the installation folder by following these steps.

 

  1. Go to your installation folder location (Example: C:\Program Files\Common Files\Intuit).
  2. Press Windows key + R on your keyboard.
  3. Copy and paste the location of the folder, then Enter.
  4. Right-click the folder, and choose Rename. Rename the folder to .OLD.

Once done, reinstall QuickBooks Database Server Manager. Here's how:

 

  1. Close all open programs on your server computer, including QuickBooks.
  2. Open the installed file Setup_QuickBooks.exe. Then, follow the onscreen instructions. If you need to find your product or license numbers, here's how to find them.
  3. Select Custom or Network Options when asks to choose an install type. Then, Next
  4. Choose the best option for your network setup and then select Next. Both the options install the Database Server Manager. If QuickBooks Desktop is already installed on your server computer, this won’t overwrite any existing company data.
    1. If you want Database Server Manager and QuickBooks Desktop on your server computer, select I'll be using QuickBooks Desktop on this computer, AND I'll be storing... We strongly recommend this option.
    2. If you only want Database Server Manager on your server computer, select I will NOT be using QuickBooks Desktop...
  5. Click Install.

With these steps, you'll be able to keep your data server back up and running. You might also want to check your firewall and antivirus permissions to make sure you give your server manager permission to run on your server computer. 

 

We also have a guide on resolving network issues that I'm sure you'll find helpful. Here are the links:

 

I'll be on the look out of your reply if you have other questions or concerns. Please don't hesitate to swing by. Thanks for coming in, I wish you a wonderful day ahead.

nhm_shb
Level 1

Quickbooks Database Server Manager Status STOPPED

Thanks ShiellaGraceA. However, we have already gone through those steps. As mentioned not only did we do those steps we also completely replaced the computer hosting files and running Quickbooks Database Manager which means Quickbooks was installed on a new OS image and on new hardware that it had not been installed on before. Inbound/Outbound firewall rules were also manually entered as part of troubleshooting but that also is not a solution for us.

Kendra H
QuickBooks Team

Quickbooks Database Server Manager Status STOPPED

Good afternoon, @nhm_shb.

 

Thanks for following up on this thread. 

 

If this applies to your situation, there are several things you can try to fix the QuickBooks Database Server Manager.

 

First, I want to ask if you have the Database Server Manager (DBSM) set to automatic or manual? Also, there is an option under one of the tabs to set it to affect local or system. Usually, when you go in there, it will be set to system, and you'll need to check local instead. This often keeps the DBSM running and enables users to log in without issues. 

 

However, when you scan, it creates a database specific to the QuickBooks version you're using. You'll have to go to the Properties of the company file folder, look for that database under the Security tab, and edit it to give users full control

 

Also, it sounds like you're running a peer-to-peer network. If so, QuickBooks has to be installed on the one acting as the file host, and that QuickBooks Desktop needs to be set to hosting. Then, open each file there, set it to multi-user and then close them. When users access the files, they should behave normally. 

 

For more information about the QuickBooks Database Server Manager, please refer to this article: Use QuickBooks Database Server Manager

 

Feel free to comment below if you have any more questions, I'm always here to help. Have a safe and productive weekend ahead!

James Watson
Level 1

Quickbooks Database Server Manager Status STOPPED

You may try to visit the Following Link, To guaranteed Fix [removed link]. 

 

 

userGarciaR
Level 1

Quickbooks Database Server Manager Status STOPPED

Follow QuickBooks Database Server Manager to get multi-user mode access.

Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up

Need to get in touch?

Contact us