1.6.6 Authentication mode

Warning! Audit Deprecated

This audit has been deprecated and will be removed in a future update.

View Next Audit Version

Information

Level 1, Scorable
When possible, the SQL instance should be in Windows-only authentication mode. Mixed-mode authentication should only be used in those
situations where it is absolutely necessary.
Windows provides a more robust authentication mechanism than SQL Server authentication. If SQL Server authentication is required,
configure SQL Server account password and lockout properties with local or domain-based group policies.
ref. https://benchmarks.cisecurity.org/tools2/sqlserver/CIS_Microsoft_SQL_Server_2005_Benchmark_v2.0.0.pdf, pg 35.