Unable To Apply SP2 To SQL Server 2005 Developer Edition

I can't install the client tools of SQL Server 2005 SP2. I'm doing it on a fresh re-install of SQL Server 2005 Developer Edition (without SP1). It's been a rollercoaster -- I tried it on SP1 and that didn't work, so I decided to uninstall altogether, then couldn't re-install; I had to install most pieces of SQL Server 2005 individually (executing each msi file separately), then I had to install most pieces of SP2 individually, too.

I could get everything to work except for the SP2 client tools. I get this error in the event log:


Product: Microsoft SQL Server 2005 Tools -- Error 1721. There is a problem with this Windows Installer package. A program required for this install to complete could not be run. Contact your support personnel or package vendor. Action: SqlWbSetup.5F46584E_060D_4BCB_ADEE_BD15A7BFCC2A, location: C:Program FilesMicrosoft SQL Server90ToolsBinnVSShellCommon7IDESqlWb.exe, command: /setup

followed by this one:


Product: Microsoft SQL Server 2005 Tools - Update 'Service Pack 2 for SQL Server Tools and Workstation Components 2005 ENU (KB921896)' could not be installed. Error code 1603. Additional information is available in the log file C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixSQLTools9_Hotfix_KB921896_sqlrun_tools.msp.log.

Here is my summary.txt file:

Time: 02/04/2008 23:06:40.328
KB Number: KB921896
Machine: KRISTER
OS Version: Microsoft Windows XP Professional Service Pack 2 (Build 2600)
Package Language: 1033 (ENU)
Package Platform: x86
Package SP Level: 2
Package Version: 3042
Command-line parameters specified:
Cluster Installation: No

**********************************************************************************
Prerequisites Check & Status
SQLSupport: Passed

**********************************************************************************
Products Detected Language Level Patch Level Platform Edition
Setup Support Files ENU 9.2.3042 x86
Database Services (MSSQLSERVER) ENU SP2 2005.090.3054.00 x86 DEVELOPER
Analysis Services (MSSQLSERVER) ENU SP2 2005.090.3054.00 x86 DEVELOPER
Reporting Services (MSSQLSERVER) ENU SP2 9.00.3054.00 x86 DEVELOPER
Notification Services ENU SP2 9.00.3054.00 x86 DEVELOPER
Integration Services ENU SP2 9.00.3054.00 x86 DEVELOPER
SQL Server Native Client ENU 9.00.3042.00 x86
Client Components ENU RTM 9.00.1399.06 x86 DEVELOPER
MSXML 6.0 Parser ENU 6.10.1129.0 x86
SQLXML4 ENU 9.00.3042.00 x86
Backward Compatibility ENU 8.05.2004 x86
Microsoft SQL Server VSS Writer ENU 9.00.3042.00 x86

**********************************************************************************
Products Disqualified & Reason
Product Reason
Database Services (MSSQLSERVER) The product instance MSSQLSERVER been patched with more recent updates.
Analysis Services (MSSQLSERVER) The product instance MSSQLSERVER been patched with more recent updates.
Reporting Services (MSSQLSERVER) The product instance MSSQLSERVER been patched with more recent updates.
Notification Services The product instance NS been patched with more recent updates.
Integration Services The product instance Integration Services been patched with more recent updates.

**********************************************************************************
Processes Locking Files
Process Name Feature Type User Name PID

