| As all of us know SQL Server use same password policy that is used by operating system for example account lockout. We can also configured password policy for SQL Login. And password of sql will expire on certain login failed. We can end up this locking with sql server with given below method.
To get our of locking policy uncheck the enforce password policy. If we do as per below image it will not resolve the issue it will given msg as below of image.
To get rid of password policy we need to uncheck Enforce Password Policy
it will automatically uncheck Login is Locked Out
 | | |