Problem with installing SQL Server 2008 SP1 on Express instance with Advanced Services

• Ross Petersen

  Say Hey Kid

  Points: 677

  More actions

  July 19, 2009 at 5:31 am

  #385011

  Hi folks

  I attempted to install SP1 onto an instance of SQL Express with Advanced Services that is running on a 64 bit version ov Vista Ultimate SP2.

  When I attempted to install SP1 the following error msg popped up and the installation stopped.

  A failure was detected for a previous installation, patch, or repair during configuration for features [SQL_SSMS_Adv,SQL_PowerShell_Tools_ANS,]. In order to apply this patch package (KB968369), you must resolve any issues with the previous operation that failed. View the summary.txt log to determine why the previous operation failed

  The summary.txt log is as follows:

  Overall summary:

  Final result: The patch installer has failed to update the shared features. To determine the reason for failure, review the log files.

  Exit code (Decimal): -2068709375

  Exit facility code: 1202

  Exit error code: 1

  Exit message: A failure was detected for a previous installation, patch, or repair during configuration for features [SQL_SSMS_Adv,SQL_PowerShell_Tools_ANS,]. In order to apply this patch package (KB968369), you must resolve any issues with the previous operation that failed. View the summary.txt log to determine why the previous operation failed.

  Start time: 2009-07-09 04:54:34

  End time: 2009-07-09 05:04:21

  Requested action: Patch

  Log with failure: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20090709_045432\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.0.2531.0%26EvtType%3d0xEDCCDB3F%400xF762992B%401202%401

  Machine Properties:

  Machine name: HARVEYNORMAN-PC

  Machine processor count: 4

  OS version: Windows Vista

  OS service pack: Service Pack 2

  OS region: Australia

  OS language: English (United States)

  OS architecture: x64

  Process architecture: 64 Bit

  OS clustered: No

  Product features discovered:

  Product Instance Instance ID Feature Language Edition Version Clustered

  Sql Server 2005 MSSMLBIZ MSSQL.1 Database Engine Services 1033 Express Edition 9.3.4035 No

  Sql Server 2005 MSSMLBIZ MSSQL.1 SharedTools 1033 Express Edition 9.3.4035 No

  Sql Server 2008 SQLEXPRESS2008 MSSQL10.SQLEXPRESS2008 Database Engine Services 1033 Express Edition 10.0.1600.22 No

  Sql Server 2008 SQLEXPRESS2008 MSSQL10.SQLEXPRESS2008 SQL Server Replication 1033 Express Edition 10.0.1600.22 No

  Sql Server 2008 SQLEXPRESS2008 MSSQL10.SQLEXPRESS2008 Full-Text Search 1033 Express Edition 10.0.1600.22 No

  Sql Server 2008 SQLEXPRESS2008 MSRS10.SQLEXPRESS2008 Reporting Services 1033 Express Edition 10.0.1600.22 No

  Sql Server 2008 Management Tools - Basic 1033 Express Edition 10.0.1600.22 No

  Package properties:

  Description: SQL Server Database Services 2008

  SQLProductFamilyCode: {628F8F38-600E-493D-9946-F4178F20A8A9}

  ProductName: SQL2008

  Type: RTM

  Version: 10

  SPLevel: 1

  KBArticle: KB968369

  KBArticleHyperlink: http://support.microsoft.com/?kbid=968369

  PatchType: SP

  AssociateHotfixBuild: 0

  Platform: x64

  PatchLevel: 10.1.2531.0

  ProductVersion: 10.0.1600.22

  GDRReservedRange: 10.0.1000.0:10.0.1099.0;10.0.3000.0:10.0.3099.0

  PackageName: SQLServer2008-KB968369-x64.exe

  Installation location: c:\9eefffc46fc8c4be5dd1deab58554a\x64\setup\

  User Input Settings:

  ACTION: Patch

  ALLINSTANCES: False

  CLUSTERPASSIVE: False

  CONFIGURATIONFILE:

  HELP: False

  INDICATEPROGRESS: False

  INSTANCENAME:

  QUIET: False

  QUIETSIMPLE: False

  X86: False

  Rules with failures:

  Global rules:

  There are no scenario-specific rules.

  Rules report file: The rule result report file is not available.

  Exception summary:

  The following is an exception stack listing the exceptions in outermost to innermost order

  Inner exceptions are being indented

  Exception type: Microsoft.SqlServer.Chainer.Infrastructure.ChainerInvalidOperationException

  Message:

  A failure was detected for a previous installation, patch, or repair during configuration for features [SQL_SSMS_Adv,SQL_PowerShell_Tools_ANS,]. In order to apply this patch package (KB968369), you must resolve any issues with the previous operation that failed. View the summary.txt log to determine why the previous operation failed.

  Data:

  ChainerInvalidOperationExceptionData = ProductInstallProperty

  DisableWatson = true

  Stack:

  at Microsoft.SqlServer.Configuration.MsiExtension.ProductInstallProperty.CheckFailedConfiguration()

  at Microsoft.SqlServer.Configuration.MsiExtension.ProductInstallProperty.CollectProductData()

  at Microsoft.SqlServer.Configuration.FeatureTreeConfigurationBase.LoadFeatureTreeDefinitionAllInstances()

  at Microsoft.SqlServer.Configuration.PatchFeatureTree.InitializePatchFeatureTree(ServiceContainer context)

  at Microsoft.SqlServer.Configuration.SetupExtension.InitializeUIDataAction.ExecuteAction(String actionId)

  at Microsoft.SqlServer.Chainer.Infrastructure.Action.Execute(String actionId, TextWriter errorStream)

  at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.InvokeAction(WorkflowObject metabase, TextWriter statusStream)

  at Microsoft.SqlServer.Setup.Chainer.Workflow.PendingActions.InvokeActions(WorkflowObject metaDb, TextWriter loggingStream)

  I did notice after googling the error msg that one post mentioned Repairing the instance, but I do not know how to do this.

  If somebody could explain how to do the repair or point me in the right direction I would really appreciate it.

  Kind regards and thanks in advance

  Ross