While installing SQL Server 2008 R2 enterprise edition on WIndows Server 2008 R2 the SQL install fails with following error
TITLE: Microsoft SQL Server 2008 R2 Setup
------------------------------
The following error has occurred:
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?LinkID=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=10.50.1600.1&EvtType=0xD15B4EB2%25400x4BDAF9BA%25401306%254024
Cause:
This happens because account under which SQL is running is not able access protected folders on C:
To resolve this issue
TITLE: Microsoft SQL Server 2008 R2 Setup
------------------------------
The following error has occurred:
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?LinkID=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=10.50.1600.1&EvtType=0xD15B4EB2%25400x4BDAF9BA%25401306%254024
Cause:
This happens because account under which SQL is running is not able access protected folders on C:
To resolve this issue
- Uninstall SQL
- Remove all folders created during install (C:\program files, C:\Program Files (X86)
- Add SQL servier service account (Domain account in my case) to local administrators group on the server
- Run the setup again
I also faced the similar problem while Installing SQl server 2012 and after long searching the internet I found the solution.Uninstall the previous installations of SQL Server(including registry files and remaining files) and install again.While installing you need to change the account name for database services to NT AUTHORITYNETWORK SERVICE and it will successfully installed without any errors.
ReplyDeleteFor detailed information with screenshot read this - http://www.superpctricks.com/2014/02/sql-install-error-database-engine-recovery-handle-failed.html