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.

This entry was posted on Thursday, May 6th, 2010 at 01:02 and is filed under Selfish. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.