I have been tasked with encrypting all data on an SQL database (SQL 2016 standard).
However this doesnt support TDE (Transparent Data Encryption) when I try I get the below error.
Transparent Data Encryption is not available in the edition of this SQL Server instance. See books online for more details on feature support in different SQL Server editions.
- Product Version: 13.0.4001.0
- Product Name: SQL Server 2016
- Product Level: SP1
- Product Edition: Standard Edition (64-bit)
So I am guessing my only option is to use "always encrypted"? I have opened the wizard and can only pick columns one at a time, is there a way to select all columns in all tables and encrypt them?