none
Failed in applying SP1 patch to SQL Server 2008 Enterprise Edition RRS feed

  • Question

  • Esteemed DBAs.

    Thank you for your support despite your busy life as DBA.
    I've tried to apply SP1 to SQL Server 2008 and failed with below errors,

    TITLE: SQL Server Setup failure.

    ------------------------------

     

    SQL Server Setup has encountered the following error:

     

     

    A failure was detected for a previous installation, patch, or repair for instance 'MSSQLSERVER' during configuration for features [SQL_Replication_Core_Inst,SQL_Engine_Core_Inst,MPT_AGENT_CORE_CNI,SQL_FullText_Adv,Analysis_Server_Full,RS_Server_Adv,]. 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.

    A failure was detected for a previous installation, patch, or repair during configuration for features [SQL_DTS_Full,Connectivity_Full,SQL_SSMS_Full,SDK_Full,Tools_Legacy_Full,SQL_BIDS_Full,SQL_SSMS_Adv,SQL_PowerShell_Tools_ANS,CommonFiles_Loc,SQL_BooksOnline_Redist,]. 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.

     

    Error code 0x84B20001.

     

    It seems that the previous installation has a problem. 

    If you have experience on troubleshooting this problem could you give me some advice? 

    Thank you 

    Wednesday, February 24, 2010 1:47 PM

Answers

  • Hi,

    Based on the summary file, it seems you installed a clustered SQL Server instance on an Operation System that doesn’t support failover clustering.

    To work around the issue, try the following steps to remove the existing SQL Server:
    1. Make sure you have administrative rights on the computer
    2. Uninstall the existing SQL Server 2008 and all the components from the control panel. Remember to backup the user databases before uninstalling SQL Server.
    3. Backup the registry.
    4. Delete the following keys in regedit:
    --HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server
    --HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer
    5.  Go to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall  and delete all the sub-keys referencing SQL Server.
    6.  Go to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services and delete all the keys referencing SQL Server.
    7.  Rename all the SQL Server folders in the computer.
    8.  Download and install Windows Cleanup Utility:
    http://support.microsoft.com/?id=290301
    Run the utility and remove any SQL Server components that you find.
    9. Reboot the machine

    For installing a stand-alone instance of SQL Server:
    1.  Follow up the document below to reinstall SQL Server 2008. Note that click “New Installation or Add Features to an Existing Installation” in the SQL Server Installation Center.
    http://technet.microsoft.com/en-us/library/ms143219.aspx

    For installing a Failover Cluster, please refer to:
    How to: Create a New SQL Server Failover Cluster (Setup)
    http://technet.microsoft.com/en-us/library/ms179530.aspx


    If there are any more questions, please let me know.
    Thanks.


    ***Xiao Min Tan***Microsoft Online Community***
    Friday, February 26, 2010 9:16 AM
    Moderator

