Monday, May 07, 2012 10:01 AM
In mixed mode authentication for SQL 2008 R2, How do you check the setting for Account Lockout threshold using Select statement. Example
Select Account Lockout threshold from sys.???
Monday, May 07, 2012 10:08 AMI think, it uses the Windows Password Policy
SKG: Please Marked as Answered, if it resolves your issue. (b: http://sudeeptaganguly.wordpress.com)
Monday, May 07, 2012 4:01 PM
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 UdayaMicrosoft Community Contributor Tuesday, May 08, 2012 2:20 PM
- Edited by Rama UdayaMicrosoft Community Contributor 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
Sunday, May 20, 2012 10:02 AM
This could be the solution, please check it out.
Sunday, June 24, 2012 5:43 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