Please note: If you find any post DOES NOT contain required amount of explanation, please do comment them with a request for more information. I will update as soon as I can attend to it. Also you can contact me with a link to the post.

Friday, February 27, 2009

Login Failed The user is not associated with a trusted SQL Server connection: SQL Server 2005


This occurs when you try to login using SQL Server user cardinals without configuring SQL Server to use Windows and SQL Server authentication.

Resolution:

[1] Open SQL Server management studio – [2] Login to SQL server using windows authentication – [3] Right click on SQL Server instance and go to properties – [4] Expand security tab and select 'SQL Server and Windows authentication mode' under 'Server Authentication'
Posted by Charith Shyam Gunasekara at 8:51 PM
Reactions:  
Labels:

1 comments:

Nish™ said...
This comment has been removed by a blog administrator.
March 07, 2009 3:16 PM

Post a Comment

Subscribe to: Post Comments (Atom)
 

Copyrights(C) - Charith Gunasekara 2005-2010