enforcing password complexity in sql server 2000

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.

 

Answer 1

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

Answer 2

Thanks Laurentiu.  I sort of expected that this was the case.  I wanted to be sure. Thanks again.

rocr.