Today, SQL Server 2008 express gave up on me. I installed it yesterday and it worked fine. Then I turned off my PC and when I turned it back on today, SQL Server Express wouldn't start. A quick look in the event log got me the following 2 errors.
FCB::Open failed: Could not open file C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA\mastlog.ldf for file number 2. OS error: 5(failed to retrieve text for this error. Reason: 1815).
FCB::Open failed: Could not open file C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA\master.mdf for file number 1. OS error: 5(failed to retrieve text for this error. Reason: 1815).
Additionally, when trying to change settings from the SQL Server Configuration manager, I got the following error.
You have until 1% to log off. If you have not logged off at this time, your session will be disconnected and any open files or devices you've opened may loose data. [0x80070d59]
The solution was to enter the Services control panel, locate the SQL SERVER (EXPRESS) service, pick the Log On tab and check "Log on as Local System Account".
That got the job done. It's running now.
February 16th, 2012 at 01:17
Error is all about the security permissions.
1. Give SQLServerMSSQLUser$Server$DATABASE user full access to Microsoft SQL Server\MSSQL10.XXXX\MSSQL\DATA folder.
2. Give SQLServerMSSQLUser$Server$DATABASE user full access, SQLServerSQLAgentUser$Server$DATABASE user write permission and SQLServerFDHostUser$SERVER$DATABASE user List Folder/Read DAta and Create Files / Write Data permission to Microsoft SQL Server\MSSQL10.XXXX\MSSQL\LOG folder.
February 17th, 2012 at 00:32
Yes. By having the service logon as a local system account, it is automatically granted those permissions. Yours is of course a good solution if you want your SQL Server instance to run with explicit permissions. Thanks for sharing.