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.
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)