Posted on: 7/2/2015 1:21:07 PM | Views : 1797


So I installed a new instance of SQL Express called SQLEXPRESS. It installed but failed when starting the service at the very end. I reviewed logs and event viewer. Here is what I have found:

Error Trying to manually start the SQLExpress service using command NET START MSSQL$SQLEXPRESS /f /T3608:
C:\Program Files\Microsoft SQL Server\MSSQL11.SQLEXPRESS\MSSQL\DATA>net start ms sql$sqlexpress /f /T3608 The SQL Server (SQLEXPRESS) service is starting.. The SQL Server (SQLEXPRESS) service could not be started. A service specific error occurred: 2148081668.
Rebuild database succeeds without error, however when I try to start the service, this is logged in event viewer. Note the database is on the c drive not e as specified in the error:
FileMgr::StartLogFiles: Operating system error 2(The system cannot find the file specified.) occurred while creating ...

Go to the complete details ...