Control: 4.1.2 Ensure that 'Data encryption' is set to 'On' on a SQL Database
Description
It is recommended to enable Transparent Data Encryption on every SQL database. Azure SQL database transparent data encryption helps to protect against the threat of malicious activity by performing real-time encryption and decryption of the database, associated backups and transaction log files at rest without requiring changes to the application.
Transparent Data Encryption (TDE) can be enabled or disabled on individual SQL Database level and not on the SQL Server level. TDE cannot be used to encrypt the logical master database in SQL Database.
Default setting for Transparent data encryption is set to On.
Remediation
From Console
- Login to Azure console and navigate to SQL Databases.
- For each DB instance, go to Security section from left pane.
- Click on
Transparent data encryption. - Set
Transparent data encryptionto On. - Click Save.
From Command Line
az sql db tde set --resource-group <resourceGroup> --server <dbServerName> -- database <dbName> --status Enabled
Usage
Run the control in your terminal:
powerpipe control run azure_compliance.control.cis_v130_4_1_2Snapshot and share results via Turbot Pipes:
powerpipe loginpowerpipe control run azure_compliance.control.cis_v130_4_1_2 --shareSQL
This control uses a named query:
sql_database_transparent_data_encryption_enabled