Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL Authentication login weirdness... Expand / Collapse
Author
Message
Posted Sunday, November 18, 2012 11:23 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Tuesday, September 2, 2014 7:52 PM
Points: 486, Visits: 1,362
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 #1386164
Posted Monday, November 19, 2012 2:17 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 4:28 PM
Points: 43,028, Visits: 36,193
Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic1386162-359-1.aspx


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1386234
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse