Tips for finding Knowledge Articles

  • - Enter just a few key words related to your question or problem
  • - Add Key words to refine your search as necessary
  • - Do not use punctuation
  • - Search is not case sensitive
  • - Avoid non-descriptive filler words like "how", "the", "what", etc.
  • - If you do not find what you are looking for the first time,reduce the number of key words you enter and try searching again.
  • - Minimum supported Internet Explorer version is IE9
Home  >
article

KB-8172: Error installing sql express with Reporting Services Wizard

Centrify DirectControl ,  

23 March,17 at 09:48 PM

Applies to: Centrify Reporting Service All Versions with SQL Server 2008 R2 Express Edition


Problem:

Getting the following error message when running the installation wizard for Centrify Reporting Services:

 
The Centrify Report Services Configuration Wizard cannot be completed due to an error that occurred:

The program was unable to install SQL Server on this computer, exit code: 0x851A0017. Please refer to the Centrify Knowledge Base article (KB-4589) for more information on the error code you received. Please fix the issue and run Setup again.


Snippet from the sql server log (C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\<some_number>\Detail.txt):
 
2017-01-25 12:41:31 Slp: Configuration action failed for feature SQL_Engine_Core_Inst during timing ConfigRC and scenario ConfigRC.
2017-01-25 12:41:31 Slp: Could not find the Database Engine startup handle.
2017-01-25 12:41:31 Slp: The configuration failure category of current exception is ConfigurationFailure
2017-01-25 12:41:31 Slp: Configuration action failed for feature SQL_Engine_Core_Inst during timing ConfigRC and scenario ConfigRC.
2017-01-25 12:41:31 Slp: Microsoft.SqlServer.Configuration.SqlEngine.SqlEngineConfigException: Could not find the Database Engine startup handle.
2017-01-25 12:41:31 Slp: at Microsoft.SqlServer.Configuration.SqlEngine.SqlServerServiceBase.WaitSqlServerStart(Process processSql)
2017-01-25 12:41:31 Slp: at Microsoft.SqlServer.Configuration.SqlEngine.SqlEngineDBStartConfig.ConfigSQLServerSystemDatabases(EffectiveProperties properties, Boolean isConfiguringTemplateDBs, Boolean useInstallInputs)
2017-01-25 12:41:31 Slp: at Microsoft.SqlServer.Configuration.SqlEngine.SqlEngineDBStartConfig.DoCommonDBStartConfig(ConfigActionTiming timing)
2017-01-25 12:41:31 Slp: at Microsoft.SqlServer.Configuration.SqlConfigBase.SlpConfigAction.ExecuteAction(String actionId)
2017-01-25 12:41:31 Slp: at Microsoft.SqlServer.Configuration.SqlConfigBase.SlpConfigAction.Execute(String actionId, TextWriter errorStream)
2017-01-25 12:41:31 Slp: Exception: Microsoft.SqlServer.Configuration.SqlEngine.SqlEngineConfigException.
2017-01-25 12:41:31 Slp: Source: Microsoft.SqlServer.Configuration.SqlServer_ConfigExtension.
2017-01-25 12:41:31 Slp: Message: Could not find the Database Engine startup handle..


Cause:

In this scenario, TLS1.0/1.1, SSL 3.0 protocols and some ciphers had been disabled on the server due to customer security concerns.

SQL Server 2008 R2 Express Edition does not support the newer version of cipher suites (i.e. TLS1.2 with SHA256), while the regular versions of SQL Server with the latest updates or support packs (SP) do.

Hence, SQL Server Express Edition was not able to use the encryptions being provided by the server.


Resolution:

After restoring those server settings to the system defaults (ie. allowing TLS1.0/1.1, SSL 3.0 protocols and ciphers),  the Reporting Services installation wizard was able to complete successfully.

Still have questions? Click here to log a technical support case, or collaborate with your peers in Centrify's Online Community.