STIGQter: STIG Summary: Microsoft Azure SQL Managed Instance Security Technical Implementation Guide Version: 1 Release: 1 Benchmark Date: 23 Sep 2025:

Azure SQL Managed Instance must implement cryptographic mechanisms preventing the unauthorized disclosure of organization-defined information at rest on organization-defined information system components.

DISA Rule

SV-276238r1150056_rule

Vulnerability Number

V-276238

Group Title

SRG-APP-000429-DB-000387

Rule Version

MSQL-00-003400

Severity

CAT II

CCI(s)

• CCI-002476 - Implement cryptographic mechanisms to prevent unauthorized disclosure of organization-defined information at rest on organization-defined system components.

Weight

10

Fix Recommendation

For any database with an is_encrypted status of "0", use the query below to enable transparent data encryption:

ALTER DATABASE [Database Name Here] SET ENCRYPTION ON;

Check Contents

Review the system documentation to determine whether the organization has defined the information at rest that is to be protected from modification, which must include, at a minimum, PII and classified information.

If no information is identified as requiring such protection, this is not a finding.

Review the configuration of the Azure SQL Managed Instance to ensure data-at-rest protections are implemented.

If any of the information defined as requiring cryptographic protection from modification is not encrypted in a manner that provides the required level of protection, this is a finding.

Use the query below to check the encryption status for each database. If any databases have an is_encrypted status of "0", this is a finding.

SELECT [name] AS DatabaseName,is_encrypted FROM master.sys.databases WHERE database_id > 4;

Vulnerability Number

V-276238

Documentable

False

Rule Version

MSQL-00-003400

Severity Override Guidance

Review the system documentation to determine whether the organization has defined the information at rest that is to be protected from modification, which must include, at a minimum, PII and classified information.

If no information is identified as requiring such protection, this is not a finding.

Review the configuration of the Azure SQL Managed Instance to ensure data-at-rest protections are implemented.

If any of the information defined as requiring cryptographic protection from modification is not encrypted in a manner that provides the required level of protection, this is a finding.

Use the query below to check the encryption status for each database. If any databases have an is_encrypted status of "0", this is a finding.

SELECT [name] AS DatabaseName,is_encrypted FROM master.sys.databases WHERE database_id > 4;

Check Content Reference

M

Target Key

5711