Fix SQL Server Installation Error: Attributes do not match
Last week I was working on SQL Server installation where i got this error Attributes do not match. Error details of that issue are given below:
Microsoft.SqlServer.Configuration.Sco.DirectoryAttributesMissmatch: Attributes do not match. Present attributes (Directory, Compressed, NotContentIndexed) , included attributes (0), excluded attributes (Compressed, Encrypted).
You can get this issue during SQL Server installation or during SQL Server patching activity. Read this article to fix this issue.
- Install SQL Server on Ubuntu running without Internet
- SQL Server Architecture Interview Questions & Answers
- Fix Error 40: A Network-Related or Instance-Specific Error Occurred
We get this error “Attributes do not match” because one of the drive that we are using to install SQL Server is compressed. As we know, Microsoft does not support compressed drives for SQL Server installation so we’ll search for compressed drives on the database server. Best way to avoid this issue is to make a best practice to check whether any of the drives are compressed or not before starting SQL Server installation. You can also add this as a prerequisite or pre-step for SQL Server installation.
Once you get this issue, you can check all drives available on your database server whether they are compressed or not. If any drive is compressed and SQL Server is using that drive during installation then that might be the reason for getting issue Attributes do not match. You need to uncompress all such drives and then start the installation.
In order to uncompress the drive we need to launch property window of that drive. We just need to right click on the identified drive and choose Properties to see the status of compression. I checked the same and found one of our drive was compressed. Please have a look at below screenshot. You can see compress this drive to save disk space option is ticked. Uncheck this option and click on Ok button to apply the change.
Once you validated all drives that none of the drives are compressed then you can start SQL Server installation and this time SQL Server installation will be successful.
You might get this error during SQL Server patching as well if any of the SQL Server folders will be compressed. Remember to make a practice to not compress any SQL Server file or folder. If you get this error during applying SQL Server patches, you need to find the compressed folder and then perform same activity (uncompress the identified folder) for that folder which we performed for drive compression in above screenshot. This way you can fix SQL Server installation issue “Attributes do not match”.
- SQL Server Update Statistics Best Practices - April 15, 2020
- Understanding Hybrid Buffer Pool in SQL Server - December 30, 2018
- Fix:VIEW SERVER STATE permission was denied on object ‘server’, database ‘master’ - August 30, 2018