Attix5 Pro FAQ
Search:     Advanced search

AccountServer service unable to start at install using MS SQL 2012

Article ID: 232
Last updated: 06 Aug, 2013

Symptom

Configuration:
MS SQL 2012. Service running as Local System
AccountServer Install steps - selected option 'Use a local instance of SQL Server'

After clicking on Apply (last setup step - Configuration Summary), a popup appears stating:
AS_Service failed to start. Please see the logs for more information.

The error in the ASError log:
11:00:04.513 (06) Error: SQL server reported the following error: Cannot open database "StoragePlatform" requested by the login. The login failed.
Login failed for user 'NT AUTHORITY\SYSTEM'.. System.Data.SqlClient.SqlException (0x80131904): Cannot open database "StoragePlatform" requested by the login.
The login failed. Login failed for user 'NT AUTHORITY\SYSTEM'.
at System.Data.SqlClient.SqlInternalConnection.OnError....

Cause

The Local System account does not have the required permissions to access the database.

Solution

  1. In MS SQL Server Management Studio:
    1. Select Security > Logins > NT AUTHORITY\System
    2. View the Properties (right-click, select Properties)
    3. Select Server Roles
    4. Select Sysadmin
    5. OK to apply
  2. Start the AccountServer service

If the service still does not start

  1. In SQL Server Configuration Manager:
    1. Select SQL Server Network configation > Protocols for MSSQLSERVER (where MSSQLSERVER is your SQL instance name)
    2. Enable:
      • Named Pipes
      • TCP/IP
    3. Restart the SQL service
  2. Start the AccountServer service
Article ID: 232
Last updated: 06 Aug, 2013
Revision: 5
Views: 71195
Comments: 0
Posted: 26 Jun, 2013 by Van Rensburg J.
Updated: 06 Aug, 2013 by Van Rensburg J.
This article was:  
Prev   Next
Article 228 - Upgrading a re-branded V6.x Storage Platform to V7.0.1 results...     Article 238 - Unable to include a mandatory patching file to a backup selection