Login Password Complexity Checks and sp_passwordpolicy

These login password complexity checks are extended to role passwords:

  • disallow simple passwords

  • min digits in password

  • min alpha in password

  • min special char in password

  • min upper char in password

  • min lower char in password

  • systemwide password expiration

  • password exp warn interval

  • minimum password length

  • maximum failed logins

  • expire login