MS SQL Server 2016 Instance Security Technical Implementation Guide
Rules, Groups, and Values defined within the XCCDF Benchmark
-
SRG-APP-000142-DB-000094
Group -
SRG-APP-000142-DB-000094
Group -
SQL Server must be configured to prohibit or restrict the use of organization-defined ports, as defined in the PPSM CAL and vulnerability assessments.
In order to prevent unauthorized connection of devices, unauthorized transfer of information, or unauthorized tunneling (i.e., embedding of data types within data types), organizations must disable...Rule Medium Severity -
SRG-APP-000148-DB-000103
Group -
SRG-APP-000164-DB-000401
Group -
If DBMS authentication using passwords is employed, SQL Server must enforce the DOD standards for password complexity and lifetime.
Windows Authentication is the default authentication mode and is much more secure than SQL Server Authentication. Windows Authentication uses Kerberos security protocol, provides password policy en...Rule High Severity -
SRG-APP-000164-DB-000401
Group -
Contained databases must use Windows principals.
OS/enterprise authentication and identification must be used (SRG-APP-000023-DB-000001). Native DBMS authentication may be used only when circumstances make it unavoidable, and must be documented a...Rule Medium Severity -
SRG-APP-000172-DB-000075
Group -
If passwords are used for authentication, SQL Server must transmit only encrypted representations of passwords.
The DOD standard for authentication is DOD-approved PKI certificates. Authentication based on User ID and Password may be used only when it is not possible to employ a PKI certificate and requir...Rule High Severity -
SRG-APP-000172-DB-000075
Group -
SRG-APP-000176-DB-000068
Group -
SRG-APP-000179-DB-000114
Group -
SQL Server must use NIST FIPS 140-2 or 140-3 validated cryptographic modules for cryptographic operations.
Use of weak or not validated cryptographic algorithms undermines the purposes of utilizing encryption and digital signatures to protect data. Weak algorithms can be easily broken, and not validated...Rule High Severity -
SRG-APP-000180-DB-000115
Group -
SRG-APP-000224-DB-000384
Group -
SRG-APP-000231-DB-000154
Group -
SRG-APP-000231-DB-000154
Group -
SRG-APP-000231-DB-000154
Group -
The Master Key must be backed up and stored in a secure location that is not on the SQL Server.
Backup and recovery of the Master Key may be critical to the complete recovery of the database. Not having this key can lead to loss of data during recovery.Rule Medium Severity
Node 2
The content of the drawer really is up to you. It could have form fields, definition lists, text lists, labels, charts, progress bars, etc. Spacing recommendation is 24px margins. You can put tabs in here, and can also make the drawer scrollable.