SQL Server account lock out

• PMar

  Mr or Mrs. 500

  Points: 569

  More actions

  September 9, 2011 at 4:01 pm

  #244624

  When password policy is checked for a SQL Server login account, after 'X' successive failed logins, the account get's locked.

  How to determine the max. number of failed login attempts 'X' before an account gets locked? Is it a setting that can be controlled on the SQL Server level in order to lock an account after a limited no. of failed attempts?

• Welsh Corgi

  SSC Guru

  Points: 116520

  More actions

  September 9, 2011 at 4:20 pm

  #1379536

  Duplicate Post.

  http://www.sqlservercentral.com/Forums/Topic1172870-359-1.aspx

  For better, quicker answers on T-SQL questions, click on the following...
  http://www.sqlservercentral.com/articles/Best+Practices/61537/

  For better answers on performance questions, click on the following...
  http://www.sqlservercentral.com/articles/SQLServerCentral/66909/