Connecting to Column Encrypted Database
Additional database connection parameters are required to show encrypted columns in plaintext.
The parameter is entered at the Connect to Database Engine
logon screen. Select the required server name and click on Options>>
. Select the Additional Connection Parameters
tab then add the connection string Column Encryption Setting = enabled
and then click Connect
.
The first time you query the database you may get the Parameterization for Always Encrypted
prompt. Click on Enable
to proceed.
Running queries on the table will now show the original values decrypted by the CEK.