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
http://www.insidesql.de
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
http://www.SQL-Server-Performance.Com
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

]]>