none
SQL Server 2005 SP4 CU3 Only patched Tools and NOT SQL Can I also apply (KB2494120)

    Question

  • I've installed SQL Server 2005 SP4 CU3 and its patched "SQL Server Tools and Workstation Components 2005" from "5057" to "5266"

    However SQL Server Engine is not patched and shows the following message "The product instance MSSQLSERVER has had update 5057 installed. You do not need to install this update. An update equal to or greater than 5292 should be downloaded."

     

    1) Is this standard practice to run under different SQL Engine and Tool versions?

    2) Also are there any issues in applying Security (KB2494120) to the server is this current state and will it update SQL Engine and Tools?

    Time: 01/23/2013 15:41:57.599
    KB Number: KB2507769
    Machine:

    OS Version: Microsoft Windows Server 2003 family, Enterprise Edition Service Pack 2 (Build 3790)
    Package Language: 1033 (ENU)
    Package Platform: x64
    Package SP Level: 4
    Package Version: 5266
    Command-line parameters specified:
    Cluster Installation: No

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

    **********************************************************************************
    Products Detected                         Language  Level  Patch Level       Platform  Edition
    SQL Server Database Services 2005 (MSSQLSERVER)  ENU       SP4    2005.090.5057.00  x64       ENTERPRISE
    SQL Server Tools and Workstation Components 2005  ENU       SP4           9.4.5057  x64       ENTERPRISE

    **********************************************************************************
    Products Disqualified & Reason
    Product                                   Reason
    SQL Server Database Services 2005 (MSSQLSERVER)  The product instance MSSQLSERVER has had update 5057 installed. You do not need to install this update. An update equal to or greater than 5292 should be downloaded.

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

    **********************************************************************************
    Product Installation Status
    Product                   : SQL Server Database Services 2005 (MSSQLSERVER)
    Product Version (Previous): 5057
    Product Version (Final)   :
    Status                    : NA
    Log File                  :
    Error Description         : The product instance MSSQLSERVER has had update 5057 installed. You do not need to install this update. An update equal to or greater than 5292 should be downloaded.
    ----------------------------------------------------------------------------------
    Product                   : SQL Server Tools and Workstation Components 2005
    Product Version (Previous): 5057
    Product Version (Final)   : 5266
    Status                    : Success
    Log File                  : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQLTools9_Hotfix_KB2507769_sqlrun_tools.msp.log
    Error Number              : 0
    Error Description         :
    ----------------------------------------------------------------------------------

    **********************************************************************************
    Summary
         Success
         Exit Code Returned: 0


    • Edited by Shahjan Wednesday, February 13, 2013 11:46 AM
    Wednesday, February 13, 2013 11:44 AM

Answers