Error:
SQL Server setup cannot install files to the compressed or encrypted folder: C:\Program Files\Microsoft SQL Server\. To continue, make sure that your installation directories are not compressed or encrypted, or specify a different directory, and then run SQL Server Setup again.
Snapshot:
Solution 1:
SQL Express really doesn’t like compressed folders. You can tell a folder is compressed if it appears to have a blue name instead of a black name.
How to Fix:
Uncompress the “C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data” directory by following these steps:
- Navigate “C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\” folder
- Right-click on “Data” folder and choose Properties.
- Click the Advanced button.
- Uncheck the box that says ‘Compress contents to save disk space’
- Click OK.
- When prompted, make sure you apply changes to all folders, subfolders and files.