**********************************************************************************
Product Installation Status
Product : Setup Support Files
Product Version (Previous): 3042
Product Version (Final) :
Status : Not Selected
Log File :
Error Description :
----------------------------------------------------------------------------------
Product : Database Services (MSSQLSERVER)
Product Version (Previous): 3054
Product Version (Final) :
Status : NA
Log File :
Error Description : The product instance MSSQLSERVER been patched with more recent updates.
----------------------------------------------------------------------------------
Product : Analysis Services (MSSQLSERVER)
Product Version (Previous): 3054
Product Version (Final) :
Status : NA
Log File :
Error Description : The product instance MSSQLSERVER been patched with more recent updates.
----------------------------------------------------------------------------------
Product : Reporting Services (MSSQLSERVER)
Product Version (Previous): 3054
Product Version (Final) :
Status : NA
Log File :
Error Description : The product instance MSSQLSERVER been patched with more recent updates.
----------------------------------------------------------------------------------
Product : Notification Services
Product Version (Previous): 3054
Product Version (Final) :
Status : NA
Log File :
Error Description : The product instance NS been patched with more recent updates.
----------------------------------------------------------------------------------
Product : Integration Services
Product Version (Previous): 3054
Product Version (Final) :
Status : NA
Log File :
Error Description : The product instance Integration Services been patched with more recent updates.
----------------------------------------------------------------------------------
Product : SQL Server Native Client
Product Version (Previous): 3042
Product Version (Final) :
Status : Not Selected
Log File :
Error Description :
----------------------------------------------------------------------------------
Product : Client Components
Product Version (Previous): 1399
Product Version (Final) :
Status : Failure
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixSQLTools9_Hotfix_KB921896_sqlrun_tools.msp.log
Error Number : 1721
Error Description : MSP Error: 1721 There is a problem with this Windows Installer package. A program required for this install to complete could not be run. Contact your support personnel or package vendor.
----------------------------------------------------------------------------------
Product : MSXML 6.0 Parser
Product Version (Previous): 1129
Product Version (Final) :
Status : Not Selected
Log File :
Error Description :
----------------------------------------------------------------------------------
Product : SQLXML4
Product Version (Previous): 3042
Product Version (Final) :
Status : Not Selected
Log File :
Error Description :
----------------------------------------------------------------------------------
Product : Backward Compatibility
Product Version (Previous): 2004
Product Version (Final) :
Status : Not Selected
Log File :
Error Description :
----------------------------------------------------------------------------------
Product : Microsoft SQL Server VSS Writer
Product Version (Previous): 3042
Product Version (Final) :
Status : Not Selected
Log File :
Error Description :
----------------------------------------------------------------------------------

**********************************************************************************
Summary
One or more products failed to install, see above for details
Exit Code Returned: 1721


Here is an error message from my hotfix.log file:

02/04/2008 17:37:49.921 MSP Error: 1721 There is a problem with this Windows Installer package. A program required for this install to complete could not be run. Contact your support personnel or package vendor.
02/04/2008 17:40:06.468 MSP returned 1603: A fatal error occurred during installation.
02/04/2008 17:40:06.625 Registry: Opened registry key "SoftwarePoliciesMicrosoftWindowsInstaller"
02/04/2008 17:40:06.671 Registry: Cannot read registry key value "Debug"
02/04/2008 17:40:07.984 Copy Engine: Error, unable to install MSP file: C: empdownloadsMicrosoftSQLServer2005SP2-KB21896-x86-ENUHotFixToolsFilessqlrun_tools.msp
02/04/2008 17:40:08.031 The following exception occurred: Unable to install Windows Installer MSP file Date: 02/04/2008 17:40:08.031 File: depotsqlvaultstablesetupmainl1setupsqlsesqlsedllcopyengine.cpp Line: 800
02/04/2008 17:40:15.562 Watson: Param1 = Unknown
02/04/2008 17:40:15.625 Watson: Param2 = 0x6b9
02/04/2008 17:40:15.796 Watson: Param3 = Unknown
02/04/2008 17:40:16.000 Watson: Param4 = 0x6b9
02/04/2008 17:40:16.078 Watson: Param5 = copyengine.cpp@800
02/04/2008 17:40:16.140 Watson: Param6 = Unknown
02/04/2008 17:40:16.171 Watson: Param7 = SQLTools9
02/04/2008 17:40:16.250 Watson: Param8 = Hotfix@
02/04/2008 17:40:16.343 Watson: Param9 = x86
02/04/2008 17:40:16.500 Watson: Param10 = 3042
02/04/2008 17:40:16.625 Installed product: SQLTools9
02/04/2008 17:40:16.750 Hotfix package completed
02/04/2008 17:40:16.781 Attempting to continue the 32 bit ngen queue

There is a value 3 in my SQLTools9_Hotfix_KB921896_sqlrun_tools.msp.log, but I don't really see anything more descriptive in that file. These are the lines above the value 3 that look interesting:

