FCB::Open failed: Could not open file
You start the SQL Server service and notice that the database is unavailable. You look in the error log and see this message:"FCB::Open failed: Could not open file <filename> for file number <filenumber>. OS error: 5(access denied)".
The access denied part of the message may be replaced with error not found.
This is because the account the SQL Server service runs under does not have access to the folder containing the database or log files.
Check which account the service runs as by starting SQL Server Configuration Manager.
Now perform the following steps:
- Right-click on the folder containing one of the database files and select Sharing and Security...
- Select the Security tab
- Click the Add... button
- In the text box type in the fully qualified user name of the service account (e.g. MyDomain\MySQLAccount)
- Ensure the Full Control checkbox in the Allow column is checked, and click OK
Not found what you're looking for?
Use this search box. It is tuned for SQL Server searches. Try it and see!Do you have a question about SQL Server? Would you like to answer a question?
Go to the SQL FAQ to get started.
