Details

SQL Server must prevent unauthorized and unintended information transfer via shared system resources. Permitting only SQL Server processes and authorized, administrative users to have access to the files where the database resides helps ensure that those files are not shared inappropriately and are not open to backdoor access and manipulation.

NOTE: Nessus has provided the target output to assist in reviewing the benchmark to ensure target compliance.

Solution

Remove any unauthorized permission grants from SQL Server data, log, and backup directories.

1) On the ‘Security’ tab, highlight the user entry.
2) Click ‘Remove’.

Supportive Information

The following resource is also helpful.

• https://dl.dod.cyber.mil/wp-content/uploads/stigs/zip/U_MS_SQL_Server_2016_Y22M01_STIG.zip

This security hardening control applies to the following category of controls within NIST 800-53: System and Communications Protection.This control applies to the following type of system Windows.

References

• 800-53|SC-4
• CAT|II
• CCI|CCI-001090
• Rule-ID|SV-213977r754622_rule
• STIG-ID|SQL6-D0-010000
• STIG-Legacy|SV-93921
• STIG-Legacy|V-79215
• Vuln-ID|V-213977

Source

• Tenable.com/audits