"Wait on the Database Engine recovery handle failed. Check the SQL Server error log for potential causes."
This error can occur if a Microsoft® system folder is either missing or lacking the correct permissions.
Please use the following steps:
Note: The following information is provided as a convenience. Sage does not provide support for Microsoft Products. For more information on this topic, go to Microsoft.com.
- Click the Windows® Start button and click Run.
- Type %appdata% and click OK.
- Browse to the Microsoft folder.
- Locate the Protect folder to assign the correct permissions:
Note: If the Protect folder is missing from the Microsoft folder, you will need to create it in this location by right-clicking and selecting Folder. Ensure to name the folder "Protect."
- Right-click on the Protect folder and select Properties.
- Click on the Security tab. Ensure the System and your logged on Windows User account is listed and both have Full Control.
- Click Add to begin adding the accounts. For Windows Vista®/Windows 7, you will need to click Edit first.
- In the "Enter the object names to select" box, type the word System, and press Enter on your keyboard. The System account should be listed now. Select System from the user names list and select Full Control under the Allow column. Click Apply .
- Repeat these steps (3 and 4) to find, add, and assign Full Control permissions for your logged on Windows user account.
- Click OK.
- Attempt to install SQL Server 2008 R2.
Also review the following knowledgebase article:
Title: Error: "Windows could not start the SQL Server (ACT7) on Local Computer. For more information, review the System Event Log... and refer to service-specific error code 1814." When Trying to Start SQL Server (ACT7)
Answer ID: Error: "Windows could not start the SQL Server (ACT7) on Local Computer. For more information, review the System Event Log... and refer to service-specific error code 1814." or "...error code 2146893052" Trying to Start SQL Server (ACT7)