troubleshooting Question

User locking in sqlserver after 'x' failed attampts

Avatar of vijay11
vijay11 asked on
Microsoft SQL ServerMicrosoft DevelopmentMicrosoft SQL Server 2008
4 Comments1 Solution286 ViewsLast Modified:
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
ASKER CERTIFIED SOLUTION
Aneesh
Database Consultant
Join our community to see this answer!
Unlock 1 Answer and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros