SQL6-D0-008000 - Contained databases must use Windows principals.

Information

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 and Authorizing Official (AO)-approved.

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 requires AO approval.

In such cases, the DOD standards for password complexity and lifetime must be implemented. DBMS products that can inherit the rules for these from the operating system or access control program (e.g., Microsoft Active Directory) must be configured to do so. For other DBMSs, the rules must be enforced using available configuration parameters or custom code.

Solution

Configure the SQL Server contained databases to have users originating from Windows principals. Remove any users not created from Windows principals.

See Also

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

Item Details

Category: IDENTIFICATION AND AUTHENTICATION

References: 800-53|IA-5(1)(a), CAT|II, CCI|CCI-004066, Rule-ID|SV-213965r998248_rule, STIG-ID|SQL6-D0-008000, STIG-Legacy|SV-93899, STIG-Legacy|V-79193, Vuln-ID|V-213965

Plugin: MS_SQLDB

Control ID: 3c32b5390f59848c83faa8b21ae7cb263d75218236f4e7234245f5ac8deab102