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;