STIGUI
V-213940CAT II — Medium severitySV-213940r960888_rule

SQL Server must initiate session auditing upon startup.

Rule version SQL6-D0-004700 · STIG v3 · 2025-12-08

Discussion

Session auditing is for use when a user's activities are under investigation. To be sure of capturing all activity during those periods when session auditing is in use, it needs to be in operation for the whole time SQL Server is running.

Check

When Audits are enabled, they start up when the instance starts. https://msdn.microsoft.com/en-us/library/cc280386.aspx#Anchor_2

Check if an audit is configured and enabled.

Execute the following query:

SELECT name AS 'Audit Name', status_desc AS 'Audit Status', audit_file_path AS 'Current Audit File' FROM sys.dm_server_audit_status WHERE status_desc = 'STARTED'

All currently defined audits for the SQL server instance will be listed. If no audits are returned, this is a finding.

Fix

Configure the SQL Audit(s) to automatically start during system start-up.

ALTER SERVER AUDIT [<Server Audit Name>] WITH STATE = ON

Execute the following query:

SELECT name AS 'Audit Name', status_desc AS 'Audit Status', audit_file_path AS 'Current Audit File' FROM sys.dm_server_audit_status WHERE status_desc = 'STARTED'

Ensure the SQL STIG Audit is configured to initiate session auditing upon startup.

Identifiers

Group ID
V-213940
Group title
SRG-APP-000092-DB-000208
Rule ID
SV-213940r960888_rule
Check ID
C-15157r313603_chk
Fix ID
F-15155r313604_fix