SQL Server 2005 introduced 'Enforce password policy' and/or the 'Enforce password expiration' configurations which use the local policies for password length, complexity and expiration. Depending on how Active Directory, the local policies and your rights are setup, these parameters can be reviewed and changed to dictate how SQL Server uses configurations.
Where can I find the login properties?
- Open Management Studio and the object browser.
- Navigate to the Security | Logins folder.
- Find the login you are interested in reviewing.
- Right click on the login and select 'Properties' option.
- On the General tab, review the 'Enforce password policy' and the 'Enforce password expiration' configurations.