-
Title
SQL Attachability Check Fails with Operating system error 5: “5(Access is denied.)” -
Description
The following errors appear when performing a SQL attachability check:
Attachability check failed for SQL database XYZ of instance MSSQLSERVER:
* Failed Operation Exception: Attach database failed for Server ‘INSERT SQL DATABASE NAME’.
* Execution Failure Exception: An exception occurred while executing a Transact-SQL statement or batch.
* Sql Exception: Unable to open the physical file “C:ProgramDataAppRecoveryMountPoints611f157a-c808-4ec9-ae0d-0dcac2eabf1bL__Logsrichdale_training_log.ldf”. Operating system error 5: “5(Access is denied.)”.
System.InvalidOperationException: Failed to connect to MSSQL Server instance ‘MSSQLSERVER’ with user name ‘administrator’ and authentication type ‘Windows Authentication’. Make sure that specified credentials are correct and MSSQL Service is running —> Microsoft.SqlServer.Management.Common.ExecutionFailureException: An exception occurred while executing a Transact-SQL statement or batch. —> System.Data.SqlClient.SqlException: xp_regread() returned error 5, ‘Access is denied.’
xp_regread() returned error 5, ‘Access is denied.’
xp_regread() returned error 5, ‘Access is denied.’
at Microsoft.SqlServer.Management.Common.ConnectionManager.ExecuteTSql(ExecuteTSqlAction action, Object execObject, DataSet fillDataSet, Boolean catchException)
at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteReader(String sqlCommand, SqlCommand& command)
-
Resolution
To resolve this issue:
1. Stop the Core service as well as the SQL server service on the Core.
2. Set the log on account for the SQL server service to a local or domain administrator.
3. Start the SQL server service and create a new user. Give the new user account as sysadmin role security permission.
4. Start the Core service,
5. On the Core console, access the agent’s Summary tab, set the SQL credentials to use the new user account and set it to Windows login instead of SQL.