Q:

Microsoft Key Storage Provider for Always Encrypted Master Key

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

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.
Cheers!

A:

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.

