SQL Doesn't start and Event ID = 17204


After hardening a server, the service didn't start anymore and I found the following error:

Event ID = 17204
FCB::Open failed: Could not open file d:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\mastlog.ldf for file number 2. OS error: 5(failed to retrieve text for this error. Reason: 15105).

Solution:
Provide FULL CONTROL (not just modify) to the service logon account (in my scenario was Network Service).
Tags: ,

About author

Vittorio Pavesi

3comments

  1. Anonymous
    12:24 PM

    Thanks a lot!

  2. Thank you. Спасибо!

  3. Relatively the backup of the SQL database from which you’re trying to restore is got corrupt because it exceeds its size. Read more and get help how to resolve it from here:- http://www.sqlrecoverysoftware.net/blog/sql-error-15105.html

Post a Comment