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

I have to set Account Lockout Threshold to some specific value In MSSQL Server 2008. How can i do this? I have googled and not able to find the exact solution how to do it. Whether SQL server account uses default Windows threshold to lock the sql account?

Thanks in advance... Santhosha

share|improve this question
up vote 1 down vote accepted

SQL Server 2008 uses the password policy enforcement settings from the domain or local machine. To set it you need to edit the domain policy that applies to the SQL server if the SQL server is joined to a domain, or edit the local machine policy if the SQL server is not joined to a domain.

share|improve this answer

You can not. SQL Server has no account lockout threshhold for it's user management. For trusted connections it also has none - because you have to come through a trusted connection, which means wherever you got your trust from (outside) the value was taken into account.

share|improve this answer
Then how the behavior "Account Locked out" is decided? – Santhosha Kaldambe May 6 '10 at 11:01

SQL server has 2 possible authentication modes, Mixed and Windows authentication only. In mixed mode accounts may be stored inside sql server and may have a different complexity setting as well as logins using windows accounts. In windows authentication only windows accounts can be used and user account information is not stored in sql server. Regardless of authentication type account lockout behaviour is defined by the security policy that affects the account in question for local accounts local ecurity policy applies and for domain accounts domain group policy applies

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.