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).
Share on Google Plus

About Vittorio Pavesi

    Blogger Comment
    Facebook Comment

3 comments:

Anonymous said...

Thanks a lot!

Dennis Buduev said...

Thank you. Спасибо!

Ellis White said...

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