Search

Tuesday, August 14, 2012

Attributes do not match

Sometime you may get this error when you are tying to upgrade SQL Server and drive where SQL Server binaries and/or shared features are installed is compressed with NTFS windows file system compression and/or encryption is enabled.

Attributes do not match. Present attributes (Directory, Compressed) , included attributes (0), excluded attributes (Compressed, Encrypted)

To solve above error: 
  • Go to “C:\Program Files”  and locate “Microsoft SQL Server” folder.
  • Right click and select properties. 
  • Go to Advanced option in General Tab. 
  • Here look for “Compress contents to save disk space” and “encrypt contents to secure data”. 
  • You will find these options as checked. 
  • Uncheck these options and apply the changes. 
  • Now run the install again and it will run successfully.

11 comments:

  1. Thanks for your post. This has helped me.

    ReplyDelete
  2. Thanks a lot. Very good understanding with very simple words, saved my time a lot.

    ReplyDelete
  3. Makes everything easy.. great job!!

    ReplyDelete
  4. Very helpful post. I was stuck with the same problem and your recommendations were really helpful

    ReplyDelete
  5. really nice.....those steps solved my issue....many many thanks..

    ReplyDelete
  6. Really useful post indeed. A million thanks.

    ReplyDelete
  7. I have checked but the folder is not compresses or encrypted.

    ReplyDelete
  8. I had two same errors. After unchecked options, there is still one more same error. Could you help me please?

    ReplyDelete
  9. Thanks a ton for this help

    ReplyDelete
  10. Thanks a lot.. vry useful ..

    ReplyDelete