Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Below is the error I copied, please someone help me, I have tried at least 10 times in the last 3 days. It is SQL Server 2008 R2 and I wanted to install it on Windows 7.

Microsoft SQL Server 2008 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.0.1600.22&EvtType=0xE53883A0%25400xBE03358B%25401306%254024

share|improve this question
    
What does the SQL Server error log contain? –  Mat May 29 '13 at 19:11
    
Sorry I dont know How to check that –  Shaikh Nadeem May 29 '13 at 19:16
1  
I don't know either, but typing "sql server error log" in google seems to have a few hints :-) –  Mat May 29 '13 at 19:17
1  
Go to C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log and see the summary.txt as well as Detail.txt files. Also, have a look at blogs.msdn.com/b/sqljourney/archive/2012/03/16/… –  Kin May 29 '13 at 19:22
1  
Please check the sql server error log as well and tell us what it says C:\Program Files\Microsoft SQL Server\MSSQL.n\MSSQL\LOG –  Cougar9000 May 30 '13 at 16:05
show 5 more comments

2 Answers

Make sure the account doing the installation is a member of the following groups in local security policy:

  1. Adjust Memory quotas for a process
  2. Bypass Traverse checking
  3. Log on as a batch job
  4. Log on as a service
  5. Replace a process level token
  6. Backup files and directories
  7. Debug programs
  8. Manage auditing and security log

Additional Items to check: Make sure the account doing the install is a local admin on the server, make sure you are not installing to a compressed drive or folder, make sure you are installing the right version, IE 32 or 64 bit based on your OS

share|improve this answer
add comment

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 - http://www.superpctricks.com/2014/02/sql-install-error-database-engine-recovery-handle-failed.html

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.