Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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.


share|improve this question
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


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.