Search filters this STIG's checks locally. Separate terms must all match (use quotes for an exact phrase). A search you ran on the Search page carries over here.
Assessment Title
Rule Text
If SQL Server authentication, using passwords, is employed, SQL Server must enforce the DoD standards for password complexity.
Description
Discussion Text
Windows domain/enterprise authentication and identification must be used (SQL2-00-023600). Native SQL Server authentication may be used only when circumstances make it unavoidable; and must be documented and 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 must be implemented.
The requirements for password complexity are:
a. minimum of 15 Characters, 1 of each of the following character sets:
- Upper-case
- Lower-case
- Numeric
- Special characters (e.g. ~ ! @ # $ % ^ & * ( ) _ + = - ' [ ] / ? > <)];
b. Minimum number of characters changed from previous password: 50% of the minimum password length (that is, 8).
To enforce this in SQL Server, configure each DBMS-managed login to inherit the rules from Windows.
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 must be implemented.
The requirements for password complexity are:
a. minimum of 15 Characters, 1 of each of the following character sets:
- Upper-case
- Lower-case
- Numeric
- Special characters (e.g. ~ ! @ # $ % ^ & * ( ) _ + = - ' [ ] / ? > <)];
b. Minimum number of characters changed from previous password: 50% of the minimum password length (that is, 8).
To enforce this in SQL Server, configure each DBMS-managed login to inherit the rules from Windows.
New to STIG checklists? Read What is a STIG checklist? and CKL vs CKLB.