SV-276297r1150073_rule
V-276297
SRG-APP-000101-DB-000044
MSQL-D0-005500
CAT III
10
Create a new SQL Server Audit with the Microsoft support operations option enabled.
Adjust the following T-SQL Query for the environment and execute:
CREATE SERVER AUDIT [<Enter Name of Audit>] TO URL ( PATH = N'<URL for Blob Container>' ) WITH ( OPERATOR_AUDIT = ON ) GO
ALTER SERVER AUDIT [<Enter Name of Audit>] WITH (STATE = ON) GO
Alternatively, when using SQL Server Management Studio to create an audit, ensure the Microsoft support operations checkbox is flagged.
Review the system documentation to determine if the auditing of Microsoft support operations is required. If is documented as not required, this is Not Applicable.
If the system documentation requires the auditing of Microsoft Support operations, run the following query to determine whether an audit has been defined to capture Microsoft Support operations:
SELECT audit_id, name, is_state_enabled
FROM sys.server_audits
WHERE is_operator_audit = 1
If no audit is returned, this is a finding.
V-276297
False
MSQL-D0-005500
Review the system documentation to determine if the auditing of Microsoft support operations is required. If is documented as not required, this is Not Applicable.
If the system documentation requires the auditing of Microsoft Support operations, run the following query to determine whether an audit has been defined to capture Microsoft Support operations:
SELECT audit_id, name, is_state_enabled
FROM sys.server_audits
WHERE is_operator_audit = 1
If no audit is returned, this is a finding.
M
5711