Friday, September 14, 2012 11:28 PM
I have a few problems trying to upgrade SP1 to SP2 with Microsoft SQL Server 2008 R2 with Advandanced Services.
When I run this package SQLServer2008R2SP2-KB2630458-x64-ENU.exe from this site, it fails.
The summary message says:
Exit message: Attributes do not match. Present attributes (Directory, Compressed) , included attributes (0), excluded attributes (Compressed, Encrypted).
The attributes on the folders is DC. What can I do about this?
This is what is currently on the server:
Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64) Apr 2 2010 15:48:46 Copyright (c) Microsoft Corporation Express Edition with Advanced Services (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) (Hypervisor)
The other problem is trying to find the correct SP2.
These have the whole installs, but I just need theP2 http://www.microsoft.com/en-us/download/details.aspx?id=30438
These page has SP2 for Express Edition 2008 R2, but does not have the Advanced http://www.microsoft.com/en-us/download/details.aspx?id=30437. Will these work for Express Edition with Advanced Servcies? Where can I get SP2 for Express Edition with Advanced Services 2008 R2?
Friday, September 14, 2012 11:41 PMModerator
Hi Paul, the "attributes do not match" error can be the result of a couple different things. Check the drive and folders where you have installed SQL Server and make sure that the folders are not set to archived, encrypted, or compressed.
Sam Lester (MSFT)
"Mark as Answer" and "Vote as Helpful" on posts that help you. This can be beneficial to other community members reading the thread.
Saturday, September 15, 2012 12:28 AM
Are you saying that you have the sql folders compressed.. First thing I would do is uncompress the folders
Monday, September 17, 2012 10:23 AM
We may meet this error about “Attributes do not match” , when we just want to upgrade the SQL Server or when we want to install some shared features with compression and/or encryption is enabled.
In order to fix this error, please go to “C:\Program Files” and check the properties of “Microsoft SQL Server” folder. Then in the properties window you will find “advanced option” under the General tab. Now go to “advanced option” and look for “Compress contents to save disk space” and “encrypt contents to secure data”. You will find these options as checked. Please uncheck these options and apply the changes. After that please check if this error could be fixed.
Please refer to:
Attributes do not match: http://databasebestpractices.com/attributes-match-present-attributes-directory-compressed-included-attributes-0-excluded-attributes-compressed-encrypted/
You said you cannot find the Services Pack 2 for SQL Server 2008R2 express with advanced services in the following link, Please just open the following link and choose ” SQLEXPRADV_x64_ENU.exe” to download:
Download: http://www.microsoft.com/en-us/download/details.aspx?id=30438 .
Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you. This can be beneficial to other community members reading the thread.
Monday, September 17, 2012 3:59 PM
Thanks, I will need to uncompress the drive.
For the SP2 for SQL Server, I have found the install package just for SP2.