Encryption Key for data protection

ahmed7 · Post by **ahmed7** » Wed Apr 03, 2024 10:26 pm

Hello
I use v24
I made (encrypted columns) in my database and get certificate file.
but how can use that with the information in (Advanced Settings) which is Encryption Key for data protection because in (encrypted columns) there is no key but there is certificate file.
I hope to get help please

MichaelG · Post by **MichaelG** » Thu Apr 04, 2024 7:17 am

You should set up Tools -> Advanced Settings -> Encryption key for data protection.

ahmed7 · Post by **ahmed7** » Thu Apr 04, 2024 12:51 pm

I know I should go there but I want to know how to setup that .
the column encryption has certification not key to put there

MichaelG · Post by **MichaelG** » Fri Apr 05, 2024 7:25 am

The encryption key is used for the Field Encryption extension which is for registered users only.

If you are referring to SQL Server column encryption, you are on your own to implement the encryption and decryption. You can google for "SQL Server column encryption and decryption" for solutions.