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 C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\DemoData.ldf for file number 2. OS error: 5(failed to retrieve text for this error. Reason: 15105).
Details:
The File C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\
DATA\DemoData.ldf in the message is not accessible to SQL Server for read and/or write
operations during startup or database recovery. SQL Server might not be able to find the file,
the file may be locked by another application, or SQL Server may not have permissions to
access the file.
Solution:
- Check that the file listed above is exist in the specified location.
- Check the read write attribute for the file.
- Check the SQL Server startup account has read and write permission to the folder and file.
- Check that the file is not opened by another process.
- Check that the file is not encrypted.
- Provide FULL CONTROL (not just modify) to the service logon account (in my scenario was Network Service).
HI Arun,
ReplyDeleteWe have faced the same issue.. today.. we have SQL Server cluster service which was running under specific Domain user account. Unfortunately.. that user was account was changed by someone and tried starting the sql service.. but it throws following error.
Error: 'FCB::Open failed: Could not open file MSSQL\DATA\master.mdf for file number 1. OS error: 5(failed to retrieve text for this error. Reason: 15105).
Could not open file MSSQL\DATA\mastlog.ldf for file number 2. OS error: 5(failed to retrieve text for this error. Reason: 15100)
any help would be appreciated..
Hello,
DeleteCheck below link for solution:
http://support.microsoft.com/kb/929665
This comment has been removed by the author.
ReplyDeleteThanks this works great
ReplyDeleteNice article simply explained in short. After a long googling I have found this one here you will see a long explanation about SQL Server Error 17204. http://sqltechtips.blogspot.com/2015/12/fcb-open-failed-error-17204.html
ReplyDeletewhatsapp görüntülü show
ReplyDeleteücretli.show
ZFV
görüntülü.show
ReplyDeletewhatsapp ücretli show
ACS46