One of my blog reader contacted me for assistance. Here is his email:
I am trying to install SQL Server on my laptop but getting below errors:
- 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.
- 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.
- 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 me in understanding the error and the fix of the issue?
Since the error messages were talking about compression so I checked MSDN to find whether SQL can be installed on compressed directory or not. And I found https://msdn.microsoft.com/en-us/library/ms143506.aspx (Hardware and Software Requirements for Installing SQL Server). This says “SQL Server Setup will block installations on read-only, mapped, or compressed drives”
Having said all this, in this era of faster disks and infinite storage. I am still wondering how many of you out there is using compression on your disks for files stored by applications? If we read the message it, the solution is simple. Here are the steps to un-compress a folder.
- On the desired folder (in our case “C:\Program Files”) right click and go to properties.
- Click on “Advanced” button.
- Uncheck the box “Compress the drive to save space”
- Click Apply and then Ok.
- Let the process finish.
Later I got message from the reader that he was able to install SQL without any further issues. As I say always, most of the error messages are self-explanatory. All we need is to understand how the system is being used. In this context it is worth to know there are few KB Articles (231347)
Reference: Pinal Dave (https://blog.sqlauthority.com)
Hello, sorry to come with the same question, but i have tried to apply toe solution decompressed even C/.. programme files/… MSS/… the same message keep on empeaching the installation
Could you help ?
Thank you in advance
Thank You Pinal Dave :-)
Eres un genio, gracias :)
I have this error on a system where the folder is shown as not compressed (there is no check in the box).
Thank you a lot!
Thanks it worked!
gracias la vdd buscaba esta solucion, como dices el mismo error nos indica donde esta el problema, en mi caso yo aplicaba el mismo paso pero en la carperta de archivos x86 y era en la otra carpeta de archivos aora si utilizo mi sql sin problema alguno gracias amigo !
saludos y suerte ..
thanks vdd seeking this solution, as you say the same error indicates where the problem is, in my case I applied the same step but in carperta file x86 and was in the other folder aora files if I use my sql without any problems thanks friend !
greetings and luck ..
Thanks you so much
Thanks for your comment Johnny.
Great ! thank you Pinal. This solution perfectly works.
Nice to hear that @Santhosh
Of course, that means we have to uncompress all our program files, many gigabytes. Also compressed files are often faster. This seems like a broken piece of Microsoftery.
if you get the message continually, make sure to check the error message. It might be pointing to the x86 or non-x86 program files subdirectory. This threw me off because I had SQL Server installed in both places until I saw the message was indicating a different directory but with similar looking name Hope this helps someone
I will try this solution later I will say something
Its not working on my computer, can someone help me?
thank you, that is great solution