SQL Server or software monitoring SQL Server must provide an immediate real-time alert to appropriate support staff of all audit failure events requiring real-time alerts.

From MS SQL Server 2014 Instance Security Technical Implementation Guide

Associated with: CCI-001858

SV-82385r1_rule SQL Server or software monitoring SQL Server must provide an immediate real-time alert to appropriate support staff of all audit failure events requiring real-time alerts.

Vulnerability 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.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 the system documentation to determine which audit failure events require real-time alerts. Review settings in SQL Server, Windows, and any monitoring software. If the real-time alerting that is specified in the documentation is not enabled, this is a finding.

Fix text

Configure the system to provide an immediate real-time alert to appropriate support staff when a specified audit failure occurs.

Pro Tips

Lavender hyperlinks in small type off to the right (of CSS class id, if you view the page source) point to globally unique URIs for each document and item. Copy the link location and paste anywhere you need to talk unambiguously about these things.

You can obtain data about documents and items in other formats. Simply provide an HTTP header Accept: text/turtle or Accept: application/rdf+xml.