Setting the CHECK_POLICY option to ON for all the SQL authenticated logins
Note: Changing this setting can impact all the other products on the
database server that use the SQL authentication. Ensure that the settings do
not impact the other products.
The password complexity policy is same for the Windows and the SQL Server.
Ensure that the SQL authenticated login passwords comply with the secure password policy applied by the Windows server benchmark so that the passwords cannot be easily compromised through the brute force attack.
Execute the T-SQL query by replacing the
[login_name]
with the SQL authenticated
logins.
ALTER LOGIN [login_name] WITH CHECK_POLICY = ON;