×


Attributes do not match - Fix this SQL Server Installation Error

Are you facing the error, Attributes do not match?

This guide is for you.


Attributes do not match SQL Server error happens during SQL Server installation or during SQL Server patching activity.
In fact, this error "Attributes do not match" because one of the drive that we are using to install SQL Server is compressed.
Here at Ibmi Media, as part of our Server Management Services, we regularly help our Customers to resolve related SQL queries.
In this context, we shall look into how to resolve the SQL Server Installation Error.

Nature of the error, SQL Attributes do not match

The error message looks like this:

Microsoft.SqlServer.Configuration.Sco.DirectoryAttributesMismatch: Attributes do not match. Present attributes (Directory, Compressed, NotContentIndexed), included attributes (0), excluded attributes (Compressed, Encrypted).

The major cause of this error can be if the drive we use to install SQL Server is compressed. Microsoft does not support this.
In order to avoid this issue is to make sure whether any of the drives are compressed or not before the SQL Server installation.

Method to fix Attributes do not match SQL Server error ?

We can check all the drives to see if they are compressed or not. If it is and if the SQL server uses that drive during installation, it might result in the error.
To avoid this, we need to remove the compression for those drives and then start the installation.
In order to remove the compression for the drive, we need to launch property window of that drive.
1. Right-click on the identified drive and choose Properties to see the status of compression.
2. Uncheck the "Compress this drive to save disk space" option and click OK to apply the change.
3. Once we validate all drives, then we can start SQL Server installation and it will be successful.

We might get this error during SQL Server patching as well if any of the SQL Server folders compress.
Make it a practice to not compress any SQL Server file or folder.
If we get this error during applying SQL Server patches, we need to find the folder and remove the compression.

[Need help in fixing SQL errors? We can help you. ]


Conclusion

This article covers how to resolve the error, SQL Attributes do not match. Basically, the error, Attributes do not match occurs during SQL Server installation or during SQL Server patching activity.
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.

To uncompress the drive we need to launch property window of that drive:
1. We just need to right click on the identified drive and choose Properties to see the status of compression.
2. You can see compress this drive to save disk space option is ticked.
3. Uncheck this option and click on OK button to apply the change.
4. 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.

When installing SQL server and running into an error "Attributes do not match.
Present attributes (Directory, Compressed) , included attributes (0), excluded attributes (Compressed, Encrypted)".
This is because you are trying to install SQL into a folder that is compressed which is not supported.
To fix this;
1. Navigate to C:\Program Files\Microsoft SQL server folder
2. Right click on properties on SQL Server folder.  
3. Under advanced option in general tab, look for compress contents to save disk space, uncheck it.
4. Also, uncheck "encrypt contents to secure data"
5. Re-run the SQL install