Check: SQL4-00-033500
MS SQL Server 2014 Instance STIG:
SQL4-00-033500
(in versions v2 r3 through v1 r10)
Title
SQL Server or software monitoring SQL Server must provide an immediate real-time alert to appropriate support staff of all audit log failures. (Cat II impact)
Discussion
It is critical for the appropriate personnel to be aware if a system is at risk of failing to process audit logs as required. Without a real-time alert, security personnel may be unaware of an impending failure of the audit capability, and system operation may be adversely affected. As noted elsewhere in this document, SQL Server's Audit and/or Trace features can be used for auditing purposes. This requirement applies to both. The appropriate support staff include, at a minimum, the ISSO and the DBA/SA. A failure of database auditing will result in either the database continuing to function without auditing or in a complete halt to database operations. When audit processing fails, appropriate personnel must be alerted immediately to avoid further downtime or unaudited transactions Alerts provide organizations with urgent messages. Real-time alerts provide these messages immediately (i.e., the time from event detection to alert occurs in seconds or less).
Check Content
Review SQL Server settings, OS, or third-party logging software settings to determine whether a real-time alert will be sent to the appropriate personnel when auditing fails for any reason. If real-time alerts are not sent upon auditing failure, this is a finding.
Fix Text
Configure the system to provide immediate real-time alerts to appropriate support staff when an audit log failure occurs.
Additional Identifiers
Rule ID: SV-213870r855542_rule
Vulnerability ID: V-213870
Group Title: SRG-APP-000360-DB-000320
Expert Comments
CCIs
Number | Definition |
---|---|
CCI-001858 |
The information system provides a real-time alert in an organization-defined real-time period to organization-defined personnel, roles, and/or locations when organization-defined audit failure events requiring real-time alerts occur. |
Controls
Number | Title |
---|---|
AU-5 (2) |
Real-Time Alerts |