Problem with SQL Connection

7 09 2008

I came across this issua a couple of days back:

I use “Window Authentification” to sign on to “Microsoft SQL Server
Management Studio Express”. I create and account with “SQL Server
Authentification” and assigned a password. I also identify the database that
this ID has access to. When I then try to login with this id, I get a “Login
Failed for user ‘Kumar’. The user is not associated with a trusted SQL Server
Connection….Error: 18452”. I was wondering about why am I getting this error?

That is when I get a reply form Harish Ranganathan from Microsoft, that it was due to “Mixed Mode Authentication in SQL Server which was not enabled”.

This guy saved me a lot of time. Thanks Harish




Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: