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.

WORKAROUND/SOLUTION

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.

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

Published by Pinal Dave on SQLAuthority. More of my work at pinaldave.com.