III - Administrative Classified
Rules and Groups employed by this XCCDF Profile
-
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 -
Confidentiality of information during transmission is controlled through the use of an approved TLS version.
Transport Layer Security (TLS) encryption is a required security setting as a number of known vulnerabilities have been reported against Secure Sockets Layer (SSL) and earlier versions of TLS. Encr...Rule High Severity -
SRG-APP-000176-DB-000068
Group -
SQL Server must enforce authorized access to all PKI private keys stored/utilized by SQL Server.
The DoD standard for authentication is DoD-approved PKI certificates. PKI certificate-based authentication is performed by requiring the certificate holder to cryptographically prove possession of ...Rule High Severity -
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 -
SQL Server must uniquely identify and authenticate non-organizational users (or processes acting on behalf of non-organizational users).
Non-organizational users include all information system users other than organizational users, which include organizational employees or individuals the organization deems to have equivalent status...Rule Medium Severity -
SRG-APP-000224-DB-000384
Group -
SQL Server must maintain the authenticity of communications sessions by guarding against man-in-the-middle attacks that guess at Session ID values.
One class of man-in-the-middle, or session hijacking, attack involves the adversary guessing at valid session identifiers based on patterns in identifiers already known. The preferred technique ...Rule Medium Severity -
SRG-APP-000231-DB-000154
Group -
SQL Server must protect the confidentiality and integrity of all information at rest.
This control is intended to address the confidentiality and integrity of information at rest in non-mobile devices and covers user information and system information. Information at rest refers to ...Rule High Severity -
SRG-APP-000231-DB-000154
Group -
The Service Master Key must be backed up and stored in a secure location that is not on the SQL Server.
Backup and recovery of the Service Master Key may be critical to the complete recovery of the database. Creating this backup should be one of the first administrative actions performed on the serve...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.