maximum failed logins specifies the maximum number of failed logins that can occur before the login is locked. You specify this value globally. Valid values are:
0 – logins are never locked, regardless of the number of failed login attempts.
1 through 32767 – the number of failed logins that can occur before the login is locked.
By default, this value is turned off and this check is not applied to passwords.
To set the number of failed logins allowed, enter:
sp_passwordpolicy 'set', 'maximum failed logins', number
