SQL Server installation failed. Error result: -1035451685 Result facility code: 584 Result error code: 17115

Question

I am endeavouring to install SQL Server Developer 2008R2 having removed the original release but I have seen the installation fail. The error result is -1035451685. I have the logs and have pasted the summary below. I am happy to provide the detail and any other data that helps.

I searched online for the error code but found only a couple of hits but they were in Russian. I would be grateful for your help.

 

Overall summary:
  Final result:                  SQL Server installation failed. To continue, investigate the reason for the failure, correct the problem, uninstall SQL Server, and then rerun SQL Server Setup.
  Exit code (Decimal):           -1035451685
  Exit facility code:            584
  Exit error code:               17115
  Exit message:                  SQL Server installation failed. To continue, investigate the reason for the failure, correct the problem, uninstall SQL Server, and then rerun SQL Server Setup.
  Start time:                    2010-07-22 23:50:21
  End time:                      2010-07-23 08:05:08
  Requested action:              Install
  Log with failure:              C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20100722_234719\Detail.txt
  Exception help link:           http%3a%2f%2fgo.microsoft.com%2ffwlink%3fLinkId%3d20476%26ProdName%3dMicrosoft%2bSQL%2bServer%26EvtSrc%3dsetup.rll%26EvtID%3d50000%26ProdVer%3d10.50.1600.1%26EvtType%3d0xB4A84AA1%400xC24842DB

Machine Properties:
  Machine name:                  PRESARIO
  Machine processor count:       1
  OS version:                    Windows XP
  OS service pack:               Service Pack 3
  OS region:                     United States
  OS language:                   English (United States)
  OS architecture:               x86
  Process architecture:          32 Bit
  OS clustered:                  No

Product features discovered:
  Product              Instance             Instance ID                    Feature                                  Language             Edition              Version         Clustered

Package properties:
  Description:                   SQL Server Database Services 2008 R2
  ProductName:                   SQL Server 2008 R2
  Type:                          RTM
  Version:                       10
  SPLevel:                       0
  Installation location:         C:\Documents and Settings\John Holmes\My Documents\SQLDEV\SQLFULL_ENU\x86\setup\
  Installation edition:          DEVELOPER

User Input Settings:
  ACTION:                        Install
  ADDCURRENTUSERASSQLADMIN:      False
  AGTSVCACCOUNT:                 John Holmes
  AGTSVCPASSWORD:                *****
  AGTSVCSTARTUPTYPE:             Manual
  ASBACKUPDIR:                   Backup
  ASCOLLATION:                   Latin1_General_CI_AS
  ASCONFIGDIR:                   Config
  ASDATADIR:                     Data
  ASDOMAINGROUP:                 <empty>
  ASLOGDIR:                      Log
  ASPROVIDERMSOLAP:              1
  ASSVCACCOUNT:                  <empty>
  ASSVCPASSWORD:                 *****
  ASSVCSTARTUPTYPE:              Automatic
  ASSYSADMINACCOUNTS:            <empty>
  ASTEMPDIR:                     Temp
  BROWSERSVCSTARTUPTYPE:         Disabled
  CONFIGURATIONFILE:             C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20100722_234719\ConfigurationFile.ini
  CUSOURCE:                     
  ENABLERANU:                    False
  ENU:                           True
  ERRORREPORTING:                False
  FARMACCOUNT:                   <empty>
  FARMADMINPORT:                 0
  FARMPASSWORD:                  *****
  FEATURES:                      SQLENGINE,REPLICATION,FULLTEXT,RS,BOL,SSMS,ADV_SSMS
  FILESTREAMLEVEL:               0
  FILESTREAMSHARENAME:           <empty>
  FTSVCACCOUNT:                  John Holmes
  FTSVCPASSWORD:                 *****
  HELP:                          False
  IACCEPTSQLSERVERLICENSETERMS:  False
  INDICATEPROGRESS:              False
  INSTALLSHAREDDIR:              C:\Program Files\Microsoft SQL Server\
  INSTALLSHAREDWOWDIR:           C:\Program Files\Microsoft SQL Server\
  INSTALLSQLDATADIR:             <empty>
  INSTANCEDIR:                   C:\Program Files\Microsoft SQL Server\
  INSTANCEID:                    MSSQLSERVER
  INSTANCENAME:                  MSSQLSERVER
  ISSVCACCOUNT:                  NT AUTHORITY\NetworkService
  ISSVCPASSWORD:                 *****
  ISSVCSTARTUPTYPE:              Automatic
  NPENABLED:                     0
  PASSPHRASE:                    *****
  PCUSOURCE:                    
  PID:                           *****
  QUIET:                         False
  QUIETSIMPLE:                   False
  ROLE:                          <empty>
  RSINSTALLMODE:                 DefaultNativeMode
  RSSVCACCOUNT:                  PRESARIO\John Holmes
  RSSVCPASSWORD:                 *****
  RSSVCSTARTUPTYPE:              Automatic
  SAPWD:                         *****
  SECURITYMODE:                  <empty>
  SQLBACKUPDIR:                  <empty>
  SQLCOLLATION:                  Latin1_General_CI_AS
  SQLSVCACCOUNT:                 John Holmes
  SQLSVCPASSWORD:                *****
  SQLSVCSTARTUPTYPE:             Automatic
  SQLSYSADMINACCOUNTS:           PRESARIO\John Holmes
  SQLTEMPDBDIR:                  <empty>
  SQLTEMPDBLOGDIR:               <empty>
  SQLUSERDBDIR:                  <empty>
  SQLUSERDBLOGDIR:               <empty>
  SQMREPORTING:                  True
  TCPENABLED:                    0
  UIMODE:                        Normal
  X86:                           False

  Configuration file:            C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20100722_234719\ConfigurationFile.ini

