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
Microsoft DevelopmentMicrosoft SQL ServerMicrosoft SQL Server 2008

Avatar of undefined
Last Comment
Anthony Perkins

8/22/2022 - Mon
Aneesh

try this query


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

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

Thanks
ASKER CERTIFIED SOLUTION
Aneesh

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Anthony Perkins

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
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23