3.4 Ensure SQL Authentication is not used in contained databases

Information

Contained databases do not enforce password complexity rules for SQL Authenticated users.

Rationale:

The absence of an enforced password policy may increase the likelihood of a weak credential being established in a contained database.

Solution

Leverage Windows Authenticated users in contained databases.

Impact:

While contained databases provide flexibility in relocating databases to different instances and different environments, this must be balanced with the consideration that no password policy mechanism exists for SQL Authenticated users in contained databases.

Default Value:

SQL Authenticated users (USER WITH PASSWORD authentication) are allowed in contained databases.

See Also

https://workbench.cisecurity.org/files/2945

Item Details

Category: IDENTIFICATION AND AUTHENTICATION

References: 800-53|IA-2, CSCv6|16.12, CSCv7|16.2

Plugin: MS_SQLDB

Control ID: 2345c12f920cd50c7cb13d7375088bd0c470bab15716816f1c4e413573fc828c