locked
remove sql server 2008 SP3 and sqp server from windows 10 RRS feed

  • Question

  • I would like to remove sql server 2008 express but I keep getting an error message.

    Installing an update also gives an error.

    I tried uninstalling in compatibility mode but keep getting the same error message.

    SQLEXPRESS Failed (Your SQL server 2008 remove update operation failed)

    There is also a link to the following text file. (I don't know the location of the log file)

    Overall summary:
      Final result:                  The patch installer has failed to update the following instance: SQLEXPRESS. 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: SQLEXPRESS. To determine the reason for failure, review the log files.
      Start time:                    2015-08-10 18:21:42
      End time:                      2015-08-10 18:22:35
      Requested action:              RemovePatch
    Instance SQLEXPRESS 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:                    2015-08-10 18:22:19
      End time:                      2015-08-10 18:22:31
      Requested action:              RemovePatch
    Machine Properties:
      Machine name:                  HOME-PC
      Machine processor count:       4
      OS version:                    Windows Vista
      OS service pack:              
      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      SQLEXPRESS           MSSQL10.SQLEXPRESS             Database Engine Services                 1033                 Express Edition      10.3.5500.0     No       
      Sql Server 2008      SQLEXPRESS           MSSQL10.SQLEXPRESS             SQL Server Replication                   1033                 Express Edition      10.3.5500.0     No       
    Package properties:
      Description:                   SQL Server Database Services 2008
      SQLProductFamilyCode:          {628F8F38-600E-493D-9946-F4178F20A8A9}
      ProductName:                   SQL2008
      Type:                          RTM
      Version:                       10
      SPLevel:                       3
      KBArticle:                     KB2546951
      KBArticleHyperlink:            http://support.microsoft.com/?kbid=2546951
      PatchType:                     SP
      AssociatedHotfixBuild:         0
      Platform:                      x64
      PatchLevel:                    10.3.5500.0
      ProductVersion:                10.0.1600.22
      GDRReservedRange:              10.0.1000.0:10.0.1099.0;10.0.3000.0:10.0.3099.0;10.0.4010.0:10.0.4250.0;10.0.5501.0:10.0.5750.0
      PackageName:                   SQLServer2008-KB2546951-x64.exe
      Installation location:         C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Update Cache\KB2546951\ServicePack\x64\setup\
    Updated product edition:
      Instance             Edition            
      SQLEXPRESS           EXPRESS            
    User Input Settings:
      ACTION:                        RemovePatch
      ALLINSTANCES:                  True
      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\20150810_182141\SystemConfigurationCheck_Report.htm

    Monday, August 10, 2015 4:25 PM

Answers


  •   Exit message:                  Attributes do not match. Present attributes (Directory, Compressed) , included attributes (0), excluded attributes (Compressed, Encrypted).
     


    Hi kwauters,

    The above error message could be caused by that the archive bit is set on the installation directory of SQL Server, this can also occur when Compression or Encryption is enabled on the SQL Server folder. To fix this issue, please perform the following steps.

    1. Navigate to C:\Program Files\Microsoft SQL server folder.

    2. Right click on properties on SQL Server folder. 

    3. Under advanced option in general tab, disable the following settings.

            • Folder is ready for archiving

            • Compress contents to save disk space

            • Encrypt contents to save disk space

    4. Uninstall SQL Server again.

    There is also a similar thread for your reference.
    https://social.msdn.microsoft.com/Forums/sqlserver/en-US/a94fcca0-b9cc-4287-90fe-f3151ef997ab/sql-server-2008-r2-installation?forum=sqlgetstarted


     Thanks,
    Lydia Zhang


    Lydia Zhang
    TechNet Community Support



    Tuesday, August 11, 2015 6:06 AM

All replies