SQL Authentication login weirdness...

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 Security » SQL Authentication login weirdness...

SQL Authentication login weirdness...

Rate Topic

Display Mode

Topic Options

Author

Message

SQL_ME_RICH

Posted Sunday, November 18, 2012 11:51 PM

SSC-Addicted

Group: General Forum Members
Last Login: Yesterday @ 10:49 AM
Points: 438, Visits: 1,156

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

Post #1386169

Bhuvnesh

Posted Tuesday, November 20, 2012 3:24 AM

SSCrazy

Group: General Forum Members
Last Login: Thursday, June 13, 2013 7:03 AM
Points: 2,562, Visits: 3,453

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----------
While 1 = 1 (Learning SQL....)
Click to get fast response of your post

Post #1386784

Bhuvnesh

Posted Tuesday, November 20, 2012 3:27 AM

SSCrazy

Group: General Forum Members
Last Login: Thursday, June 13, 2013 7:03 AM
Points: 2,562, Visits: 3,453

see " user must change password on next login" in attachement

-------Bhuvnesh----------
While 1 = 1 (Learning SQL....)
Click to get fast response of your post

Post Attachments

sql_server_users_2.gif (3 views, 40.81 KB)

Post #1386788

« Prev Topic | Next Topic »

Permissions