Unix Server Tech Knowledge Base

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
====== Quick Books Service Dies ======

===== Problem =====

Intuit Quickbooks runs a database server as a Windows Service. When it dies, it is not automatically restarted. When a user starts Quickbooks, it is fine; QuickBooks notices and restarts the service. However, if the user is not an administrator, it fails with the message //THIS ACTION REQUIRES ADMINISTRATOR PERMISSIONS//.

===== Fixes =====
There are several fixes available (one is to not use QuickBooks in anything but a workstation). One, which I'm scared to try is documented at https://community.spiceworks.com/topic/603605-quickbooks-occasionally-asks-for-windows-admin-permissions-for-dbmanagerexe-exe. I'm concerned how to recover if that doesn't work (since we don't know the QB user password).

Following appears to fix the problem, however.

===== Procedure =====

  - Find correct name of the service for QuickBooks
    - control panel | Administrative Tools | Services
    - Look for something like QuickBooksDB27 (the number and/or may change based on version)
  - Create a batch file with the following contents. replace ServiceName with the name you found (QuickBooksDB27 in the above example)<code bat fixQBServer.bat>
@ECHO OFF
FOR /F "tokens=3 delims=: " %%H IN ('SC QUERY "ServiceName" ^| FINDSTR "        STATE"') DO (
  IF /I "%%H" NEQ "RUNNING" (
   NET START "ServiceName"
  )
)</code>
   - Create a task to run this every hour
     - Open Task Scheduler
       - control panel | Administrative Tools | Task Scheduler
       - Create a new task
         - Action | Create Task
         - Fill in the information
         - General Tab
           - Name: something, I call mine "CheckQBService"
           - Description: Something to tell you what this does
           - Run whether user is logged in or not
           - Run with highest privileges
         - Triggers Tab
           - new
           - Daily
           - Repeat Task: every 1 hour
           - Ok
         - Actions Tab
           - New
           - Browse to the batch file you created
           - Ok
         - Settings Tab (skip Conditions)
           - Run task as soon as possible after a scheduled start is missed
           - Ok
         - Ok

You can test by shutting down the service in question, then running the task (find task in Task Scheduler, right click, select Run). The service should now start (you will have to refresh the Service Manager)

===== Links =====
  * https://www.acecloudhosting.com/knowledgebase/receiving-error-120-while-opening-company-file/
  * https://deepinthecode.com/2014/01/17/scheduled-task-ensure-windows-service-running/