When you try to start the Database Manager Service manually, you receive the error message:
The QuickBooksDBXX service on Local Computer started and then stopped. Some services stop automatically if they are not in use by other services or programs.
This may be caused by a damaged QuickBooks Database Server Manager. Try the following solutions to resolve the issue.
Solution 1: Turn on hosting
- From the File menu, select Utilities, then Host multi-user access.
- On the Host multi-user access window, select Yes.
Solution 2: Configure services
- Press the Windows key+R to bring up the Run window.
- Type services.msc, then press Enter. You can also search for services.msc on the Windows search bar.
- In the services window, look for the QuickBooksDBXX service that matches your version:
- QuickBooks 2020: QuickBooksDB30
- QuickBooks 2019: QuickBooksDB29
- QuickBooks 2018: QuickBooksDB28
- Double-click the QuickBooksDBXX service.
- Set the Startup Type to Automatic and Service Status to Running or Started.
- Go to the Recovery tab.
- From the First failure drop-down, select Restart the Service. This automatically restarts the QuickBooksDB service if it fails. Do the same for Second failure and Subsequent failures.
- Select OK to save the changes.
- Reboot your computer.
Solution 3: Change the install location
Reinstall using the default installation path:
- C:\Program Files\Intuit\QuickBooks(year) (32-bit)
- C:\Program Files (x86)\Intuit\QuickBooks (year) (64-bit)
|
Important: Do not install in a mapped drive. |
Solution 4: Recreate QBDataServiceUserXX
|
Important: If you receive an error stating that your Windows user account doesn't have the appropriate permissions, log in as a Windows admin or ask assistance from an IT professional. |
- Close QuickBooks.
- On your keyboard, press Windows key+R to bring up the Run window.
- Type services.msc, then press Enter.
- Right-click the service that matches your version, then choose Properties.
- QuickBooks 2020: QuickBooksDB30
- QuickBooks 2019: QuickBooksDB29
- QuickBooks 2018: QuickBooksDB28
- Go to the Log On tab, then set the service to This Account.
Note: Do not select Local System. Only some set-ups allow it to work on Local System.
- Delete qbdataserviceuserXX:
- On your keyboard, press Windows key+R to open the Run window.
- Type Control Panel, then select OK.
- Select User Accounts, then Remove user account.
- Select the qbdataserviceuserXX that matches your version, then Delete.
- Relaunch QuickBooks.
Note: If hosting was started, turn it off then turn it back on again. If hosting wasn't started, turn it on.
- When a prompt asking to run Database Server Manager pops up, select OK.
- Open the Database Server Manager and scan the file. This recreates the qbdataserviceuser.
