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