none
Unable to apply SP2 to SQL Server 2005 Developer Edition RRS feed

  • Question

  • 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 Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\SqlWb.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 Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQLTools9_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 Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQLTools9_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 "Software\Policies\Microsoft\Windows\Installer"
    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:\temp\downloads\Microsoft\SQLServer2005SP2-KB21896-x86-ENU\HotFixTools\Files\sqlrun_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: \depot\sqlvault\stable\setupmainl1\setup\sqlse\sqlsedll\copyengine.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:\WINDOWS\Installer\MSI1C7B.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:\WINDOWS\Installer\MSI1C7B.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:\WINDOWS\Installer\MSI1C7C.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:\WINDOWS\Installer\MSI1C7C.tmp, command: ms-help://Hx
    MSI (s) (1C:08) [17:37:49:234]: Invoking remote custom action. DLL: C:\WINDOWS\Installer\MSI1C7D.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 Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\SqlWb.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 Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\SqlWb.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 Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\SqlWb.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!
    Tuesday, February 5, 2008 5:08 AM

All replies