Detections
Analytics
SQL2-00-018600 - SQL Server must enforce password encryption for storage.
Information
SQL Server must enforce password encryption when storing passwords. Passwords need to be protected at all times, and encryption is the standard method for protecting passwords. If passwords are not encrypted, they can be plainly read and easily compromised.Passwords stored in clear text are vulnerable to unauthorized disclosure. Database passwords should always be encoded or encrypted when stored internally or externally to SQL Server.
NOTE: Nessus has not performed this check. Please review the benchmark to ensure target compliance.
Solution
Develop, document, and maintain a list of SQL Server database objects, database configuration files, associated scripts, and applications defined within or external to SQL Server that access the database/user environment files/settings in the System Security Plan.Record whether they do or do not contain SQL Server passwords. If passwords are present, ensure they are encrypted.
See Also
https://dl.dod.cyber.mil/wp-content/uploads/stigs/zip/U_MS_SQL_Server_2012_V1R20_STIG.zip
Item Details
Category: IDENTIFICATION AND AUTHENTICATION
References: 800-53|IA-5(1)(c), CAT|II, CCI|CCI-000196, Rule-ID|SV-53276r2_rule, STIG-ID|SQL2-00-018600, Vuln-ID|V-40922
Plugin: MS_SQLDB
Control ID: 74010b67a323081057899d51a550e5df7161f758c5f54a831592f537884be8f8