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

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..

18 Comments 18
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 2

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 2

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.

RUndereood
Level 1

Quickbooks Database Server Manager Status STOPPED

I have the same problem and did the same things you did. Replacing everything still doesn’t work. After A reboot, the database service is it to manual and stopped.  

I wrote a powershell script that stops DNS, restarts QuickBooksDBService and then restarts DNS. I scheduled that to run via task scheduler every reboot.  

I called QuickBooks support and they don’t have an answer.   

It’s quite sad for as much money as a customer pays a year

Fiat Lux - ASIA
Level 15

Quickbooks Database Server Manager Status STOPPED

@RUndereood 

Which QBD year version do you have and Windows OS do you run?

1ntu1tssucksballz
Level 1

Quickbooks Database Server Manager Status STOPPED

Yeah, Intuit products are truly the worst. Support consistently makes it sound like it's something you did on your end, but the fact of the matter is that their software and their support is abysmal. Just now I rebooted a Windows server and the Database Manager Server won't start no matter what I try. No good reason. Just Intuit. There aren't network error. Their little utility just says "resolve errors and retry." The error is QuickBooks. Every time.

1ntu1tssucksballz
Level 1

Quickbooks Database Server Manager Status STOPPED

Generally speaking, this is a quick fix. Doesn't always work, but we support 15+ clients running server-side Enterprise Solutions or Desktop utilizing Database Manager Server. At best, it's clunky and fragile, and it breaks itself for no good reason regularly.

 

All that said, here's what works about 75% of the time:

 

  • Launch services.msc from Run.
  • Navigate to the service called QuickBooksDBXX (where XX is relative to whichever number Intuit decided to assign to your installation this time).
  • Open the service and click on the Log On tab at the top.
  • For the Log on as option, if it's trying to connect as the QuickBooksDBXX user it created, click instead on the radio button for Local System account.
  • Click OK.
  • Now, right-click on the QuickBooksDBXX service and click Start.

 

If she fires up, you should be good. If not, I'd say contact Intuit support, but you know where that'll getcha.


Good luck!

PhillipR
Level 1

Quickbooks Database Server Manager Status STOPPED

This worked great for my system!  Thank you very much!  I am using Windows 2019 Server to store the company files, and until this post, I could never get the QB Server Manager to work on Win2019 Server.  Thanks again!

GatorFrank
Level 1

Quickbooks Database Server Manager Status STOPPED

Did the trick!

Thanks for your help....

JLockX
Level 1

Quickbooks Database Server Manager Status STOPPED

This same issue just happened to me last night after a Windows Essentials 2016 update. What's the pro/cons of not using the DBXX user and the local account? Why have the DBXX user?

Rose-A
Moderator

Quickbooks Database Server Manager Status STOPPED

I'd be pleased to provide you with some information regarding the pros and cons of using the DBXX user and the local account, and why you'll need to have it, JLockX.

 

The Database Server Manager is a part of the QuickBooks Desktop file. This lets you share your company files with other computers over your network and helps you monitor your multi-user network. Being a BDXX user comes with a lot of perks. Here are just a few:

 

  • You don’t have to buy your own equipment or software licenses
  • You don’t have to hire database developers
  • You don’t have to build a database system
  • You don’t have to hire a large IT crew to maintain the system

 

The primary cons are you don't have direct access to the servers that are running the database. If you aren't planning to use multi-user access and will run the file on a single computer, you don't have to be a DBXX user.

 

To know more about how beneficial QuickBooks Database Server Manager is to your business, you can scan through the following resources below. You'll find more details about the advantages of using this service as well as how to keep everything running smoothly:

 

Install QuickBooks Database Server Manager.

Use QuickBooks Database Server Manager.


Additionally, in case you encounter issues with the system, the attached article contains solutions to resolve them: The QuickBooksDBXX service on Local Computer started and then stopped.

 

Hope I helped you get all straightened out today, JLockX. Let me know if you have other questions. Take care!

dunCAN2022
Level 1

Quickbooks Database Server Manager Status STOPPED

THANK YOU SHEILA!  This worked fabulously and quickly.  I called support and they wanted to charge me $250 per file to rebuild all of my files!  I wasn't having an issue with the files but with the hosting piece.  I can't tell you how angry I was to hear this as I have at least 11 accounts we use daily.   Intuit phone support is absolutely horrible.  I felt like I was paying a ransom - every time I call they want to sell me something.

ZackE
Moderator

Quickbooks Database Server Manager Status STOPPED

Welcome to the Community, dunCAN2022.

 

I'm happy to hear ShiellaGraceA was able to help you get your data server active again.

 

You'll also be able to find many detailed resources about using QuickBooks in our help article archives.

 

Please feel welcome to send a reply here or create a new thread if there's ever any questions. The Community's always here to help. Have a wonderful day!

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us