Databases
StackOverflow2013
Postsdbo
POWait on the Database Engine recovery handle failed. Check the SQL server error log for potential causes
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POWait on the Database Engine recovery handle failed. Check the SQL server error log for potential causes
    primarykey
    data
    text
    <p><strong>I m using SQL Server 2012 Developer Edition. Even I tried 2012 express and enterprise edition but all gave same error. I browsed msdn blog as well as few post on stackoverflow. But nothing help me out from this !!!</strong></p> <p><img src="https://i.stack.imgur.com/Zuc4C.jpg" alt="Error Details"></p> <p><img src="https://i.stack.imgur.com/P58q1.jpg" alt="Installation failed"></p> <p><strong>Here is the error log details</strong></p> <pre><code>Overall summary: Final result: Failed: see details below Exit code (Decimal): -2061893606 Start time: 2013-10-21 12:58:05 End time: 2013-10-21 13:52:30 Requested action: Install Setup completed with required actions for features. Troubleshooting information for those features: Next step for RS: Use the following information to resolve the error, uninstall this feature, and then run the setup process again. Next step for SQLEngine: Use the following information to resolve the error, uninstall this feature, and then run the setup process again. Next step for DQ: Use the following information to resolve the error, uninstall this feature, and then run the setup process again. Next step for FullText: Use the following information to resolve the error, uninstall this feature, and then run the setup process again. Next step for Replication: Use the following information to resolve the error, uninstall this feature, and then run the setup process again. Machine Properties: Machine name: CROY-TOSH Machine processor count: 4 OS version: Windows 7 OS service pack: Service Pack 1 OS region: United States OS language: English (United States) OS architecture: x64 Process architecture: 64 Bit OS clustered: No Product features discovered: Product Instance Instance ID Feature Language Edition Version Clustered Package properties: Description: Microsoft SQL Server 2012 Service Pack 1 ProductName: SQL Server 2012 Type: RTM Version: 11 SPLevel: 0 Installation location: C:\Users\CRoy\Downloads\SQL Server 2012 Developer Edition (x86 and x64) - DVD (English)\x64\setup\ Installation edition: Developer Product Update Status: None discovered. User Input Settings: ACTION: Install ADDCURRENTUSERASSQLADMIN: false AGTSVCACCOUNT: NT Service\SQLSERVERAGENT AGTSVCPASSWORD: ***** AGTSVCSTARTUPTYPE: Manual ASBACKUPDIR: C:\Program Files\Microsoft SQL Server\MSAS11.MSSQLSERVER\OLAP\Backup ASCOLLATION: Latin1_General_CI_AI ASCONFIGDIR: C:\Program Files\Microsoft SQL Server\MSAS11.MSSQLSERVER\OLAP\Config ASDATADIR: C:\Program Files\Microsoft SQL Server\MSAS11.MSSQLSERVER\OLAP\Data ASLOGDIR: C:\Program Files\Microsoft SQL Server\MSAS11.MSSQLSERVER\OLAP\Log ASPROVIDERMSOLAP: 1 ASSERVERMODE: MULTIDIMENSIONAL ASSVCACCOUNT: NT Service\MSSQLServerOLAPService ASSVCPASSWORD: &lt;empty&gt; ASSVCSTARTUPTYPE: Automatic ASSYSADMINACCOUNTS: CRoy-TOSH\CRoy ASTEMPDIR: C:\Program Files\Microsoft SQL Server\MSAS11.MSSQLSERVER\OLAP\Temp BROWSERSVCSTARTUPTYPE: Disabled CLTCTLRNAME: ROY CLTRESULTDIR: C:\Program Files (x86)\Microsoft SQL Server\DReplayClient\ResultDir\ CLTSTARTUPTYPE: Manual CLTSVCACCOUNT: NT Service\SQL Server Distributed Replay Client CLTSVCPASSWORD: &lt;empty&gt; CLTWORKINGDIR: C:\Program Files (x86)\Microsoft SQL Server\DReplayClient\WorkingDir\ COMMFABRICENCRYPTION: 0 COMMFABRICNETWORKLEVEL: 0 COMMFABRICPORT: 0 CONFIGURATIONFILE: C:\Program Files\Microsoft SQL Server\110\Setup Bootstrap\Log\20131021_125116\ConfigurationFile.ini CTLRSTARTUPTYPE: Manual CTLRSVCACCOUNT: NT Service\SQL Server Distributed Replay Controller CTLRSVCPASSWORD: &lt;empty&gt; CTLRUSERS: CRoy-TOSH\CRoy ENABLERANU: false ENU: true ERRORREPORTING: true FEATURES: SQLENGINE, REPLICATION, FULLTEXT, DQ, AS, RS, RS_SHP, RS_SHPWFE, DQC, BIDS, CONN, IS, BC, SDK, BOL, SSMS, ADV_SSMS, DREPLAY_CTLR, DREPLAY_CLT, SNAC_SDK, MDS FILESTREAMLEVEL: 2 FILESTREAMSHARENAME: MSSQLSERVER FTSVCACCOUNT: NT Service\MSSQLFDLauncher FTSVCPASSWORD: &lt;empty&gt; HELP: false IACCEPTSQLSERVERLICENSETERMS: false INDICATEPROGRESS: false INSTALLSHAREDDIR: C:\Program Files\Microsoft SQL Server\ INSTALLSHAREDWOWDIR: C:\Program Files (x86)\Microsoft SQL Server\ INSTALLSQLDATADIR: &lt;empty&gt; INSTANCEDIR: C:\Program Files\Microsoft SQL Server\ INSTANCEID: MSSQLSERVER INSTANCENAME: MSSQLSERVER ISSVCACCOUNT: NT Service\MsDtsServer110 ISSVCPASSWORD: &lt;empty&gt; ISSVCSTARTUPTYPE: Automatic MATRIXCMBRICKCOMMPORT: 0 MATRIXCMSERVERNAME: &lt;empty&gt; MATRIXNAME: &lt;empty&gt; NPENABLED: 0 PID: ***** QUIET: false QUIETSIMPLE: false ROLE: &lt;empty&gt; RSINSTALLMODE: DefaultNativeMode RSSHPINSTALLMODE: SharePointFilesOnlyMode RSSVCACCOUNT: NT Service\ReportServer RSSVCPASSWORD: &lt;empty&gt; RSSVCSTARTUPTYPE: Automatic SAPWD: ***** SECURITYMODE: SQL SQLBACKUPDIR: &lt;empty&gt; SQLCOLLATION: Latin1_General_CI_AI SQLSVCACCOUNT: NT Service\MSSQLSERVER SQLSVCPASSWORD: ***** SQLSVCSTARTUPTYPE: Automatic SQLSYSADMINACCOUNTS: CRoy-TOSH\CRoy SQLTEMPDBDIR: &lt;empty&gt; SQLTEMPDBLOGDIR: &lt;empty&gt; SQLUSERDBDIR: &lt;empty&gt; SQLUSERDBLOGDIR: &lt;empty&gt; SQMREPORTING: false TCPENABLED: 0 UIMODE: Normal UpdateEnabled: true UpdateSource: MU X86: false Configuration file: C:\Program Files\Microsoft SQL Server\110\Setup Bootstrap\Log\20131021_125116\ConfigurationFile.ini Detailed results: Feature: Management Tools - Complete Status: Passed Feature: Client Tools Connectivity Status: Passed Feature: Client Tools SDK Status: Passed Feature: Client Tools Backwards Compatibility Status: Passed Feature: Management Tools - Basic Status: Passed Feature: SQL Server Data Tools Status: Passed Feature: Reporting Services - Native Status: Failed: see logs for details Reason for failure: An error occurred for a dependency of the feature causing the setup process for the feature to fail. Next Step: Use the following information to resolve the error, uninstall this feature, and then run the setup process again. Component name: SQL Server Database Engine Services Instance Features Component error code: 0x851A001A Error description: Wait on the Database Engine recovery handle failed. Check the SQL Server error log for potential causes. Error help link: http://go.microsoft.com/fwlink?LinkId=20476&amp;ProdName=Microsoft+SQL+Server&amp;EvtSrc=setup.rll&amp;EvtID=50000&amp;ProdVer=11.0.3128.0&amp;EvtType=0xD15B4EB2%400x4BDAF9BA%401306%4026&amp;EvtType=0xD15B4EB2%400x4BDAF9BA%401306%4026 Feature: Database Engine Services Status: Failed: see logs for details Reason for failure: An error occurred during the setup process of the feature. Next Step: Use the following information to resolve the error, uninstall this feature, and then run the setup process again. Component name: SQL Server Database Engine Services Instance Features Component error code: 0x851A001A Error description: Wait on the Database Engine recovery handle failed. Check the SQL Server error log for potential causes. Error help link: http://go.microsoft.com/fwlink?LinkId=20476&amp;ProdName=Microsoft+SQL+Server&amp;EvtSrc=setup.rll&amp;EvtID=50000&amp;ProdVer=11.0.3128.0&amp;EvtType=0xD15B4EB2%400x4BDAF9BA%401306%4026&amp;EvtType=0xD15B4EB2%400x4BDAF9BA%401306%4026 Feature: Data Quality Services Status: Failed: see logs for details Reason for failure: An error occurred for a dependency of the feature causing the setup process for the feature to fail. Next Step: Use the following information to resolve the error, uninstall this feature, and then run the setup process again. Component name: SQL Server Database Engine Services Instance Features Component error code: 0x851A001A Error description: Wait on the Database Engine recovery handle failed. Check the SQL Server error log for potential causes. Error help link: http://go.microsoft.com/fwlink?LinkId=20476&amp;ProdName=Microsoft+SQL+Server&amp;EvtSrc=setup.rll&amp;EvtID=50000&amp;ProdVer=11.0.3128.0&amp;EvtType=0xD15B4EB2%400x4BDAF9BA%401306%4026&amp;EvtType=0xD15B4EB2%400x4BDAF9BA%401306%4026 Feature: Full-Text and Semantic Extractions for Search Status: Failed: see logs for details Reason for failure: An error occurred for a dependency of the feature causing the setup process for the feature to fail. Next Step: Use the following information to resolve the error, uninstall this feature, and then run the setup process again. Component name: SQL Server Database Engine Services Instance Features Component error code: 0x851A001A Error description: Wait on the Database Engine recovery handle failed. Check the SQL Server error log for potential causes. Error help link: http://go.microsoft.com/fwlink?LinkId=20476&amp;ProdName=Microsoft+SQL+Server&amp;EvtSrc=setup.rll&amp;EvtID=50000&amp;ProdVer=11.0.3128.0&amp;EvtType=0xD15B4EB2%400x4BDAF9BA%401306%4026&amp;EvtType=0xD15B4EB2%400x4BDAF9BA%401306%4026 Feature: SQL Server Replication Status: Failed: see logs for details Reason for failure: An error occurred for a dependency of the feature causing the setup process for the feature to fail. Next Step: Use the following information to resolve the error, uninstall this feature, and then run the setup process again. Component name: SQL Server Database Engine Services Instance Features Component error code: 0x851A001A Error description: Wait on the Database Engine recovery handle failed. Check the SQL Server error log for potential causes. Error help link: http://go.microsoft.com/fwlink?LinkId=20476&amp;ProdName=Microsoft+SQL+Server&amp;EvtSrc=setup.rll&amp;EvtID=50000&amp;ProdVer=11.0.3128.0&amp;EvtType=0xD15B4EB2%400x4BDAF9BA%401306%4026&amp;EvtType=0xD15B4EB2%400x4BDAF9BA%401306%4026 Feature: Master Data Services Status: Passed Feature: Distributed Replay Client Status: Passed Feature: Distributed Replay Controller Status: Passed Feature: Integration Services Status: Passed Feature: Data Quality Client Status: Passed Feature: Analysis Services Status: Passed Feature: Reporting Services - SharePoint Status: Passed Feature: Reporting Services Add-in for SharePoint Products Status: Passed Feature: SQL Browser Status: Passed Feature: Documentation Components Status: Passed Feature: SQL Writer Status: Passed Feature: SQL Client Connectivity Status: Passed Feature: SQL Client Connectivity SDK Status: Passed Rules with failures: Global rules: Scenario specific rules: Rules report file: C:\Program Files\Microsoft SQL Server\110\Setup Bootstrap\Log\20131021_125116\SystemConfigurationCheck_Report.htm </code></pre> <p>Here is few links</p> <p><a href="http://blogs.msdn.com/b/sqljourney/archive/2012/03/16/sql-2008-r2-setup-fails-with-quot-wait-on-the-database-engine-recovery-handle-failed-quot.aspx" rel="noreferrer">Blog MSDN</a></p> <p><a href="https://stackoverflow.com/questions/17613094/wait-on-the-database-engine-recovery-handle-failed-sql-server-2012-installatio">StackOverflow1</a></p> <p><a href="https://stackoverflow.com/questions/12195300/wait-on-the-database-engine-recovery-handle-failed">StackOverflow2</a></p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USCommunity
    1. USroyki
    plurals
    1. PL
      singulars
      1. LTLinked
    2. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. This table or related slice is empty.
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload