none
SQL 2008 R2 SP1 updete failed KB2528583 Error Code 84B40000

    Question

  • Hi.

     

    I'm trying to install KB2528583 update for SQL 2008 R2 on SBS 2011.
    Server has been migrated from SBS 2003 recently and I'm getting following error when trying to update SQL to SP1:

    Microsoft SQL Server 2008 R2 Service Pack 1 (KB2528583)
    Installation date: ‎12/‎12/‎2011 09:58
    Installation status: Failed
    Error details: Code 84B40000
    Update type: Important

    SQL Server 2008 R2 SP1 upgrades SQL Server 2008 R2 and the components installed by SQL Server 2008 R2 setup. The service pack may be applied to all editions of SQL Server 2008 R2 and can upgrade all instances of SQL Server 2008 R2 resident in your local system. If additional installation options are needed, please download Service Pack 1 from the Microsoft Download Center. For more information about the SQL Server 2008 R2 SP1 Package please visit the Microsoft Knowledge Base Article 2528583.

    When I'm trying to install it manually the installation fails on updating SBSMONITORING, SHAREPOINT and shared features and I'm getting following report:

     

    Overall summary:
      Final result:                  The patch installer has failed to update the following instance: SBSMONITORING SHAREPOINT. To determine the reason for failure, review the log files.
      Exit code (Decimal):           -2068578304
      Exit facility code:            1204
      Exit error code:               0
      Exit message:                  The patch installer has failed to update the following instance: SBSMONITORING SHAREPOINT. To determine the reason for failure, review the log files.
      Start time:                    2011-12-12 12:43:18
      End time:                      2011-12-12 12:49:04
      Requested action:              Patch

    Instance SBSMONITORING 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):           -2068578304
      Exit facility code:            1204
      Exit error code:               0
      Exit message:                  Attributes do not match. Present attributes (Directory, Compressed) , included attributes (0), excluded attributes (Compressed, Encrypted).
      Start time:                    2011-12-12 12:47:50
      End time:                      2011-12-12 12:48:27
      Requested action:              Patch

    Instance SHAREPOINT 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):           -2068578304
      Exit facility code:            1204
      Exit error code:               0
      Exit message:                  Attributes do not match. Present attributes (Directory, Compressed) , included attributes (0), excluded attributes (Compressed, Encrypted).
      Start time:                    2011-12-12 12:48:31
      End time:                      2011-12-12 12:49:01
      Requested action:              Patch

    Machine Properties:
      Machine name:                  ***********
      Machine processor count:       12
      OS version:                    Windows Server 2008 R2
      OS service pack:              
      OS region:                     United Kingdom
      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      MICROSOFT##SSEE      MSSQL.2005                     Database Engine Services                 0                    Windows Internal Database (64-bit) 9.4.5000        No       
      Sql Server 2005      MICROSOFT##SSEE      MSSQL.2005                     SharedTools                              0                    Windows Internal Database (64-bit) 9.4.5000        No       
      Sql Server 2005      BKUPEXEC             MSSQL.1                        Database Engine Services                 1033                 Express Edition      9.3.4060        No       
      Sql Server 2005      BKUPEXEC             MSSQL.1                        SQL Server Replication                   1033                 Express Edition      9.3.4060        No       
      Sql Server 2005      BKUPEXEC             MSSQL.1                        SharedTools                              1033                 Express Edition      9.3.4060        No       
      Sql Server 2005                                                          Tools                                    1033                 Express Edition      9.3.4060        No       
      Sql Server 2005                                                          ToolsClient                              1033                 Express Edition      9.3.4060        No       
      Sql Server 2005                                                          ToolsClient\Connectivity                 1033                 Express Edition      9.3.4060        No       
      Sql Server 2008 R2   SBSMONITORING        MSSQL10_50.SBSMONITORING       Database Engine Services                 1033                 Express Edition      10.50.1617.0    No       
      Sql Server 2008 R2   SBSMONITORING        MSSQL10_50.SBSMONITORING       SQL Server Replication                   1033                 Express Edition      10.50.1617.0    No       
      Sql Server 2008 R2   SBSMONITORING        MSSQL10_50.SBSMONITORING       Full-Text Search                         1033                 Express Edition      10.50.1600.1    No       
      Sql Server 2008 R2   SHAREPOINT           MSSQL10_50.SHAREPOINT          Database Engine Services                 1033                 Express Edition      10.50.1617.0    No       
      Sql Server 2008 R2   SHAREPOINT           MSSQL10_50.SHAREPOINT          SQL Server Replication                   1033                 Express Edition      10.50.1617.0    No       
      Sql Server 2008 R2   SHAREPOINT           MSSQL10_50.SHAREPOINT          Full-Text Search                         1033                 Express Edition      10.50.1600.1    No       
      Sql Server 2008 R2                                                       Management Tools - Basic                 1033                 Express Edition      10.50.1617.0    No       

    Package properties:
      Description:                   SQL Server Database Services 2008 R2
      ProductName:                   SQL2008
      Type:                          RTM
      Version:                       10
      SPLevel:                       1
      KBArticle:                     KB2528583
      KBArticleHyperlink:            http://support.microsoft.com/?kbid=2528583
      PatchType:                     SP
      AssociateHotfixBuild:          0
      Platform:                      x64Se
      PatchLevel:                    10.51.2500.0
      ProductVersion:                10.50.1600.1
      GDRReservedRange:              10.0.1000.0:10.0.1099.0;10.0.3000.0:10.0.3099.0
      PackageName:                   SQLServer2008-KB2528583-x64.exe
      Installation location:         g:\6e04c18362c79827d740e34608eccf\x64\setup\

    Updated product edition:
      Instance             Edition            
      SBSMONITORING        EXPRESS_ADVANCED   
      SHAREPOINT           EXPRESS_ADVANCED   

    User Input Settings:
      ACTION:                        Patch
      ALLINSTANCES:                  False
      CLUSTERPASSIVE:                False
      CONFIGURATIONFILE:            
      ENU:                           False
      FARMACCOUNT:                   <empty>
      FARMADMINPORT:                 0
      FARMPASSWORD:                  *****
      HELP:                          False
      INDICATEPROGRESS:              False
      INSTANCEID:                    <empty>
      INSTANCENAME:                  <empty>
      PASSPHRASE:                    *****
      QUIET:                         False
      QUIETSIMPLE:                   False
      UIMODE:                        Normal
      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\20111212_124305\SystemConfigurationCheck_Report.htm

    Any idea how to fix it???
    Monday, December 12, 2011 1:14 PM

Answers

  • Hello,

    The update cannot be installed on a compressed directory. Uncompress first, then try to apply the update again.


    Hope this helps.


    Regards,

    Alberto Morillo
    SQLCoffee.com

    Monday, December 12, 2011 1:29 PM
    Moderator

All replies

  • Hello,

    The update cannot be installed on a compressed directory. Uncompress first, then try to apply the update again.


    Hope this helps.


    Regards,

    Alberto Morillo
    SQLCoffee.com

    Monday, December 12, 2011 1:29 PM
    Moderator
  • God bless you Alberto!!!

     

    I would never found it without your help!!!

     

    Thanks a lot.


    • Edited by Zygha Monday, December 12, 2011 2:42 PM
    Monday, December 12, 2011 2:24 PM
  • Thank you for visiting this forum Zygha! Have a good day!
    Monday, December 12, 2011 4:29 PM
    Moderator
  • Could u please let me know how do i need to uncompress the directory since i'm also facing same problem?

    Tuesday, May 22, 2012 6:50 AM
  • By default names of all compressed folders in Windows OS are displayed in blue colour.

    Please select compressed folder, and go to properties.
    On the "General" tab click on "Advanced" button.
    Remove tick from the "Compress contents to save disk space" option and apply changes.
    Be patient as it will take a while to uncompress the folder.

    Friday, June 22, 2012 2:53 PM
  • Man, u have saved my one day..how do i thank u, i cant understand..God bless u brother
    Tuesday, June 26, 2012 4:16 PM
  • FYI, I was having the same error code with SQL 2008 R2 SP1 update as well, but when I went to look into the folders to see whether they were compressed or not, I found that none of my folders were compressed.  However, in the end I was able to fix this problem by shutting down the SQL Server Database completely before running the update.  It seems that if the SQL Server Database is running in Windows, the Service Pack update cannot install (especially if you have a failover cluster setup like I do where the SQL Server instance is shared amongst two servers and is constantly running).    I just thought that I would put that out there for anyone else who might run into this same exact issue and is running a SQL Server Database on a failover cluster and is trying to install this patch.  Not only did I have to shutdown the SQL Server Database, but I also had to reboot the server first BEFORE installing the patch.  The patching didn't work immediately after turning off the SQL Server Database, because it seems that Windows didn't fully release that service until a reboot was initiated. 

    Saturday, September 22, 2012 11:29 PM
  • I'm trying to apply the patch to the secondary server of the cluster.  Are you saying the patch can't be installed unless I take SQL down completely on both servers?  I don't have a window when this can be done.  My SQL server requires that I stay up 24/7/365.  Any idea how I can get this update installed?
    Friday, December 14, 2012 4:07 AM
  • You could try taking first one node out of the cluster, turning off all of the SQL Server services on that machine, Patching it then rejoining it to the cluster. Do this for each machine and that way the cluster can remain up while you patch.

    Hope this was helpful.

    V/R

    Phillip Goin

    Friday, December 28, 2012 2:33 PM