About Me

My photo
I am MCSE in Data Management and Analytics with specialization in MS SQL Server and MCP in Azure. I have over 13+ years of experience in IT industry with expertise in data management, Azure Cloud, Data-Canter Migration, Infrastructure Architecture planning and Virtualization and automation. Contact me if you are looking for any sort of guidance in getting your Infrastructure provisioning automated through Terraform. I sometime write for a place to store my own experiences for future search and read by own blog but can hopefully help others along the way. Thanks.

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

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 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.

Ø 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"



Component name: SQL Server Database Engine Services Instance Features Component error code: 0x851A0018 Database Engine Services fail

If you get error in summary.txt as below:

Issue :

From summary.txt
=================================
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: 0x851A0018
Error description: Could not find the Database Engine startup handle.

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: 0x851A0018
Error description: Could not find the Database Engine startup handle.

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: 0x851A0018
Error description: Could not find the Database Engine startup handle.


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.

Ø Please 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"