Trying to upgrade SQL Server Express SP1 to SP2

Question

Hello,

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? 

Thanks

---

Paul

Answer 1

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.

http://support.microsoft.com/kb/957453

http://social.msdn.microsoft.com/Forums/en-US/sqlgetstarted/thread/a94fcca0-b9cc-4287-90fe-f3151ef997ab

Thanks,
Sam Lester (MSFT)

---

My Blog

This posting is provided "AS IS" with no warranties, and confers no rights. 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.

Answer 2

Are you saying that you have the sql folders compressed.. First thing I would do is uncompress the folders

Answer 3

Hi Paul,

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  .

 

Regards,
Amy Peng

---

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.

Answer 4

Thanks, I will need to uncompress the drive.

For the SP2 for SQL Server, I have found the install package just for SP2.

http://www.microsoft.com/en-us/download/details.aspx?id=30437

---

Paul