Hoping someone can help-

I've been experimenting with Always Encrypted columns and have generated a certificate in the "Microsoft Software Key Storage Provider" - Always-Encrypted-Auto1

How can I remove the "Always-Encrypted-Auto1" entry?

using SQL Express 2017 with SQL Management Studio 17. Have not found an answer to this question via conventional search engine means or via dba.stackexchange.com.


  • Explain the down vote? Aug 8 '18 at 0:44
  • While I didn't cast the vote, I guess you received it because of the quality of your question. In Why is voting important? there is a sentence that reads: "...while voting down a post signals the opposite: that the post contains wrong information, is poorly researched, or fails to communicate information.". (empasis mine)
    – John K. N.
    Aug 8 '18 at 6:53
  • Without a comment, it's all conjecture, however I've added some clarity to the question so that others in future will know versions and search methods.. Aug 9 '18 at 0:55

How can I remove the "Always-Encrypted-Auto1" entry?

Since there isn't a way in the SSMS GUI and I doubt you want to write your own code to find out, look in %APPDATA%\Microsoft\Crypto\Keys and attempt to figure out based on date which file it may be.

  • Thanks Sean, had already tried this earlier this morning but didn't work, tried again and restarted the machine which did work - potentially cached in some way? Aug 8 '18 at 1:19
  • 1
    It could have been in cached in memory if it was actively being used by SQL Server. @m.t.bennett Aug 8 '18 at 14:08

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.