Attix5 Pro FAQ
Search:     Advanced search

How to make the AccountServer service dependent on the MS SQL service

Article ID: 46
Last updated: 04 Jan, 2013

Symptom

In most cases the AccountServer is installed on the same box as MS SQL. After a reboot it sometimes happens that the AccountServer does not start up because MS SQL is not yet running.

Solution

To resolve the issue, set the AS service to be dependent on the MS SQL service. This ensures that the AS service only starts up after MS SQL has successfully started up.

Instructions

  1. Determine the exact service name for the SQL service.
    • Open the Services manager and locate the MSSQL service. The name listed is usually 'SQL Server (xxxx)'.
    • Double-click the service and note the service name at the top, typically MSSQLSERVER or MSSQL$SQLEXPRESS.
  2. Now follow Option 1 or Option 2 below.

Option 1

  1. Run regedit to open your registry.
  2. Navigate to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services and locate the AS_Service service.
  3. Create a DependOnService key by right-clicking and selecting New > Multi-String Value.
  4. In the value field, enter the service name for MSSQL as determined in the first step.
  5. Click OK and close your registry.

Option 2

In the Command Prompt, run 
     sc config AS_Service depend= MSSQL$SQLEXPRESS
where MSSQL$SQLEXPRESS is the exact name of the SQL service as determined in the first step. 
Note: There is a space after the "=".

Ensure that it works

If everything is working properly, when you try to stop SQL service, you should get a warning saying that the AccountServer service will also be stopped. Also, if both the AccountServer and SQL service have been stopped, and you start the AS service, the SQL service will be started automatically. A reboot might be required to ensure that the dependencies are active. 

Information adapted from http://support.microsoft.com/kb/193888.

Article ID: 46
Last updated: 04 Jan, 2013
Revision: 3
Views: 3876
Comments: 0
Posted: 01 Dec, 2010 by Marais D.
Updated: 04 Jan, 2013 by -- .
This article was:  
Prev   Next
Article 45 - Migrating V5.1 ReportServer data into a V6 SP     Article 47 - How to make the Server Edition service dependent on...