none
Sql 2008 R2 SP1 will not install

    Question

  • Here is the log for sql 2008 r2 sp1  -- this one returns SQL Server setup has encountered the following error  c:\windows\installer\6052cd.msi

     

     I also have a sql and 3 visual studio updatees that will not install -  kb2494088, kb2669970, kb972222, kb2251487 (code: 645   code: 84bc-64c)

    2012-06-06 12:59:57 Slp: Error: Action "Microsoft.SqlServer.Configuration.SetupExtension.InitializeUIDataAction" threw an exception during execution.
    2012-06-06 12:59:57 Slp: Microsoft.SqlServer.Setup.Chainer.Workflow.ActionExecutionException: C:\Windows\Installer\6052cd.msi ---> System.IO.FileNotFoundException: C:\Windows\Installer\6052cd.msi
    2012-06-06 12:59:57 Slp:    at Microsoft.SqlServer.Chainer.Infrastructure.MsiNativeMethodHelpers.GetDBProperty(ServiceContainer context, String pathToMsi, String propertyName)
    2012-06-06 12:59:57 Slp:    at Microsoft.SqlServer.Configuration.MsiExtension.SetPatchInstallStateAction.GetMsiRtmVersion(PackageInstallProperty targetPackage)
    2012-06-06 12:59:57 Slp:    at Microsoft.SqlServer.Configuration.MsiExtension.SetPatchInstallStateAction.IsApplicablePatch(PatchProperty currentPatch, PackageInstallProperty targetPackage)
    2012-06-06 12:59:57 Slp:    at Microsoft.SqlServer.Configuration.MsiExtension.SetPatchInstallStateAction.ExecuteAction(String actionId)
    2012-06-06 12:59:57 Slp:    at Microsoft.SqlServer.Configuration.MsiExtension.ProductInstallProperty.GetInstalledPackages(String instanceName, List`1& installedInstancePackages, List`1& installedSharedPackages, String& returnedErrorMessage)
    2012-06-06 12:59:57 Slp:    at Microsoft.SqlServer.Configuration.MsiExtension.ProductInstallProperty.CollectProductData()
    2012-06-06 12:59:57 Slp:    at Microsoft.SqlServer.Configuration.FeatureTreeConfigurationBase.LoadFeatureTreeDefinitionAllInstances()
    2012-06-06 12:59:57 Slp:    at Microsoft.SqlServer.Configuration.PatchFeatureTree.InitializePatchFeatureTree(ServiceContainer context)
    2012-06-06 12:59:57 Slp:    at Microsoft.SqlServer.Configuration.SetupExtension.InitializeUIDataAction.ExecuteAction(String actionId)
    2012-06-06 12:59:57 Slp:    at Microsoft.SqlServer.Chainer.Infrastructure.Action.Execute(String actionId, TextWriter errorStream)
    2012-06-06 12:59:57 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.ExecuteActionHelper(TextWriter statusStream, ISequencedAction actionToRun)
    2012-06-06 12:59:57 Slp:    --- End of inner exception stack trace ---
    2012-06-06 12:59:57 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.ExecuteActionHelper(TextWriter statusStream, ISequencedAction actionToRun)
    2012-06-06 12:59:57 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.ExecuteActionWithRetryHelper(WorkflowObject metaDb, ActionKey action, ActionMetadata actionMetadata, TextWriter statusStream)
    2012-06-06 12:59:57 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.InvokeAction(WorkflowObject metabase, TextWriter statusStream)
    2012-06-06 12:59:57 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.PendingActions.InvokeActions(WorkflowObject metaDb, TextWriter loggingStream)
    2012-06-06 12:59:57 Slp: Received request to add the following file to Watson reporting: C:\Users\hchihs\AppData\Local\Temp\2\tmp3B6C.tmp
    2012-06-06 12:59:57 Slp: The following is an exception stack listing the exceptions in outermost to innermost order
    2012-06-06 12:59:57 Slp: Inner exceptions are being indented
    2012-06-06 12:59:57 Slp:
    2012-06-06 12:59:57 Slp: Exception type: System.IO.FileNotFoundException
    2012-06-06 12:59:57 Slp:     Message:
    2012-06-06 12:59:57 Slp:         C:\Windows\Installer\6052cd.msi
    2012-06-06 12:59:57 Slp:     Stack:
    2012-06-06 12:59:57 Slp:         at Microsoft.SqlServer.Chainer.Infrastructure.MsiNativeMethodHelpers.GetDBProperty(ServiceContainer context, String pathToMsi, String propertyName)
    2012-06-06 12:59:57 Slp:         at Microsoft.SqlServer.Configuration.MsiExtension.SetPatchInstallStateAction.GetMsiRtmVersion(PackageInstallProperty targetPackage)
    2012-06-06 12:59:57 Slp:         at Microsoft.SqlServer.Configuration.MsiExtension.SetPatchInstallStateAction.IsApplicablePatch(PatchProperty currentPatch, PackageInstallProperty targetPackage)
    2012-06-06 12:59:57 Slp:         at Microsoft.SqlServer.Configuration.MsiExtension.SetPatchInstallStateAction.ExecuteAction(String actionId)
    2012-06-06 12:59:57 Slp:         at Microsoft.SqlServer.Configuration.MsiExtension.ProductInstallProperty.GetInstalledPackages(String instanceName, List`1& installedInstancePackages, List`1& installedSharedPackages, String& returnedErrorMessage)
    2012-06-06 12:59:57 Slp:         at Microsoft.SqlServer.Configuration.MsiExtension.ProductInstallProperty.CollectProductData()
    2012-06-06 12:59:57 Slp:         at Microsoft.SqlServer.Configuration.FeatureTreeConfigurationBase.LoadFeatureTreeDefinitionAllInstances()
    2012-06-06 12:59:57 Slp:         at Microsoft.SqlServer.Configuration.PatchFeatureTree.InitializePatchFeatureTree(ServiceContainer context)
    2012-06-06 12:59:57 Slp:         at Microsoft.SqlServer.Configuration.SetupExtension.InitializeUIDataAction.ExecuteAction(String actionId)
    2012-06-06 12:59:57 Slp:         at Microsoft.SqlServer.Chainer.Infrastructure.Action.Execute(String actionId, TextWriter errorStream)
    2012-06-06 12:59:57 Slp:         at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.ExecuteActionHelper(TextWriter statusStream, ISequencedAction actionToRun)
    2012-06-06 13:00:02 Slp: Watson Bucket 1
     Original Parameter Values

    2012-06-06 13:00:02 Slp: Parameter 0 : SQL2008@RTM@KB2528583

    2012-06-06 13:00:02 Slp: Parameter 1 : Microsoft.SqlServer.Chainer.Infrastructure.MsiNativeMethodHelpers.GetDBProperty

    2012-06-06 13:00:02 Slp: Parameter 2 : Microsoft.SqlServer.Chainer.Infrastructure.MsiNativeMethodHelpers.GetDBProperty

    2012-06-06 13:00:02 Slp: Parameter 3 : System.IO.FileNotFoundException@-2147024894

    2012-06-06 13:00:02 Slp: Parameter 4 : System.IO.FileNotFoundException@-2147024894

    2012-06-06 13:00:02 Slp: Parameter 5 : InitializeUIDataAction

    2012-06-06 13:00:02 Slp:
     Final Parameter Values

    2012-06-06 13:00:02 Slp: Parameter 0 : SQL2008@RTM@KB2528583

    2012-06-06 13:00:02 Slp: Parameter 1 : 0xFE9E43A7

    2012-06-06 13:00:02 Slp: Parameter 2 : 0xFE9E43A7

    2012-06-06 13:00:02 Slp: Parameter 3 : 0xB7EAF00B

    2012-06-06 13:00:02 Slp: Parameter 4 : 0xB7EAF00B

    2012-06-06 13:00:02 Slp: Parameter 5 : InitializeUIDataAction

    2012-06-06 13:00:03 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\20120606_125943\Registry_SOFTWARE_Microsoft_Microsoft SQL Server.reg_
    2012-06-06 13:00:03 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\20120606_125943\Registry_SOFTWARE_Microsoft_Windows_CurrentVersion_Uninstall.reg_
    2012-06-06 13:00:03 Slp: Sco: Attempting to write hklm registry key SOFTWARE\Microsoft\MSSQLServer to file C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20120606_125943\Registry_SOFTWARE_Microsoft_MSSQLServer.reg_
    2012-06-06 13:00:03 Slp: Sco: Attempting to write hklm registry key SOFTWARE\Wow6432Node\Microsoft\Microsoft SQL Server to file C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20120606_125943\Registry_SOFTWARE_Wow6432Node_Microsoft_Microsoft SQL Server.reg_
    2012-06-06 13:00:03 Slp: Sco: Attempting to write hklm registry key SOFTWARE\Wow6432Node\Microsoft\Windows\CurrentVersion\Uninstall to file C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20120606_125943\Registry_SOFTWARE_Wow6432Node_Microsoft_Windows_CurrentVersion_Uninstall.reg_
    2012-06-06 13:00:03 Slp: Sco: Attempting to write hklm registry key SOFTWARE\Wow6432Node\Microsoft\MSSQLServer to file C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20120606_125943\Registry_SOFTWARE_Wow6432Node_Microsoft_MSSQLServer.reg_
    2012-06-06 13:00:04 Slp: C:\Windows\Installer\6052cd.msi
    2012-06-06 13:00:04 Slp: Watson bucket for exception based failure has been created
    2012-06-06 13:00:04 Slp: Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE, machine
    2012-06-06 13:00:04 Slp: Sco: Attempting to open registry subkey
    2012-06-06 13:00:04 Slp: Sco: Attempting to open registry subkey Software\Microsoft\PCHealth\ErrorReporting\DW\Installed
    2012-06-06 13:00:04 Slp: Sco: Attempting to get registry value DW0201
    2012-06-06 13:00:10 Slp: Submitted 1 of 1 failures to the Watson data repository
    2012-06-06 13:00:10 Slp:
    2012-06-06 13:00:10 Slp: ----------------------------------------------------------------------
    2012-06-06 13:00:10 Slp:
    2012-06-06 13:00:10 Slp: Error result: 1045947921
    2012-06-06 13:00:10 Slp: Result facility code: 1623
    2012-06-06 13:00:10 Slp: Result error code: 58897

    Wednesday, June 06, 2012 7:04 PM

