Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

Is there a way to lock login process for account after 5 unsuccessful logins? Or maybe slow it down to 20 second gap until another login?

I can see lots of tries to connect to my MS SQL server directly.

Thanks.

share|improve this question

1 Answer 1

up vote 1 down vote accepted

You can enable Policy Enforcement via a login's CHECK_POLICY setting (for example - honoring account lockout) for a SQL Login in versions 2005+. Command to change the existing login would be ALTER LOGIN.

The actual policy configurations such as "Account lockout threshold" & "Account lockout duration" are part of the Group Policy and set in Windows (local system or at the domain scope).

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.