Detailed results:
  Feature:                       Database Engine Services
  Status:                        Failed: see logs for details
  MSI status:                    Passed
  Configuration status:          Failed: see details below
  Configuration error code:      0xC24842DB
  Configuration error description: The service did not respond to the start or control request in a timely fashion. 
  Configuration log:             C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20100722_234719\Detail.txt

  Feature:                       SQL Server Replication
  Status:                        Failed: see logs for details
  MSI status:                    Passed
  Configuration status:          Failed: see details below
  Configuration error code:      0xC24842DB
  Configuration error description: The service did not respond to the start or control request in a timely fashion. 
  Configuration log:             C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20100722_234719\Detail.txt

  Feature:                       Full-Text Search
  Status:                        Failed: see logs for details
  MSI status:                    Passed
  Configuration status:          Failed: see details below
  Configuration error code:      0xC24842DB
  Configuration error description: The service did not respond to the start or control request in a timely fashion. 
  Configuration log:             C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20100722_234719\Detail.txt

  Feature:                       Reporting Services
  Status:                        Failed: see logs for details
  MSI status:                    Passed
  Configuration status:          Failed: see details below
  Configuration error code:      0xC24842DB
  Configuration error description: The service did not respond to the start or control request in a timely fashion. 
  Configuration log:             C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20100722_234719\Detail.txt

  Feature:                       Management Tools - Complete
  Status:                        Passed
  MSI status:                    Passed
  Configuration status:          Passed

  Feature:                       Management Tools - Basic
  Status:                        Passed
  MSI status:                    Passed
  Configuration status:          Passed

  Feature:                       SQL Server Books Online
  Status:                        Passed
  MSI status:                    Passed
  Configuration status:          Passed

Rules with failures:

Global rules:

Scenario specific rules:

Rules report file:               C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20100722_234719\SystemConfigurationCheck_Report.htm

 

Answer 1

Extract from Detail_ComponentUpdate.txt

 

2010-07-22 23:50:16 Slp: Running Action: PostMsiTimingConfigAction
2010-07-22 23:50:16 Slp: The object state property 'workflow' is null/empty.
2010-07-22 23:50:16 Slp: Error: Action "PostMsiTimingConfigAction" failed during execution.
2010-07-22 23:50:16 Slp: Completed Action: PostMsiTimingConfigAction, returned False
2010-07-22 23:50:16 Slp: Completed Action: ExecuteStandardTimingsWorkflow, returned True

Is this the failure?

Answer 2

Hi John,

This file needs to be investigated:

C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20100722_234719\Detail.txt

Please look for "at microsoft" and post the relevant lines here

