SQL Server Encryption – Microsoft Key Storage Provider for Always Encrypted Master Key

always-encryptedcertificatesql serversql-server-2017ssms

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.

Cheers!

Best Answer

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.

Related Question