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 be configured to generate audit records for DOD-defined auditable events within all DBMS/database components.

DISA Rule

SV-276295r1149794_rule

Vulnerability Number

V-276295

Group Title

SRG-APP-000089-DB-000064

Rule Version

MSQL-D0-004300

Severity

CAT II

CCI(s)

• CCI-000169 - Provide audit record generation capability for the event types the system is capable of auditing as defined in AU-2 a. on organization-defined information system components.

Weight

10

Fix Recommendation

Add all required audit events to the STIG Compliant audit specification server documentation.

Refer to the supplemental file "AzureSQLMIAudit.sql" script.

Reference: https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/auditing-configure?view=azuresql

Check Contents

Review documentation to determine if any additional events are required to be audited. If no additional events are required, this is not a finding.

Execute the following query to get all of the audits:

SELECT name AS 'Audit Name',
status_desc AS 'Audit Status',
audit_file_path AS 'Current Audit File'
FROM sys.dm_server_audit_status
WHERE name NOT IN ('admin_audit','SqlDbThreatDetection_ServerAudit')

If no audits are returned, this is a finding.

To view the actions being audited by the audits, execute the following query:

SELECT a.name AS 'AuditName',
s.name AS 'SpecName',
d.audit_action_name AS 'ActionName',
d.audited_result AS 'Result'
FROM sys.server_audit_specifications s
JOIN sys.server_audits a ON s.audit_guid = a.audit_guid
JOIN sys.server_audit_specification_details d ON s.server_specification_id = d.server_specification_id
WHERE a.is_state_enabled = 1

Compare the documentation to the list of generated audit events. If there are any missing events, this is a finding.

Vulnerability Number

V-276295

Documentable

False

Rule Version

MSQL-D0-004300

Severity Override Guidance

Review documentation to determine if any additional events are required to be audited. If no additional events are required, this is not a finding.

Execute the following query to get all of the audits:

SELECT name AS 'Audit Name',
status_desc AS 'Audit Status',
audit_file_path AS 'Current Audit File'
FROM sys.dm_server_audit_status
WHERE name NOT IN ('admin_audit','SqlDbThreatDetection_ServerAudit')

If no audits are returned, this is a finding.

To view the actions being audited by the audits, execute the following query:

SELECT a.name AS 'AuditName',
s.name AS 'SpecName',
d.audit_action_name AS 'ActionName',
d.audited_result AS 'Result'
FROM sys.server_audit_specifications s
JOIN sys.server_audits a ON s.audit_guid = a.audit_guid
JOIN sys.server_audit_specification_details d ON s.server_specification_id = d.server_specification_id
WHERE a.is_state_enabled = 1

Compare the documentation to the list of generated audit events. If there are any missing events, this is a finding.

Check Content Reference

M

Target Key

5711