0

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

10
  • What does the SQL Server error log contain?
    – Mat
    May 29, 2013 at 19:11
  • Sorry I dont know How to check that May 29, 2013 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, 2013 at 19:17
  • 2
    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 Shah
    May 29, 2013 at 19:22
  • 2
    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, 2013 at 16:05

2 Answers 2

1

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

0

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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

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