Hello,

During installations, I got the following error:

1) 

Microsoft.SqlServer.Configuration.Sco.DirectoryAttributesMissmatch: Folder C:\Program Files\Microsoft SQL Server has an unsupported attribute (Compressed) set. Please resolve this issue by removing the unsupported attribute from the folder using folder properties dialog.

2)

Microsoft.SqlServer.Configuration.SetupExtension.CompressedDirException: The specified directory, "C:\Program Files\Microsoft SQL Server\", for the INSTALLSHAREDDIR parameter is not valid because this directory is compressed or is in a compressed directory. Specify a directory that is not compressed.

3)

Microsoft.SqlServer.Configuration.SetupExtension.CompressedDirException: The specified directory, "C:\Program Files (x86)\Microsoft SQL Server\", for the INSTALLSHAREDWOWDIR parameter is not valid because this directory is compressed or is in a compressed directory. Specify a directory that is not compressed.

Can you help with these errors?

• Moved by Kalman Toth Tuesday, February 10, 2015 1:24 PM Not T-SQL

Hello,

SQL Server cannot be installed on a compressed folder/drive.

SQL Server Setup will block installations on read-only, mapped, or compressed drives.

Source:  https://msdn.microsoft.com/en-us/library/ms143506.aspx

Hope this helps.

Regards,

Alberto Morillo
SQLCoffee.com

• Proposed as answer by Olaf HelperMVP Tuesday, February 10, 2015 1:35 PM

Hello,

Do you have the drive or some folders encrypted (Bitlocker, etc.) too? SQL Server setup will block installation on compressed and encrypted drive.

Any chance you have left some folders compressed.

Have you disable any security software?

Hope this helps.

Regards,

Alberto Morillo
SQLCoffee.com

• Edited by Alberto MorilloMVP, Moderator Tuesday, February 10, 2015 1:59 PM

Hello,

The following resources show a few ways to list those directories.

https://superblackbook.wordpress.com/2010/07/20/powershell-list-compressed-dossiersfichiers/

https://social.technet.microsoft.com/forums/windowsserver/en-US/153c2740-e2b6-47b8-beb1-1da7ba08b1f1/find-compressed-file-or-folders

Hope this helps.

Regards,

Alberto Morillo
SQLCoffee.com

• Proposed as answer by Shanky_621MVP Tuesday, February 10, 2015 7:19 PM
• Marked as answer by Lydia ZhangMicrosoft contingent staff, Moderator Thursday, February 19, 2015 7:07 AM

Thank you

• Marked as answer by Jide James Friday, February 20, 2015 11:45 AM

Hello,

First, right click on your c drive, choose properties, then you will see option to compress, unticked this box, then click ok.

Secondly, right click again on your c drive, open it, from the list pick Program files.  Right click on Program files, then select Security. In the Security, change permission to full control.

You must have register as a user. Change the permission for user of this file (in your name) to full control.

Then, you will have full installation right to install this files.

I hope that you find this helpful, if not, let me know what error message you have again.

Regards,

James