---

Prashant [MSFT] -- This posting is provided "AS IS" with no warranties, and confers no rights.

Answer 3

Thank you, the log from that point is (truncated):

 

 

10-07-23 00:40:08 Slp: The configuration failure category of current exception is ConfigurationFailure
2010-07-23 00:40:08 Slp: Configuration action failed for feature SQL_Engine_Core_Inst during timing ConfigRC and scenario ConfigRC.
2010-07-23 00:40:08 Slp: System.ComponentModel.Win32Exception: The service did not respond to the start or control request in a timely fashion.
2010-07-23 00:40:08 Slp:    at Microsoft.SqlServer.Configuration.Sco.Service.StartService(String[] startParams)
2010-07-23 00:40:08 Slp:    at Microsoft.SqlServer.Configuration.SqlEngine.SqlServerServiceSCM.StartSqlServer(String[] parameters)
2010-07-23 00:40:08 Slp:    at Microsoft.SqlServer.Configuration.SqlEngine.SqlServerStartup.StartSQLServerForInstall(String sqlCollation, String masterFullPath, Boolean isConfiguringTemplateDBs, Boolean isSlipstreamRunning)
2010-07-23 00:40:08 Slp:    at Microsoft.SqlServer.Configuration.SqlEngine.SqlEngineDBStartConfig.ConfigSQLServerSystemDatabases(EffectiveProperties properties, Boolean isConfiguringTemplateDBs, Boolean useInstallInputs)
2010-07-23 00:40:08 Slp:    at Microsoft.SqlServer.Configuration.SqlEngine.SqlEngineDBStartConfig.DoCommonDBStartConfig(ConfigActionTiming timing)
2010-07-23 00:40:08 Slp:    at Microsoft.SqlServer.Configuration.SqlEngine.SqlEngineDBStartConfig.Install(ConfigActionTiming timing, Dictionary`2 actionData, PublicConfigurationBase spcb)
2010-07-23 00:40:08 Slp:    at Microsoft.SqlServer.Configuration.SqlConfigBase.PrivateConfigurationBase.Execute(ConfigActionScenario scenario, ConfigActionTiming timing, ConfigBaseAction action, Dictionary`2 actionData, PublicConfigurationBase spcbCurrent)
2010-07-23 00:40:08 Slp:    at Microsoft.SqlServer.Configuration.SqlConfigBase.SqlFeatureConfigBase.Execute(ConfigActionScenario scenario, ConfigActionTiming timing, ConfigBaseAction action, Dictionary`2 actionData, PublicConfigurationBase spcbCurrent)
2010-07-23 00:40:08 Slp:    at Microsoft.SqlServer.Configuration.SqlConfigBase.SlpConfigAction.ExecuteAction(String actionId)
2010-07-23 00:40:08 Slp:    at Microsoft.SqlServer.Configuration.SqlConfigBase.SlpConfigAction.Execute(String actionId, TextWriter errorStream)
2010-07-23 00:40:08 Slp: Exception: System.ComponentModel.Win32Exception.
2010-07-23 00:40:08 Slp: Source: Microsoft.SqlServer.Configuration.Sco.
2010-07-23 00:40:08 Slp: Message: The service did not respond to the start or control request in a timely fashion.
2010-07-23 00:40:08 Slp: Watson Bucket 1
 Original Parameter Values

2010-07-23 00:40:08 Slp: Parameter 0 : SQL Server 2008 R2@RTM@

2010-07-23 00:40:08 Slp: Parameter 1 : Microsoft.SqlServer.Configuration.Sco.Service.StartService

2010-07-23 00:40:08 Slp: Parameter 2 : Microsoft.SqlServer.Configuration.Sco.Service.StartService

2010-07-23 00:40:08 Slp: Parameter 3 : System.ComponentModel.Win32Exception@-2147467259

2010-07-23 00:40:08 Slp: Parameter 4 : System.ComponentModel.Win32Exception@-2147467259

2010-07-23 00:40:08 Slp: Parameter 5 : SqlEngineDBStartConfigAction_install_configrc

2010-07-23 00:40:08 Slp: Parameter 6 : INSTALL@CONFIGRC@SQL_ENGINE_CORE_INST

2010-07-23 00:40:08 Slp:
 Final Parameter Values

2010-07-23 00:40:08 Slp: Parameter 0 : SQL Server 2008 R2@RTM@

2010-07-23 00:40:08 Slp: Parameter 1 : 0xB4A84AA1

2010-07-23 00:40:08 Slp: Parameter 2 : 0xB4A84AA1

2010-07-23 00:40:08 Slp: Parameter 3 : 0xC24842DB

2010-07-23 00:40:08 Slp: Parameter 4 : 0xC24842DB

2010-07-23 00:40:08 Slp: Parameter 5 : SqlEngineDBStartConfigAction_install_configrc

2010-07-23 00:40:08 Slp: Parameter 6 : 0x9396DE01

2010-07-23 00:40:13 Slp: Sco: Attempting to write hklm registry key SOFTWARE\Microsoft\Microsoft SQL Server to file C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20100722_234719\Registry_SOFTWARE_Microsoft_Microsoft SQL Server.reg_
2010-07-23 00:40:14 Slp: Sco: Attempting to write hklm registry key SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall to file C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20100722_234719\Registry_SOFTWARE_Microsoft_Windows_CurrentVersion_Uninstall.reg_
2010-07-23 00:40:14 Slp: Sco: Attempting to write hklm registry key SOFTWARE\Microsoft\MSSQLServer to file C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20100722_234719\Registry_SOFTWARE_Microsoft_MSSQLServer.reg_
2010-07-23 00:42:43 Slp: The service did not respond to the start or control request in a timely fashion.

2010-07-23 00:42:44 Slp: Watson bucket for exception based failure has been created
2010-07-23 08:04:43 Slp: .Error: Action "SqlEngineDBStartConfigAction_install_configrc_Cpu32" failed during execution.
2010-07-23 08:04:43 Slp: Completed Action: SqlEngineDBStartConfigAction_install_configrc_Cpu32, returned False
2010-07-23 08:04:43 Slp: Sco: Attempting to get instance feature flag UpgradeIncomplete for feature SQL_Engine_Core_Inst, instance MSSQL10_50.MSSQLSERVER, machine name PRESARIO
2010-07-23 08:04:43 Slp: Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE, machine PRESARIO
2010-07-23 08:04:43 Slp: Sco: Attempting to open registry subkey
2010-07-23 08:04:43 Slp: Sco: Attempting to open registry subkey SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\UpgradeIncompleteState
2010-07-23 08:04:43 Slp: Sco: Attempting to get registry value SQL_Engine_Core_Inst
2010-07-23 08:04:43 Slp: Sco: Attempting to get feature configuration state for feature SQL_Engine_Core_Inst, instance MSSQL10_50.MSSQLSERVER
2010-07-23 08:04:43 Slp: Sco: Attempting to get instance feature flag ConfigurationState for feature SQL_Engine_Core_Inst, instance MSSQL10_50.MSSQLSERVER, machine name PRESARIO
2010-07-23 08:04:43 Slp: Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE, machine PRESARIO
2010-07-23 08:04:43 Slp: Sco: Attempting to open registry subkey
2010-07-23 08:04:43 Slp: Sco: Attempting to open registry subkey SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\ConfigurationState
2010-07-23 08:04:43 Slp: Sco: Attempting to get registry value SQL_Engine_Core_Inst
2010-07-23 08:04:43 Slp: Sco: Attempting to get instance feature flag UpgradeIncomplete for feature SQL_Engine_Core_Inst, instance MSSQL10_50.MSSQLSERVER, machine name PRESARIO
2010-07-23 08:04:43 Slp: Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE, machine PRESARIO
2010-07-23 08:04:43 Slp: Sco: Attempting to open registry subkey
2010-07-23 08:04:43 Slp: Sco: Attempting to open registry subkey SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\UpgradeIncompleteState
2010-07-23 08:04:43 Slp: Sco: Attempting to get registry value SQL_Engine_Core_Inst
2010-07-23 08:04:43 Slp: Sco: Attempting to get feature configuration state for feature SQL_Engine_Core_Inst, instance MSSQL10_50.MSSQLSERVER

Answer 4

Hi,

Since you removed an existing SQL Server installation before installing SQL Server 2008 R2, the error might be caused by the leftover previous SQL Server installation. I suggest you uninstall the existing SQL Server instance by the following steps:
1. Make sure you have administrative rights on the computer
2. Uninstall the existing SQL Server 2008 and all the components from the control panel. Remember to backup the user databases before uninstalling SQL Server.
3. Backup the registry.
4. Delete the following keys in regedit:
--HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server
--HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer
5.  Go to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall  and delete all the sub-keys referencing SQL Server.
6.  Go to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services and delete all the keys referencing SQL Server.
7.  Rename all the SQL Server folders in the computer.
8. Try the steps in the “If you experience problems” section and “Step 3: Uninstall the support components” section from:
http://support.microsoft.com/kb/909967
9. Reboot the machine.
10. Reinstall SQL Server 2008 R2.

If you have any more questions, please let me know.
Thanks.

---

***Xiao Min Tan***Microsoft Online Community***

Answer 5

2010-07-23 00:40:08 Slp: Message: The service did not respond to the start or control request in a timely fashion.

Hi John,

The failure seem to have occurred while installer was trying to start SQL services. The ERRORLOG  file would give more details as why the services failed to start. Can you please post the contents of this file?

---

Prashant [MSFT] -- This posting is provided "AS IS" with no warranties, and confers no rights.

Answer 6

Thanks Prashant and Xiao Min tan,

I followed Xiao Min Tan's instructions and found that there were rogue registry entries that had not been removed after previous uninstalls so I deleted them and reran the installation. There was a further error signified by Exit Code -733426222 Exit Facility Code 1096 and error code 52690 but these apply to Analysis Services that I do not require. I removed that as well as some other features that are not needed and I feel that I've got the installation sorted at last.

 

Thank you for your interest and especially the advice that enabled me to complete the installation.

Answer 7

Hi,

I have removed all registeries values as mentioned above and removed all folders too and made sure that all sql components were got removed from unsitall programs then also i am unable to install sql server 2k8 R2 and i am getting below errro messages again and again like below:

011-04-04 12:07:03 Slp: Running Action: PreMsiTimingConfigAction
2011-04-04 12:07:03 Slp: The object state property 'workflow' is null/empty.
2011-04-04 12:07:03 Slp: Error: Action "PreMsiTimingConfigAction" failed during execution.
2011-04-04 12:07:03 Slp: Completed Action: PreMsiTimingConfigAction, returned False

2011-04-04 12:07:05 Slp: Running Action: PostMsiTimingConfigAction
2011-04-04 12:07:05 Slp: The object state property 'workflow' is null/empty.
2011-04-04 12:07:05 Slp: Error: Action "PostMsiTimingConfigAction" failed during execution.
2011-04-04 12:07:05 Slp: Completed Action: PostMsiTimingConfigAction, returned False
2011-04-04 12:07:05 Slp: Completed Action: ExecuteStandardTimingsWorkflow, returned True

My id: [e-mail], if you hapen to know any pointers here please share the solutions.

Thanks for help!!

Santosh Singh

 

 

Answer 8

Just to add above info: i am installing sql server 2k8 R2 on Window Server 2k8 R2.

 

Thanks,

Answer 9

Hello,

Please see the following resource:

http://msdn.microsoft.com/en-us/library/aa337087.aspx

Hope this helps.

Regards,

Alberto Morillo
SQLCoffee.com

Answer 10

I just want to re-install SQL Server 2008 R2. But I only get as far as the Setup Support Files step in the wizard.

When I click the Install button,some actions are performed then the installer just disappears with no message or anything else.

Problem :http://social.msdn.microsoft.com/Forums/en-US/sqlsetupandupgrade/thread/3dcf8991-c778-485a-beba-a3806f5f211b/

Solution: http://social.msdn.microsoft.com/Forums/en/sqlsetupandupgrade/thread/62f0cd6b-bf78-46e0-b513-1556c0866241

I find that some components need to be uninstalled. As follow:

Microsoft Sync Framework Runtime v1.0(x64)

Microsoft Sync Services for ADO.NET v2.0(x64)

I uninstall these components,then I re-install SQL Server 2008 R2.

It works ok!

Thanks.