Password expiration | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Password expiration

Hi… Can I set expiry date on the SQL Server user name and password like what we have in Windows login.
Another big resounding NO. Use Windows authentication if you need this functionality.
I think this is available in SQL Server 2005. However, as Adriaan stated, no chance in SQL Server 2000. —
Frank Kalis
Microsoft SQL Server MVP
Heute schon gebloggt?

Yes it is possible when using SQL 2005 and provided the authentication is a mixed mode.
I second Adriaan’s suggestion to use Windows only authentication for such functionality. Satya SKJ
Contributing Editor & Forums Moderator
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.