Sql server login password strength

Applies to: SQL Server

This rule checks whether "Enforce password policy" of each SQL Server login is enabled. If SQL Server Authentication is enabled and if the operating system version is earlier than Windows Server 2003, an attacker could repeatedly exploit a known SQL Server login password.

Best practices recommendations

We recommend that you upgrade the operating system to Windows Server 2003.

If SQL Server Authentication isn't required in your environment, use Windows Authentication.

Enable "Enforce password policy" for all the SQL Server logins. Use ALTER LOGIN to configure the password policy for the SQL Server login.

For more information

Password Policy