Answers

  • Could you please  check-out work around in below KB article

    http://support.microsoft.com/kb/969052


    Regards,
    Ahmed Ibrahim
    SQL Server Setup Team
    This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you.
    This can be beneficial to other community members reading the thread.

    • Marked as answer by jim_hir0305 Friday, June 08, 2012 7:40 PM
    Wednesday, June 06, 2012 7:25 PM
    Moderator
  •  

    That allowed me to install.  But the update is still showing up in Windows updates.

    When I tried to run it again it told me there are no SQLServer Instances or shraed features that can be updated on this computer?

    I also have 3 Visual studio updates kb2669970, kb972222, kb251487 that show up in windows updates but will not install.  I tried to download them and install them manually and they give me this message

    None of the products that are addressed by this software update are installed on this computer. Click Cancel to exit setup.

    Microsoft SQL Server 2008 R2 SP1 Setup Discovery Report

    Product Instance Instance ID Feature Language Edition Version Clustered
    Sql Server 2008 MSSQLSERVER MSSQL10_50.MSSQLSERVER Database Engine Services 1033 Enterprise Edition 10.51.2500.0 No
    Sql Server 2008 MSSQLSERVER MSSQL10_50.MSSQLSERVER SQL Server Replication 1033 Enterprise Edition 10.51.2500.0 No
    Sql Server 2008 MSSQLSERVER MSSQL10_50.MSSQLSERVER Full-Text Search 1033 Enterprise Edition 10.51.2500.0 No
    Sql Server 2008 MSSQLSERVER MSAS10_50.MSSQLSERVER Analysis Services 1033 Enterprise Edition 10.51.2500.0 No
    Sql Server 2008 MSSQLSERVER MSRS10_50.MSSQLSERVER Reporting Services 1033 Enterprise Edition 10.51.2500.0 No
    Microsoft SQL Server 2008 R2 Management Tools - Basic 1033 Enterprise Edition 10.50.1600.1 No
    Microsoft SQL Server 2008 R2 Management Tools - Complete 1033 Enterprise Edition 10.50.1600.1 No
    Microsoft SQL Server 2008 R2 Client Tools Connectivity 1033 Enterprise Edition 10.50.1600.1 No
    Microsoft SQL Server 2008 R2 Client Tools Backwards Compatibility 1033 Enterprise Edition 10.50.1600.1 No
    Microsoft SQL Server 2008 R2 Client Tools SDK 1033 Enterprise Edition 10.50.1600.1 No
    Microsoft SQL Server 2008 R2 Integration Services 1033 Enterprise Edition 10.50.1600.1 No

    • Marked as answer by jim_hir0305 Friday, June 08, 2012 7:40 PM
    Friday, June 08, 2012 5:52 PM

