1

I see that i can manage encryption through the option: right click database->tasks->manage database encryption

I see two options using asymmetric key or certificate as shown below enter image description here

but i don't see an upload option of the key or certficate .

Can somebody please let me know how to upload a certificate and enable the encryption?

Thank you

2

SSMS GUI expects you to Create your server certificate before you mange database encryption.

Ref: CREATE CERTIFICATE (Transact-SQL)

Once you create the server certificate you you will be able to chose from the drop down box.

CREATE CERTIFICATE testencryptioncert   
   ENCRYPTION BY PASSWORD = 'pGFD4bb925DGvbd2439587y'  
   WITH SUBJECT = 'Testing Encryption',   
   EXPIRY_DATE = '20201031';  
GO

Now the above certificate will show up in the drop down list of the GUI.

enter image description here

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.