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