Skip to content

Azure SQL Database must implement cryptographic mechanisms to prevent unauthorized modification of organization-defined information at rest (to include, at a minimum, PII and classified information) on organization-defined information system components.

An XCCDF Rule

Description

Azure SQL Databases handling data requiring "data at rest" protections must employ cryptographic mechanisms to prevent unauthorized disclosure and modification of the information at rest. Selection of a cryptographic mechanism is based on the need to protect the integrity of organizational information. The strength of the mechanism is commensurate with the security category and/or classification of the information. The decision whether and what to encrypt rests with the data owner and is also influenced by the physical measures taken to secure the equipment and media on which the information resides.

ID
SV-255321r1018558_rule
Version
ASQL-00-003300
Severity
High
References
Updated

Remediation Templates

A Manual Procedure

If Azure SQL Database Transparent Data Encryption is disabled, use the Set-AzSqlDatabaseTransparentDataEncryption command to enable. 

$LogicalServerName = "myServer" 
$RGname = "myRG" 
$DBname = "myDatabase" 
$TDEstate = "Enabled"