February 27, 2011 at 6:29 pm
Folks,
I find that this message is quite common. I am no SQL Server admin expert, I am a developer setting up a new development system. I have SQL Server 2005 running on a Windows Server 2008 virtual machine. I am trying to connect to this using the Server Explorer from Visual Studio 2010. I have checked all the settings for the SQL Server, Windows server and have them set as most of the posts on the different forums indicate and still I get the "user not associated with a trusted sql server connection" message when I try and connect using server explorer. When I look in the SQL Server log I see that the request is being received but is being rejected as it isn't from a trusted source. I have added the client computer as a user and given full rights to the server in SQL server security. I have the SQL Server set to use mixed mode authorization which all the forums say will solve this issue, but it is still there.
Any suggestions would be greatly appreciated.
Doug
February 27, 2011 at 10:01 pm
Can you try to connect to SSMS using the mentioned id/pwd? You might get the similar error.
If that is the case then connect SSMS with some account which have enough permission to configure account.
Seems like account doesnt have any permission. If you able to see Security folder in SSMS then can you check what permission configured for the user which is having problem?
----------
Ashish
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply