Password

• RPSQL

  Hall of Fame

  Points: 3229

  More actions

  February 4, 2009 at 8:36 am

  #155225

  Is there any way to set up number of times(i.e. 5 times) use can try to login after the account will get locked out?

• MANU-J.

  SSC-Dedicated

  Points: 31126

  More actions

  February 4, 2009 at 8:57 am

  #938048

  This is controlled by OS level setting

  http://technet.microsoft.com/en-us/library/cc758659.aspx

  MJ

• RPSQL

  Hall of Fame

  Points: 3229

  More actions

  February 4, 2009 at 1:16 pm

  #938349

  Thanks for the link. Can we setup the number of attempt the user can make before he get locked out from there?

• MANU-J.

  SSC-Dedicated

  Points: 31126

  More actions

  February 5, 2009 at 12:02 pm

  #939107

  Yes, we can as in 2005 this can be controlled by OS and applicable for SQL Server logins if password policy option is checked under login screen.

  MJ