Could not find the Database Engine startup handle", 0x851A0018) and in details.txt "-SqlServerServiceSCM: Wait for creation of event handle 'Global\sqlserverRecComplete' has timed out
if error in Detail.txt
==================================
==================================
.....
.....
(01) 2013-08-15 00:01:21 SQLEngine: : Checking Engine checkpoint 'StartEngineService'
(01) 2013-08-15 00:01:21 SQLEngine: --SqlServerServiceSCM: Starting SQL via SCM (-mSqlSetup -Q -qSQL_Latin1_General_CP1_CI_AS -T4022 -T4010 -T3659 -T3610 -T8015)...
(01) 2013-08-15 00:01:21 Slp: Sco: Attempting to start service MSSQLSERVER
(01) 2013-08-15 00:01:21 Slp: Sco: Attempting to open SC Manager
(01) 2013-08-15 00:01:21 Slp: Sco: Attempting to open service handle for service MSSQLSERVER
(01) 2013-08-15 00:01:24 Slp: Sco: Service MSSQLSERVER started
(01) 2013-08-15 00:01:24 Slp: Sco: Attempting to close service handle for service MSSQLSERVER
(01) 2013-08-15 00:01:24 Slp: Sco: Attempting to close SC Manager
(01) 2013-08-15 00:01:24 SQLEngine: --SqlServerServiceSCM: Started Engine service successfully
(01) 2013-08-15 00:01:24 Slp: Sco: Attempting to get service process id for service MSSQLSERVER
(01) 2013-08-15 00:01:24 Slp: Sco: Attempting to open SC Manager
(01) 2013-08-15 00:01:24 Slp: Sco: Attempting to open service handle for service MSSQLSERVER
(01) 2013-08-15 00:01:24 Slp: Invoking QueryServiceStatusEx Win32 API
(01) 2013-08-15 00:01:24 Slp: Sco: Attempting to close service handle for service MSSQLSERVER
(01) 2013-08-15 00:01:24 Slp: Sco: Attempting to close SC Manager
(01) 2013-08-15 00:01:24 Slp: Sco: Returning service process id 1352
(01) 2013-08-15 00:01:24 SQLEngine: : Checking Engine checkpoint 'GetSqlServerProcessHandle'
(01) 2013-08-15 00:01:24 SQLEngine: --SqlServerServiceSCM: Waiting for nt event 'Global\sqlserverRecComplete' to be created
(01) 2013-08-15 00:04:27 SQLEngine: --SqlServerServiceSCM: Wait for creation of event handle 'Global\sqlserverRecComplete' has timed out
(01) 2013-08-15 00:04:27 SQLEngine: Copying 'C:\MSSQL11.MSSQLSERVER\MSSQL\Log\ERRORLOG' to 'C:\Program Files\Microsoft SQL Server\110\Setup Bootstrap\Log\20130814_234119\SQLServer_ERRORLOG_2013-08-15T00.04.27.txt' ...
(01) 2013-08-15 00:04:27 Slp: Sco: File 'C:\MSSQL11.MSSQLSERVER\MSSQL\Log\ERRORLOG' does not exist
(01) 2013-08-15 00:04:27 SQLEngine: Could not copy non-existant SQL Server Error Log: C:\MSSQL11.MSSQLSERVER\MSSQL\Log\ERRORLOG
(01) 2013-08-15 00:04:27 Slp: Configuration action failed for feature SQL_Engine_Core_Inst during timing ConfigRC and scenario ConfigRC.
(01) 2013-08-15 00:04:27 Slp: Could not find the Database Engine startup handle.
(01) 2013-08-15 00:04:27 Slp: The configuration failure category of current exception is ConfigurationFailure
(01) 2013-08-15 00:04:27 Slp: Configuration action failed for feature SQL_Engine_Core_Inst during timing ConfigRC and scenario ConfigRC.
(01) 2013-08-15 00:04:27 Slp: Microsoft.SqlServer.Configuration.SqlEngine.SqlEngineConfigException: Could not find the Database Engine startup handle.
(01) 2013-08-15 00:04:27 Slp: at Microsoft.SqlServer.Configuration.SqlEngine.SqlServerServiceBase.WaitSqlServerStart(Process processSql)
(01) 2013-08-15 00:04:27 Slp: at Microsoft.SqlServer.Configuration.SqlEngine.SqlServerServiceSCM.StartSqlServer(String[] parameters)
(01) 2013-08-15 00:04:27 Slp: at Microsoft.SqlServer.Configuration.SqlEngine.SqlEngineDBStartConfig.ConfigSQLServerSystemDatabases(EffectiveProperties properties, Boolean isConfiguringTemplateDBs, Boolean useInstallInputs)
(01) 2013-08-15 00:04:27 Slp: at Microsoft.SqlServer.Configuration.SqlEngine.SqlEngineDBStartConfig.DoCommonDBStartConfig(ConfigActionTiming timing)
(01) 2013-08-15 00:04:27 Slp: at Microsoft.SqlServer.Configuration.SqlConfigBase.SlpConfigAction.ExecuteAction(String actionId)
(01) 2013-08-15 00:04:27 Slp: at Microsoft.SqlServer.Configuration.SqlConfigBase.SlpConfigAction.Execute(String actionId, TextWriter errorStream)
(01) 2013-08-15 00:04:27 Slp: The following is an exception stack listing the exceptions in outermost to innermost order
(01) 2013-08-15 00:04:27 Slp: Inner exceptions are being indented
(01) 2013-08-15 00:04:27 Slp:
(01) 2013-08-15 00:04:27 Slp: Exception type: Microsoft.SqlServer.Configuration.SqlEngine.SqlEngineConfigException
(01) 2013-08-15 00:04:27 Slp: Message:
(01) 2013-08-15 00:04:27 Slp: Could not find the Database Engine startup handle.
(01) 2013-08-15 00:04:27 Slp: HResult : 0x851a0018
(01) 2013-08-15 00:04:27 Slp: FacilityCode : 1306 (51a)
(01) 2013-08-15 00:04:27 Slp: ErrorCode : 24 (0018)
(01) 2013-08-15 00:04:27 Slp: Data:
(01) 2013-08-15 00:04:27 Slp: SQL.Setup.FailureCategory = ConfigurationFailure
(01) 2013-08-15 00:04:27 Slp: WatsonConfigActionData = INSTALL@CONFIGRC@SQL_ENGINE_CORE_INST
(01) 2013-08-15 00:04:27 Slp: WatsonExceptionFeatureIdsActionData = System.String[]
(01) 2013-08-15 00:04:27 Slp: Stack:
(01) 2013-08-15 00:04:27 Slp: at Microsoft.SqlServer.Configuration.SqlEngine.SqlServerServiceBase.WaitSqlServerStart(Process processSql)
(01) 2013-08-15 00:04:27 Slp: at Microsoft.SqlServer.Configuration.SqlEngine.SqlServerServiceSCM.StartSqlServer(String[] parameters)
(01) 2013-08-15 00:04:27 Slp: at Microsoft.SqlServer.Configuration.SqlEngine.SqlEngineDBStartConfig.ConfigSQLServerSystemDatabases(EffectiveProperties properties, Boolean isConfiguringTemplateDBs, Boolean useInstallInputs)
(01) 2013-08-15 00:04:27 Slp: at Microsoft.SqlServer.Configuration.SqlEngine.SqlEngineDBStartConfig.DoCommonDBStartConfig(ConfigActionTiming timing)
(01) 2013-08-15 00:04:27 Slp: at Microsoft.SqlServer.Configuration.SqlConfigBase.SlpConfigAction.ExecuteAction(String actionId)
(01) 2013-08-15 00:04:27 Slp: at Microsoft.SqlServer.Configuration.SqlConfigBase.SlpConfigAction.Execute(String actionId, TextWriter errorStream)
(01) 2013-08-15 00:04:27 Slp: Watson Bucket 1
Original Parameter Values
(01) 2013-08-15 00:04:27 Slp: Parameter 0 : SQL Server 2012@RTM@
(01) 2013-08-15 00:04:27 Slp: Parameter 1 : Microsoft.SqlServer.Configuration.SqlEngine.SqlServerServiceBase.WaitSqlServerStart
(01) 2013-08-15 00:04:27 Slp: Parameter 2 : Microsoft.SqlServer.Configuration.SqlEngine.SqlServerServiceBase.WaitSqlServerStart
(01) 2013-08-15 00:04:27 Slp: Parameter 3 : Microsoft.SqlServer.Configuration.SqlEngine.SqlEngineConfigException@1306@24
(01) 2013-08-15 00:04:27 Slp: Parameter 4 : Microsoft.SqlServer.Configuration.SqlEngine.SqlEngineConfigException@1306@24
(01) 2013-08-15 00:04:27 Slp: Parameter 5 : SqlEngineDBStartConfigAction_install_configrc
(01) 2013-08-15 00:04:27 Slp: Parameter 6 : INSTALL@CONFIGRC@SQL_ENGINE_CORE_INST
(01) 2013-08-15 00:04:27 Slp:
Final Parameter Values
(01) 2013-08-15 00:04:27 Slp: Parameter 0 : SQL Server 2012@RTM@
(01) 2013-08-15 00:04:27 Slp: Parameter 1 : 0xD15B4EB2
(01) 2013-08-15 00:04:27 Slp: Parameter 2 : 0xD15B4EB2
(01) 2013-08-15 00:04:27 Slp: Parameter 3 : 0x4BDAF9BA@1306@24
(01) 2013-08-15 00:04:27 Slp: Parameter 4 : 0x4BDAF9BA@1306@24
(01) 2013-08-15 00:04:27 Slp: Parameter 5 : SqlEngineDBStartConfigAction_install_configrc
(01) 2013-08-15 00:04:27 Slp: Parameter 6 : 0x9C5770A6
Resolution
Ø For error:- "Could not find the Database Engine startup handle", 0x851A0018, we have the following documentation:- http://support.microsoft.com/kb/2449398 (which is for SQL 2008 R2, however, stands true for SQL 2012 instances as well.)
From the above document, we understand that this problem may occur for one of the following reasons:
• The installation media is damaged.
• The installation source is corrupted.
Ø Plan:-
- We need to download the media again.
- Copy SQL Server media (.ISO) to a local disk drive copy, uncompress it with WinRAR (do not use WinZIP), and run setup from there. (You can verify is the media is valid using link provided below.)
- Make sure the setup account and the service accounts have the required privileges.
(Use http://technet.microsoft.com/en-us/library/cc281953(v=sql.120).aspx and http://technet.microsoft.com/en-us/library/cc281953(v=sql.120).aspx )
Ø You can go through the following links:-
- http://thesqldude.com/tag/could-not-find-the-database-engine-startup-handle/ : "SQL Server Setup: How to validate downloaded image/media before installation"
- http://support.microsoft.com/kb/2449398 : "Error message when you try to install SQL Server 2008 R2"
