Question

Having to click Start Scan in QB DB Server Manager when QB stops working

Forum|Forum|5 years ago
September 6, 2020
5 replies
0 views

Hi all, I'm really hoping someone can help with this ongoing problem that's eluding me.

The office is running QuickBooks Desktop Enterprise 19. There about about a dozen workstations and the server is Windows Server 2016. Suddenly, QuickBooks just stops working for everyone in the office (and this happens a few times a week). The fix is simple but cumbersome: go to the server, open QuickBooks Database Server Manager, click Start Scan, and click OK to run the scan. It always says: "Network Diagnostics: Check successful - no issues found. Network Diagnostics: Repair successful." This completely fixes the problem and the users can use QuickBooks again.

Anyone have any idea what's going on?! How can I fix this problem? Or can I at least automate this process so I don't have to keep going to the server and doing this temporary fix?

Thanks in advance!

QuickBooks Desktop

R

Rasa-LilaM

Thanks for reaching out to the Community about your concern, wamon.

I appreciate you performing the initial steps to resolve the issue. We'll have to restart the QuickBooks Database Service Manager and configure the firewall to get you back up and running.

QuickBooks Desktop 2019 uses dynamic ports and specific port numbers for better performance. They can cause unusual behavior or errors once they are blocked. To resolve the issue, refresh the connection by restarting the QuickBooks Database Service Manager.

Here’s how:

From your server computer, open QuickBooks Desktop.
Then, tap the File menu to choose Open or Restore Company.
Tick the radio button for Open a company file and look for the file you’re working on.
Once opened, click on Next to mark the box for Open file in multi-user mode and tap the Open option.
Next, log in to the company file and navigate to the File menu to select Close Company/Logoff.
This action will close the company file on your server.
Launch the Windows Start menu and enter Database in the search box.
Open QuickBooks Database Server Manager.

If the issue persists, go to the If you only installed Database Server Manager section to continue performing the troubleshooting steps in this article: Use QuickBooks Database Server Manager.

If none of these steps work, add a firewall port exception for QuickBooks. Check out this guide for the complete process: Set up firewall and security settings for QuickBooks Desktop.

You can bookmark the following link for future reference. It covers the complete instructions on how to download the QuickBooks Database Server Manager up to updating the server: Install QuickBooks Database Server Manager.

If there’s anything else I can help you with, click the Reply button to post a comment. I’ll be right here to assist further. Have a good one.

W

wamonAuthor

Thank you for the response, Rasa-LilaM. I only have the QuickBooks Database Server Manager installed on the server. I don't have QuickBooks Desktop on there. So, should I continue on to the "If you only installed Database Server Manager section" instead? Perhaps I need the firewall exception as well?

B

bonner09

I am actually having the exact same issue on 2 different systems in different locations. Started a few weeks/month ago both running QB20 DBM on Server 2012 R2, randomly throughout the week I will have to click "Start Scan", it scans and says "No issues found" but "Repair Successful" and it will work for a period of time.

Candice C

Good Afternoon, @bonner09.

Thanks for joining in on this thread. Since you're having the same issue on two different systems, I suggest getting in touch with our Customer Support Team. They can use a screen share tool to help walk you through some additional steps on how to resolve this problem.

Here's how:

Go to the Help menu.
Pick QuickBooks Desktop Help.
Click the Contact Us option.
Type in your question and press Continue.
Scroll down and choose to Get a callback or Check availability.

That's all there is to it!

If you run into any trouble along the way, feel free to ask. I want to make sure that you're able to get back to running your business. Have a fantastic day!

A

acs_hd

We had the same problem, almost daily. What's crazy is that it wouldn't kick users out of the company file when it happened, so users could be logged in and working, but the next user who attempted to open QB would receive the error. See attached errors. Not sure if this will help anyone but I did the following. Our setup has the file hosted on a Windows Server (without the QB software), and the QB server software running on a Windows 7 computer.

1) Uninstalled all versions of "QB Enterprise Server XX" on the hosting server except for QB Enterprise Server 20.0 which is the version we are on. Whenever we upgraded versions, the old Enterprise Server versions would remain. They never bothered us but we uninstalled just in case.

2) File->Utilizes->"Stop Hosting Multi-User Access" on the QB server with the software.

3) Reboot both PCs.

4) Open the DB Server Manager on the hosting computer. Go to the Ports tab and hit "renew" next to Enterprise 20.0 to get a fresh port. Do the folder scan to share the files.

5) Open the company file on the server and then host multi-user access again.

I want to change our setup so that the QB software is also on the computer where the file is hosted. I believe from looking at the .ND file and some of the other errors that the DB Manager couldn't tell if the file was being hosted on itself or on the server with the software. Hope this made sense.

L

liten

Had a similar problem, the "Database monitor of quickbooks" has crashed.

but I notice it is "trying to start" but is unable due to the UAC the issue is it not as a service but an application.

but due to the windows setting in User Account Control (UAC) In the Server that hosting the company file

need to move it down to the lowest setting, so it won't be stopped by the windows and ask you to click OK.

I have not full test I will continue to see if this issue occurs but I notice the UAC and after that it worked.

I assume the "server" that hosting the file needs to be logged in.

anyways give it a go tell me if it solved your problem

E

e-fluent1

Same problem here. Firewall on server is OFF. Happens almost every night. I'm suspecting when the backup runs.

Is there a reason Intuit can't use a real database engine like SQL, MySQL, dBaseIV, etc.?

M

mv32

Hi there, @e-fluent1.

Let's make sure that the shared file and the Database Server Manager are in good conditions. We can follow the steps recommended by Rasa-Lilam.

Once done, you can proceed with the guide provided by JamesDuanT to resolve it permanently by doing these steps:

Set up folder sharing correctly.
Configure the Database Server Manager.
Set your firewall permissions.
Update the Database Server Manager.

For reference and further information about these steps, you can check this article: Install QuickBooks Database Server Manager. Then update the release version of your QuickBooks.

If you encounter other issues while doing the process within your company file, you can reference these troubleshooting guides:

If the issue persists, I recommend reaching our Technical Support team to investigate the hurdle with their tools in a secure environment. Once they found out the root cause of it, they'll share you additional fixes.

QuickBooks use complex languages to keep your data safe. SQL, MySQL, dBase IV, and other database languages are more likely prone to injectors that may cause placement of data. You can ask more questions about this in our developer's site: Intuit Developer.

Please let me know if you have other concerns with QuickBooks. I'll respond as fast as I can. Take care and have a great day!

B

blinux

For those that have had to do the Scan almost all the time now - I was able to find away to "fix" this. Seems when you have a backup service or something else on like that one the server that has the database files - the connections on the services get paused by Windows or stopped while still saying running. Try this script I wrote:

https://github.com/BJMAYNARD/QuickBooks-Desktop-Constant-Repair-Fix

I've had almost no calls from clients since doing this "fix".

L

liten

See below setting I did, seem to solve the issue for now, will keep posted if it still fails

Rubielyn_J

It's a pleasure to have you here again, @liten.

I’m glad that the setting configuration solves your concern in QuickBooks.

Please know that you’re always welcome to post in the Community space for any QuickBooks concerns you may have.

If you need tips and resources to manage your QuickBooks Online account and finances, feel free to visit our Support page to learn more. This provides information to help your navigation experience be more effective.

Let us know if you have other concerns about QuickBooks. We'll be happy to lend a helping hand. Stay safe!

Sign up

Login with SSO

Login to the community

Login with SSO