:::: MENU ::::

password policies for SQL Server login for Windows Server 2003

  • Nov 26 / 2008
  • 0
dbDigger, Security and Permissions, System Administration

password policies for SQL Server login for Windows Server 2003

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.

Consult us to explore the Databases. Contact us