SQL Server Performance Forum – Threads Archive
Password expirationHi… 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. —
Microsoft SQL Server MVP
Heute schon gebloggt?http://www.insidesql.de/blogs
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.