Saturday, June 25, 2011

SQL Server 2008 R2 Installation error

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:

This happens because account under which SQL is running is not able access protected folders on C:

To resolve this issue
  1. Uninstall SQL
  2. Remove all folders created during install (C:\program files, C:\Program Files (X86)
  3. Add SQL servier service account (Domain account in my case) to local administrators group on the server
  4. Run the setup again

1 comment:

  1. 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.
    For detailed information with screenshot read this -