Posts filed under ‘SQL’

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

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

Advertisements

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


Archives

Categories

Follow Hope you like it.. on WordPress.com

Blog Stats

  • 24,723 hits

%d bloggers like this: