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
Posted Sunday, November 18, 2012 11:23 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Wednesday, September 23, 2015 2:36 PM
Points: 506, Visits: 1,511
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!

Post #1386164
Posted Monday, November 19, 2012 2:17 AM



Group: General Forum Members
Last Login: Today @ 3:37 AM
Points: 43,458, Visits: 40,605
Duplicate post. No replies to this thread please. Direct replies to:

Gail Shaw
Microsoft Certified Master: SQL Server, 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