Link to home
Start Free TrialLog in
Avatar of vijay11
vijay11

asked on

User locking in sqlserver after 'x' failed attampts

I want to lock the user if he made 'x' number of failed login attempt's in Sql server 2008 R2 Standard edition.Is there any way to do this when "Enforce password policy" is OFF and for Sql server authentication users

Thanks
Avatar of Aneesh
Aneesh
Flag of Canada image

try this query


ALTER LOGIN <yourLoginName>  WITH
      CHECK_POLICY = OFF,
      CHECK_EXPIRATION = OFF;
Avatar of vijay11
vijay11

ASKER

I want a userid to be locked  after 5 attempts of unsuccessful login.

Thanks
ASKER CERTIFIED SOLUTION
Avatar of Aneesh
Aneesh
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
vijay11,

I suggest you re-read the EE Guidelines regarding grading standards, as Aneesh has provided you with a very good example of what you need.

Thanks,
Anthony