Sunday, September 22, 2013

The SQL Server (MSSQLSERVER) service terminated with service-specific error %%17058.

While trying to failover the SQL server to another node, it refused to start and this error was getting logged in the Event Viewer

The SQL Server (MSSQLSERVER) service terminated with service-specific error %%17058.
The problem turned out to be with ERRORLOG being set to read only.

After I cleared the read only attribute from MSSQL\LOG\ERRORLOG the service started successfully.

1 comment:

  1. Hi,

    thanks for your posting. That was the problem. I moved the MSSQL\LOG-directory to onother drive and forget to configure the security settings for the SQL-service user. After I gave the service user full access to the log-directory, I could start the sql-service again.

    Many greetings from Germany,

    Thorsten

    ReplyDelete