All replies

  • Could you please  check-out work around in below KB article

    http://support.microsoft.com/kb/969052


    Regards,
    Ahmed Ibrahim
    SQL Server Setup Team
    This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you.
    This can be beneficial to other community members reading the thread.

    • Marked as answer by jim_hir0305 Friday, June 08, 2012 7:40 PM
    Wednesday, June 06, 2012 7:25 PM
    Moderator
  •  

    That allowed me to install.  But the update is still showing up in Windows updates.

    When I tried to run it again it told me there are no SQLServer Instances or shraed features that can be updated on this computer?

    I also have 3 Visual studio updates kb2669970, kb972222, kb251487 that show up in windows updates but will not install.  I tried to download them and install them manually and they give me this message

    None of the products that are addressed by this software update are installed on this computer. Click Cancel to exit setup.

    Microsoft SQL Server 2008 R2 SP1 Setup Discovery Report

    Product Instance Instance ID Feature Language Edition Version Clustered
    Sql Server 2008 MSSQLSERVER MSSQL10_50.MSSQLSERVER Database Engine Services 1033 Enterprise Edition 10.51.2500.0 No
    Sql Server 2008 MSSQLSERVER MSSQL10_50.MSSQLSERVER SQL Server Replication 1033 Enterprise Edition 10.51.2500.0 No
    Sql Server 2008 MSSQLSERVER MSSQL10_50.MSSQLSERVER Full-Text Search 1033 Enterprise Edition 10.51.2500.0 No
    Sql Server 2008 MSSQLSERVER MSAS10_50.MSSQLSERVER Analysis Services 1033 Enterprise Edition 10.51.2500.0 No
    Sql Server 2008 MSSQLSERVER MSRS10_50.MSSQLSERVER Reporting Services 1033 Enterprise Edition 10.51.2500.0 No
    Microsoft SQL Server 2008 R2 Management Tools - Basic 1033 Enterprise Edition 10.50.1600.1 No
    Microsoft SQL Server 2008 R2 Management Tools - Complete 1033 Enterprise Edition 10.50.1600.1 No
    Microsoft SQL Server 2008 R2 Client Tools Connectivity 1033 Enterprise Edition 10.50.1600.1 No
    Microsoft SQL Server 2008 R2 Client Tools Backwards Compatibility 1033 Enterprise Edition 10.50.1600.1 No
    Microsoft SQL Server 2008 R2 Client Tools SDK 1033 Enterprise Edition 10.50.1600.1 No
    Microsoft SQL Server 2008 R2 Integration Services 1033 Enterprise Edition 10.50.1600.1 No

    • Marked as answer by jim_hir0305 Friday, June 08, 2012 7:40 PM
    Friday, June 08, 2012 5:52 PM
  • May be the update is already installed as part of sql server, can upu go to add remove program and make sure that the update is not already installed ?

    Regards,
    Ahmed Ibrahim
    SQL Server Setup Team
    This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you.
    This can be beneficial to other community members reading the thread.

    Friday, June 08, 2012 7:43 PM
    Moderator
  • I finally got the SP 1 to install.   I checked and the Visual Studio updates do not appear to be installed under add/remove programs.

    They fail with a 645 error code.  I downloaded the patch and tried to install manually and when I try to install I get

     

    None of the products that are addressed by this software update are installed on this computer. Click Cancel to exit setup.

    Here are the installed versions of SQL and Visual Studio.

    Microsoft SQL Server 2008 R2 SP1 Setup Discovery Report

    Product

    Instance

    Instance ID

    Feature

    Language

    Edition

    Version

    Clustered

    Sql Server 2008

    MSSQLSERVER

    MSSQL10_50.MSSQLSERVER

    Database Engine Services

    1033

    Enterprise Edition

    10.51.2500.0

    No

    Sql Server 2008

    MSSQLSERVER

    MSSQL10_50.MSSQLSERVER

    SQL Server Replication

    1033

    Enterprise Edition

    10.51.2500.0

    No

    Sql Server 2008

    MSSQLSERVER

    MSSQL10_50.MSSQLSERVER

    Full-Text Search

    1033

    Enterprise Edition

    10.51.2500.0

    No

    Sql Server 2008

    MSSQLSERVER

    MSAS10_50.MSSQLSERVER

    Analysis Services

    1033

    Enterprise Edition

    10.51.2500.0

    No

    Sql Server 2008

    MSSQLSERVER

    MSRS10_50.MSSQLSERVER

    Reporting Services

    1033

    Enterprise Edition

    10.51.2500.0

    No

    Sql Server 2008

    Management Tools - Basic

    1033

    Enterprise Edition

    10.51.2500.0

    No

    Sql Server 2008

    Management Tools - Complete

    1033

    Enterprise Edition

    10.51.2500.0

    No

    Sql Server 2008

    Client Tools Connectivity

    1033

    Enterprise Edition

    10.51.2500.0

    No

    Sql Server 2008

    Client Tools Backwards Compatibility

    1033

    Enterprise Edition

    10.51.2500.0

    No

    Sql Server 2008

    Client Tools SDK

    1033

    Enterprise Edition

    10.51.2500.0

    No

    Sql Server 2008

    Integration Services

    1033

    Enterprise Edition

    10.51.2500.0

    No

    Microsoft Visual Studio 2008

    Version 9.0.30729.4462 QFE

    Microsoft .NET Framework

    Version 3.5 SP1

    Installed Edition: IDE Standard

    Hotfix for Microsoft Visual Studio 2008 Shell (integrated mode) - ENU (KB945282)   KB945282

    This hotfix is for Microsoft Visual Studio 2008 Shell (integrated mode) - ENU.

    If you later install a more recent service pack, this hotfix will be uninstalled automatically.

    For more information, visit http://support.microsoft.com/kb/945282.

    Hotfix for Microsoft Visual Studio 2008 Shell (integrated mode) - ENU (KB946040)   KB946040

    This hotfix is for Microsoft Visual Studio 2008 Shell (integrated mode) - ENU.

    If you later install a more recent service pack, this hotfix will be uninstalled automatically.

    For more information, visit http://support.microsoft.com/kb/946040.

    Hotfix for Microsoft Visual Studio 2008 Shell (integrated mode) - ENU (KB946308)   KB946308

    This hotfix is for Microsoft Visual Studio 2008 Shell (integrated mode) - ENU.

    If you later install a more recent service pack, this hotfix will be uninstalled automatically.

    For more information, visit http://support.microsoft.com/kb/946308.

    Hotfix for Microsoft Visual Studio 2008 Shell (integrated mode) - ENU (KB946344)   KB946344

    This hotfix is for Microsoft Visual Studio 2008 Shell (integrated mode) - ENU.

    If you later install a more recent service pack, this hotfix will be uninstalled automatically.

    For more information, visit http://support.microsoft.com/kb/946344.

    Hotfix for Microsoft Visual Studio 2008 Shell (integrated mode) - ENU (KB946581)   KB946581

    This hotfix is for Microsoft Visual Studio 2008 Shell (integrated mode) - ENU.

    If you later install a more recent service pack, this hotfix will be uninstalled automatically.

    For more information, visit http://support.microsoft.com/kb/946581.

    Hotfix for Microsoft Visual Studio 2008 Shell (integrated mode) - ENU (KB947173)   KB947173

    This hotfix is for Microsoft Visual Studio 2008 Shell (integrated mode) - ENU.

    If you later install a more recent service pack, this hotfix will be uninstalled automatically.

    For more information, visit http://support.microsoft.com/kb/947173.

    Hotfix for Microsoft Visual Studio 2008 Shell (integrated mode) - ENU (KB947540)   KB947540

    This hotfix is for Microsoft Visual Studio 2008 Shell (integrated mode) - ENU.

    If you later install a more recent service pack, this hotfix will be uninstalled automatically.

    For more information, visit http://support.microsoft.com/kb/947540.

    Hotfix for Microsoft Visual Studio 2008 Shell (integrated mode) - ENU (KB947789)   KB947789

    This hotfix is for Microsoft Visual Studio 2008 Shell (integrated mode) - ENU.

    If you later install a more recent service pack, this hotfix will be uninstalled automatically.

    For more information, visit http://support.microsoft.com/kb/947789.

    SQL Server Analysis Services  

    Microsoft SQL Server Analysis Services Designer

    Version 10.50.2500.0

    SQL Server Integration Services  

    Microsoft SQL Server Integration Services Designer

    Version 10.50.2500.0

    SQL Server Reporting Services  

    Microsoft SQL Server Reporting Services Designers

    Version 10.50.2500.0

    Monday, June 11, 2012 5:35 PM
  • Which one is failing ?

    kb2669970, kb972222, kb251487


    Regards,
    Ahmed Ibrahim
    SQL Server Setup Team
    This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you.
    This can be beneficial to other community members reading the thread.

    Monday, June 11, 2012 6:19 PM
    Moderator
  • All 3 Visual studio updates kb2669970, kb972222, kb251487

    Thanks

    Monday, June 11, 2012 6:59 PM