Question

Quickbooks Database Server Manager Status STOPPED

Forum|Forum|6 years ago
May 22, 2020
4 replies
83 views

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

QuickBooks Desktop

KathyS296

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

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

N

nhm_shbAuthor

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

G

GatorFrank

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!

Did the trick!

Thanks for your help....