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.

Related Articles

Root Cause 

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. 

Solution

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.

disk compression

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

I hope you like this article. Please follow our Facebook page and Twitter handle to get latest updates.

Follow me:

Manvendra Deo Singh

I am working as a Technical Architect in one of the top IT consulting firm. I have expertise on all versions of SQL Server since SQL Server 2000. I have lead multiple SQL Server projects like consolidation, upgrades, migrations, HA & DR. I love to share my knowledge. You can contact me on my social accounts for any consulting work.
Manvendra Deo Singh
Follow me:
Summary
Fix SQL Server Installation Error: Attributes do not match
Article Name
Fix SQL Server Installation Error: Attributes do not match
Description
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 as well. Read this article to fix this issue.
Author
Publisher Name
www.techyaz.com

You may also like...

Leave a Reply

Your email address will not be published. Required fields are marked *