November 18, 2012 at 11:51 pm
Forgive me upfront for not supplying a snapshot of this issue, but here is what happened. I tried to log into an instance of SQL 2005 (have never had this issue come up before), but this time when I attempted to log in, after supplying my user ID and PW (it's a SQL Auth account - not AD from Windows) it came back with the prompt for me to change my password (claiming that it had expired). I know for a fact that it was not set with the password expires policy, so I am wondering if someone wasn't messing around, and it caused my account to then expire? When I tried to supply it a password (the one I had previously given it) it stated something to the effect that the password could not be used at that time, and that it had set my context to the Master database with English as the language default.
Very weird...We had an issue with the server that this instance is on, so I am wondering if it is just coincidence (and I am being paranoid) or if someone was messing around with my account.
Any insight would be much appreciated!
Thank you all in advance!
SQL_ME_RICH
November 20, 2012 at 3:24 am
I guess you have chose the option of
change the password on next login
thats why it is asking for change password on every time. see this http://technet.microsoft.com/en-us/library/ms144284.aspx
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 20, 2012 at 3:27 am
see " user must change password on next login" in attachement
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply