Toad World® Forums

nabling parameterization for always encrypted in Toad for SQL Server


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 Beta Version.



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.