Summary information |
|
---|---|
Default value |
0 |
Range of values |
-1 – 32767 |
Status |
Dynamic |
Display level |
10 |
Required role |
System security officer |
Configuration group |
Security Related |
maximum failed logins allows you to set the server-wide maximum number of failed login attempts for logins and roles.
A value of -1 indicates that the failed login count in the syslogins column logincount is updated whenever an authentication failure occurs, but that the account is not locked. Compare with a 0 (zero) value, which avoids incrementing the column for every failed authentication and avoids locking the account due to authentication failures.
See the Reference Manual: Procedures for information about using sp_modifylogin to change the maximum failed logins for a specific role. See the Reference Manual: Commands for information about using alter role to change the maxiumum failed logins.