locked
enforcing password complexity in sql server 2000 RRS feed

  • Question

  • Hi all,

      Are there any built-ins, utilities, ... within sql server 2000 that can be used to enforce password complexity in the database.  i.e at least 8 characteres, upper and lowercase mix, includes at least on number and one punctuation (underscore,...). 

      I understand that this requirement can be achieved using windows authentication.  Unfortunately we do not have that luxury (at the moment).

    tx.

     
    Tuesday, May 23, 2006 2:53 PM

Answers

  • There is no builtin support in SQL Server 2000 for enforcing password policy on SQL logins.

    SQL Server 2005 offers these features if it is installed on Windows 2003. The free Express edition includes this feature as well, so you can use it for evaluation.

    Thanks
    Laurentiu

    Tuesday, May 23, 2006 7:18 PM

All replies

  • There is no builtin support in SQL Server 2000 for enforcing password policy on SQL logins.

    SQL Server 2005 offers these features if it is installed on Windows 2003. The free Express edition includes this feature as well, so you can use it for evaluation.

    Thanks
    Laurentiu

    Tuesday, May 23, 2006 7:18 PM
  • Thanks Laurentiu.  I sort of expected that this was the case.  I wanted to be sure. Thanks again.

    rocr.
    Tuesday, May 23, 2006 7:33 PM