SQL Server must support the employment of automated mechanisms supporting the auditing of the enforcement actions.

Overview

Finding ID	Version	Rule ID	IA Controls	Severity
V-40950	SQL2-00-014700	SV-53304r1_rule		Medium

Description
Any changes to the hardware, software, and/or firmware components of the information system and/or application can potentially have significant effects on the overall security of the system. Accordingly, only qualified and authorized individuals are allowed to obtain access to information system components for purposes of initiating changes, including upgrades and modifications. Access restrictions for change also include software libraries. Examples of access restrictions include: physical and logical access controls, workflow automation, media libraries, abstract layers (e.g., changes are implemented into a third-party interface rather than directly into the information system component), and change windows (e.g., changes occur only during specified times, making unauthorized changes outside the window easy to discover).

Description

Any changes to the hardware, software, and/or firmware components of the information system and/or application can potentially have significant effects on the overall security of the system. Accordingly, only qualified and authorized individuals are allowed to obtain access to information system components for purposes of initiating changes, including upgrades and modifications. Access restrictions for change also include software libraries. Examples of access restrictions include: physical and logical access controls, workflow automation, media libraries, abstract layers (e.g., changes are implemented into a third-party interface rather than directly into the information system component), and change windows (e.g., changes occur only during specified times, making unauthorized changes outside the window easy to discover).

STIG	Date
Microsoft SQL Server 2012 Database Instance Security Technical Implementation Guide	2014-01-05

Details

Check Text ( C-47605r2_chk )
Verify that Files and Folders that are part of the SQL Server 2012 Installation have auditing enabled. Determine audit file locations: Obtain SQL Server Audit file location(s) by Running the following SQL script: Select * from sys.traces For each audit the path column will give the location of the file. On the Security Tab, click Advanced. On the Auditing Tab, verify that the following is configured on the audits returned from previous query: Type: All Principal: Everyone Access: Modify Applies to: This Folder, subfolder, and files* If auditing is not enabled for each file location found above, this is a finding.

Check Text ( C-47605r2_chk )

Verify that Files and Folders that are part of the SQL Server 2012 Installation have auditing enabled.

Determine audit file locations:

Obtain SQL Server Audit file location(s) by Running the following SQL script:

Select * from sys.traces

For each audit the path column will give the location of the file.

On the Security Tab, click Advanced.

On the Auditing Tab, verify that the following is configured on the audits returned from previous query:

Type: All
Principal: Everyone
Access: Modify
Applies to: This Folder, subfolder, and files*

If auditing is not enabled for each file location found above, this is a finding.

Fix Text (F-46232r2_fix)
For each audit file location, select the Security Tab, click Advanced. On the Auditing Tab, verify that the following is configured on the audits returned from previous query: Type: All Principal: Everyone Access: Modify Applies to: This Folder, subfolder, and files