On a computer running Windows Server 2003 or later hosting a SQL Server instance, which of the following password policies are checked for a SQL Server login when CHECK_POLICY is ON and CHECK_EXPIRATION is OFF?
- Enforce password history
- Minimum password age
- Minimum password length
- Password must meet complexity requirements
There is nothing written specifically indicating which policies are checked by CHECK_POLICY. The answer was determined by experimentation (SQL Server 2005 SP2 on Vista). A SQL Server login was created, then a query window was opened with the connection made using that login. ALTER LOGIN WITH PASSWORD = ” OLD_PASSWORD = ” was run when various policies were applied.
Password policy – http://msdn.microsoft.com/en-us/library/ms182717.aspx
Note: The Question is taken from SQLServercentral.com.