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
- In MS SQL Server Management Studio:
- Select Security > Logins > NT AUTHORITY\System
- View the Properties (right-click, select Properties)
- Select Server Roles
- Select Sysadmin
- OK to apply
- Start the AccountServer service.
If the service still does not start:
- In SQL Server Configuration Manager:
- Select SQL Server Network configation > Protocols for MSSQLSERVER (where MSSQLSERVER is your SQL instance name)
- Enable:
- Named Pipes
- TCP/IP
- Restart the SQL service
- Start the AccountServer service.
Comments
0 comments
Please sign in to leave a comment.