Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
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..
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.
Also please let me know if any third party software is accessing QB through ODBC
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).
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.
Next, rename the installation folder by following these steps.
Once done, reinstall QuickBooks Database Server Manager. Here's how:
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.
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.
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!
You may try to visit the Following Link, To guaranteed Fix [removed link].
Follow QuickBooks Database Server Manager to get multi-user mode access.
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
Which QBD year version do you have and Windows OS do you run?
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.
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:
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!
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!
Did the trick!
Thanks for your help....
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?
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:
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!
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.
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!
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here