Toad World® Forums

nabling parameterization for always encrypted in Toad for SQL Server

#1

am using SQL Server Always encrypted.

I have added Column Encryption Setting Enabled to the advanced connection properties and I can now see my encrypted column in plain text.

however I am not sure in TOAD where to add the enable parameterization for always encrypted so I can query the encrypted column.

Toad for SQL Server 7.0.2.615 Beta Version.

#2

Hi,

Pls try to the two ways:

  1. right click on one database in Object Explorer->Encrypt DataBase
  2. go to Connection->Advanced, add parameter name 'Column Encryption Setting=True'

Hope that it can help you.

Thanks,
Michael