March 31, 2010 at 5:52 pm
Hi,
Some of the users frequently face this issues.
"Login failed for user ''. The user is not associated with a trusted SQL Server connection. (Microsoft SQL Server, Error: 18452)"
Is there any standard solution for this bug.
Regards,
S.Balavenkatesh
March 31, 2010 at 10:24 pm
I would not call it a bug. If they are using their windows login information and they recently changed their password - this will happen. This also happens frequently if they were logged into a machine and did not log out, then change their password. Upon changing their password they will cause that unattended login to require them to update their credentials and subsequently lock out their account.
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
April 1, 2010 at 12:46 am
Make sure authentication mode is set to Mixed Mode(Windoes & SQL). Else the SQL users will not be able to login.
Have a nice Day !!!
----------------------------------------------------------------
**"There is only one difference between dream and aim. Dream requires Soundless sleep to see…Where as Aim Requires Sleepless Efforts to Achieve":-) **
April 1, 2010 at 11:40 am
Hi
Authentication is selected as Mixed mode authentication.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply