January 4, 2010 at 11:45 am
If a SQL login's password expires, and I deselect the "enforce password expiration" and save the login,
does the password still need to be reset as well? Also, the login is still enabled.
Thanks!
Bob
MCSA SQL 2014
January 4, 2010 at 12:19 pm
Man, that's a great question.
You can find out part of the answer in sys.sql_logins
As for whether or not SQL Server still considers the password expired if you stop checking for expiration I couldn't say with 100% certainty... my guess would be that SQL checks every time at login rather than set a flag somewhere, but I'm wrong a lot 🙂
Good luck,
~Craig
Craig Outcalt
January 4, 2010 at 2:15 pm
bobswi (1/4/2010)
If a SQL login's password expires, and I deselect the "enforce password expiration" and save the login,does the password still need to be reset as well? Also, the login is still enabled.
Thanks!
Bob
If the password is expired, the password would need to be reset. It is best to set those options prior to expiration. Also, resetting the password does not require it to be a new password (for SQL Logins), you can enter the same password as was already set. These recommendations are based on prior experiences with it in SQL 2005.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
January 4, 2010 at 4:12 pm
Thanks! We reset it just to be safe. Had to search around for someone who knew the password though.
MCSA SQL 2014
January 4, 2010 at 4:42 pm
You're welcome.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply