Warning! Audit Deprecated
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.