All replies

  • under c:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log

    check the summary.txt first.

    there are sub-folders for every patch/kb/culm update install attempted.  

    Explore the subfolders in reverse chronological order and check the summary_*.txt files and if need be, dig into the detail.txt file for the specifics of what failed.

    Wednesday, February 24, 2010 3:38 PM
  • Ok. I will try it and let you know the result.

    Thank you.
    • Proposed as answer by JohnVal Tuesday, November 13, 2012 11:29 PM
    Wednesday, February 24, 2010 3:45 PM
  • This is the content of one summary_*.txt. OS service pack is 'Service Pack 2'. I don't think we are talking about OS service pack.  

    Start time:                    2010-02-24 07:30:58
      End time:                      2010-02-24 07:41:19
      Requested action:              Patch

    Machine Properties:
      Machine name:                  AVDEVOBJAPP1
      Machine processor count:       4
      OS version:                    Windows Server 2008
      OS service pack:               Service Pack 2
      OS region:                     United States
      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 2008      MSSQLSERVER          MSSQL10.MSSQLSERVER            Database Engine Services                 1033                 Enterprise Edition   10.0.1600.22    No       
      Sql Server 2008      MSSQLSERVER          MSSQL10.MSSQLSERVER            SQL Server Replication                   1033                 Enterprise Edition   10.0.1600.22    No       
      Sql Server 2008      MSSQLSERVER          MSSQL10.MSSQLSERVER            Full-Text Search                         1033                 Enterprise Edition   10.0.1600.22    No       
      Sql Server 2008      MSSQLSERVER          MSAS10.MSSQLSERVER             Analysis Services                        1033                 Enterprise Edition   10.0.1600.22    No       
      Sql Server 2008      MSSQLSERVER          MSRS10.MSSQLSERVER             Reporting Services                       1033                 Enterprise Edition   10.0.1600.22    No       
      Sql Server 2008                                                          Management Tools - Basic                 1033                 Enterprise Edition   10.0.1600.22    No       
      Sql Server 2008                                                          Management Tools - Complete              1033                 Enterprise Edition   10.0.1600.22    No       
      Sql Server 2008                                                          Client Tools Connectivity                1033                 Enterprise Edition   10.0.1600.22    No       
      Sql Server 2008                                                          Client Tools Backwards Compatibility     1033                 Enterprise Edition   10.0.1600.22    No       
      Sql Server 2008                                                          Client Tools SDK                         1033                 Enterprise Edition   10.0.1600.22    No       
      Sql Server 2008                                                          Integration Services                     1033                 Enterprise 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:         e:\1e1cd42707e64fa589a8f35bb167fb\x64\setup\

    Updated product edition:
      Instance             Edition            
      MSSQLSERVER          ENTERPRISE         

    User Input Settings:
      ACTION:                        Patch
      ALLINSTANCES:                  False
      CLUSTERPASSIVE:                False
      CONFIGURATIONFILE:            
      HELP:                          False
      INDICATEPROGRESS:              False
      INSTANCENAME:                  <empty>
      QUIET:                         False
      QUIETSIMPLE:                   False
      X86:                           False

    Rules with failures:

    Global rules:

    There are no scenario-specific rules.

    Rules report file:               C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20100224_072851\SystemConfigurationCheck_Report.htm

    Wednesday, February 24, 2010 4:38 PM
  • Hi,

    Based on the summary file, it seems you installed a clustered SQL Server instance on an Operation System that doesn’t support failover clustering.

    To work around the issue, try the following steps to remove the existing SQL Server:
    1. Make sure you have administrative rights on the computer
    2. Uninstall the existing SQL Server 2008 and all the components from the control panel. Remember to backup the user databases before uninstalling SQL Server.
    3. Backup the registry.
    4. Delete the following keys in regedit:
    --HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server
    --HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer
    5.  Go to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall  and delete all the sub-keys referencing SQL Server.
    6.  Go to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services and delete all the keys referencing SQL Server.
    7.  Rename all the SQL Server folders in the computer.
    8.  Download and install Windows Cleanup Utility:
    http://support.microsoft.com/?id=290301
    Run the utility and remove any SQL Server components that you find.
    9. Reboot the machine

    For installing a stand-alone instance of SQL Server:
    1.  Follow up the document below to reinstall SQL Server 2008. Note that click “New Installation or Add Features to an Existing Installation” in the SQL Server Installation Center.
    http://technet.microsoft.com/en-us/library/ms143219.aspx

    For installing a Failover Cluster, please refer to:
    How to: Create a New SQL Server Failover Cluster (Setup)
    http://technet.microsoft.com/en-us/library/ms179530.aspx


    If there are any more questions, please let me know.
    Thanks.


    ***Xiao Min Tan***Microsoft Online Community***
    Friday, February 26, 2010 9:16 AM
    Moderator
  • Just repair the sql server instance from add/remove programs. Reboot and then apply the service pack. This should resolve the issue
    Friday, December 16, 2011 2:56 PM
  • Nice, Hidayathullahs reply easily solved my Error code 0x84B20001 issue.
    • Edited by bizTalk.2037 Wednesday, February 22, 2012 5:48 PM
    Wednesday, February 22, 2012 5:45 PM