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.

6 comments:

  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
  2. It is the best time to make some plans for the future
    and it’s time to be happy. I have read this post and if I could
    I want to suggest you few interesting things or tips.
    Maybe you could write next articles referring to this article.
    I want to read more things about it!
    일본경마

    magosucowep

    ReplyDelete