MSI (s) (1C:30) [17:37:49:000]: Note: 1: 1721 2: CA_HxMerge_SQLCC.3643236F_FC70_11D3_A536_0090278A1BB8 3: C:WINDOWSInstallerMSI1C7B.tmp 4: ms-help://MS.SQLCC.v9
MSI (s) (1C:30) [17:37:49:078]: Transforming table Error.

MSI (s) (1C:30) [17:37:49:078]: Transforming table Error.

MSI (s) (1C:30) [17:37:49:078]: Note: 1: 2262 2: Error 3: -2147287038
Info 1721.There is a problem with this Windows Installer package. A program required for this install to complete could not be run. Contact your support personnel or package vendor. Action: CA_HxMerge_SQLCC.3643236F_FC70_11D3_A536_0090278A1BB8, location: C:WINDOWSInstallerMSI1C7B.tmp, command: ms-help://MS.SQLCC.v9
MSI (s) (1C:30) [17:37:49:093]: Note: 1: 1721 2: CA_HxMerge_Hx.3643236F_FC70_11D3_A536_0090278A1BB8 3: C:WINDOWSInstallerMSI1C7C.tmp 4: ms-help://Hx
MSI (s) (1C:30) [17:37:49:171]: Transforming table Error.

MSI (s) (1C:30) [17:37:49:187]: Transforming table Error.

MSI (s) (1C:30) [17:37:49:187]: Note: 1: 2262 2: Error 3: -2147287038
Info 1721.There is a problem with this Windows Installer package. A program required for this install to complete could not be run. Contact your support personnel or package vendor. Action: CA_HxMerge_Hx.3643236F_FC70_11D3_A536_0090278A1BB8, location: C:WINDOWSInstallerMSI1C7C.tmp, command: ms-help://Hx
MSI (s) (1C:08) [17:37:49:234]: Invoking remote custom action. DLL: C:WINDOWSInstallerMSI1C7D.tmp, Entrypoint: Set_CommitFlag
<Func Name='LaunchFunction'>
Function=Set_CommitFlag
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='87'>
Doing Action: Set_CommitFlag
PerfTime Start: Set_CommitFlag : Mon Feb 04 17:37:49 2008
<Func Name='Set_CommitFlag'>
Set_CommitFlag called successfully.Committed
<EndFunc Name='Set_CommitFlag' Return='0' GetLastError='0'>
PerfTime Stop: Set_CommitFlag : Mon Feb 04 17:37:49 2008
<EndFunc Name='LaunchFunction' Return='0' GetLastError='0'>
MSI (s) (1C:30) [17:37:49:859]: Note: 1: 1721 2: SqlWbSetup.5F46584E_060D_4BCB_ADEE_BD15A7BFCC2A 3: C:Program FilesMicrosoft SQL Server90ToolsBinnVSShellCommon7IDESqlWb.exe 4: /setup
MSI (s) (1C:30) [17:37:49:906]: Transforming table Error.

MSI (s) (1C:30) [17:37:49:906]: Transforming table Error.

MSI (s) (1C:30) [17:37:49:906]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (1C:30) [17:37:50:031]: Transforming table Error.

MSI (s) (1C:30) [17:37:50:046]: Transforming table Error.

MSI (s) (1C:30) [17:37:50:046]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (1C:30) [17:37:50:046]: Product: Microsoft SQL Server 2005 Tools -- Error 1721. There is a problem with this Windows Installer package. A program required for this install to complete could not be run. Contact your support personnel or package vendor. Action: SqlWbSetup.5F46584E_060D_4BCB_ADEE_BD15A7BFCC2A, location: C:Program FilesMicrosoft SQL Server90ToolsBinnVSShellCommon7IDESqlWb.exe, command: /setup

Error 1721. There is a problem with this Windows Installer package. A program required for this install to complete could not be run. Contact your support personnel or package vendor. Action: SqlWbSetup.5F46584E_060D_4BCB_ADEE_BD15A7BFCC2A, location: C:Program FilesMicrosoft SQL Server90ToolsBinnVSShellCommon7IDESqlWb.exe, command: /setup


I see lots of other people with problems posted online, but no answer has helped me. So, any help would be greatly appreciated.

Thanks!