I think, it uses the Windows Password Policy
SKG: Please Marked as Answered, if it resolves your issue. (b: http://sudeeptaganguly.wordpress.com)
I dont think we can use t-sql to set because it uses the windows local password policies ,because in SQL Server 2008 uses the password policy enforcement settings from the domain or local machine.
The account lockout(i,e the Number of incorrect login attems will get locks out) is based on the Windows password security Polcicies that set.
Start ->run ->Gpedit.msc->windows settings ->security settings->check for the Account Lockout Threshold
Rama Udaya.K ramaudaya.blogspot.com ---------------------------------------- Please remember to mark the replies as answers if they help and unmark them if they provide no help.
- Proposed as answer by Iric WenModerator Tuesday, May 08, 2012 8:39 AM
- Unproposed as answer by as618 Tuesday, May 08, 2012 10:22 AM
- Edited by Rama Udaya Tuesday, May 08, 2012 2:23 PM
- Proposed as answer by Sean GallardyMicrosoft community contributor Tuesday, May 08, 2012 2:30 PM
- Unproposed as answer by as618 Friday, May 11, 2012 10:21 PM
There is no direct way to do this, because account lockout is depand on the password policy of AD.
you can use select name,modify_date from sys.server_principals & set the alert as per the AD password policy.
However ,there is no guarantee that only password has been changed , could be name & other things as well