07 September 2012

SQL Express Install Error: Wait on the Database Engine recovery handle failed

When attempting to install SQL Express 2012 in Windows 8 I received the error:
Wait on the Database Engine recovery handle failed. Check the SQL Server error log for potential causes.
For help, click: http://go.microsoft.com/fwlink?...

The link usefully returns a page stating:
"There is no additional information about this issue in the Error and Event Log Messages or Knowledge Base databases at this time..."

A search online returned this page on http://blogs.msdn.com which gave some steps to resolve it. It appears to be related to corrupt profiles. The steps didn't quite work for me so here are my amended ones:
  1. Open the Services Console and right click SQL Server Express, choose Properties, Log On tab.
  2. It had 'This account' selected with a  NT Service\MSSQL$SQLEXPRESS user. I changed it to 'Local Service account'.
---------------------------
WMI Provider Error
---------------------------
Cannot find object or property. [0x80092004]
---------------------------
OK   
---------------------------

No comments:

Post a Comment