SQL SERVER – Service Pack Error – Attributes do not Match

My virtual machines are my play grounds for any research. A few days ago, on my lab machine, I was having difficulties applying latest service pack. I followed the documentation and looked at the files. In this blog post we will take a look at the service pack error. Here is what I found in Summary.txt

Instance MSSQLSERVER 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: 2017-04-06 08:05:41
End time: 2017-04-06 08:06:04
Requested action: Patch

The above messages “Attributes do not match. Present attributes (Directory, Compressed) , included attributes, excluded attributes (Compressed, Encrypted).”clearly states that the folder of SQL Server is compressed.


This is because I was trying to patch SQL where I compressed SQL related folders, which is not supported. To fix this I did below.

  • Navigated to C:\Program Files folder
  • Right click on properties on Microsoft SQL Server
  • Under Advanced option in General tab, look for compress contents to save disk space, uncheck it.
  • Also, uncheck encrypt contents to secure data. To avoid another error which might come due to this.
  • Same for C:\Program Files (x86) related SQL folders as well.

SQL SERVER - Service Pack Error - Attributes do not Match patch-encrypt-01

It looks like there are others who have reported this https://connect.microsoft.com/SQLServer/feedback/details/704250/installation-failed-when-c-drive-compressed

Reference: Pinal Dave (http://blog.SQLAuthority.com)

SQL Error Messages, SQL Server, SQL Service Pack
Previous Post
SQL SERVER – FIX: Error: 913, Severity: 16 – Could Not Find Database ID 3. Database May Not be Activated Yet or May be in Transition – SQL Service
Next Post
SQL SERVER – Script Upgrade Failure – RsFxFt.Dll::RsFxMgmtInitialize failed: Error 0x80070002

Related Posts

9 Comments. Leave new

Leave a Reply