Error – Login failed the user is not associated with the trusted SQL server coonection.

January 19, 2013 at 1:23 pm Leave a comment

Hi friends

Those who try to login to SQL Management Studio with the SQL based authentication would be receiving the below error

sql_error

If you have disabled the SQL authentication on your SQL server you would be receiving this error.

Workaround — It is easy

– Open  the Management Studio

–  Right Click on the Server Name – -> properties –> Click on Security and Change the

authentication as follows

sql_auth

Advertisement

Entry filed under: SQL.

How to idenitfy a process ID using the TCP Port Cool Tool- SYDI

Leave a Reply

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

WordPress.com Logo

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

Facebook photo

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

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Trackback this post  |  Subscribe to the comments via RSS Feed


Archives

Categories

Follow Hope you like it.. on WordPress.com

Blog Stats

  • 68,230 hits

%d bloggers like this: