• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 350
  • Last Modified:

The user is not associated with a trusted SQL Server connection.

why am I getting "The user is not associated with a trusted SQL Server connection" on a machine.  My accounts look fine and have not changed.
0
collink
Asked:
collink
  • 2
  • 2
2 Solutions
 
geek_vjCommented:
This can be due to any of the below reasons:

1. SQL Server has been configured on Windows authentication alone and you are trying to use SQL logins to access the server.
2. Instance name/SQL Server name is entered incorrectly in SSMS.
3. SQL Service is in stopped state.

For point 1 above, please change SQL Server to operate in Mixed mode (Windows + SQL Server authentication)
For point 2 above, please try entering the right name along with the instance name (ie Servername\instance name, port number)
For point 3, please check if the SQL Services are in stopped state. If yes, please restart them and try accessing again.

Also, there must be some error number recorded along with the above error message. Please post it to assist you better.
0
 
collinkAuthor Commented:
Thing is, I had been using SQL developer tools and visual studio and then just loaded SQL report services. I work in a corp environment and cannot change the SQL Server corp configuration -- but also wanted to load a local server for learning Reporting Services. Once I removed the local installation, my ability to access the corporate accounts was restored.

However, I need to reload and be able to access both the corporate and local "instance?".  I need some pointers on how to proceed.

Thanks for the answers above, they were insightful.
0
 
geek_vjCommented:
>>However, I need to reload and be able to access both the corporate and local "instance?"

This seems to be more of proxy level issues. What I understand from your post is, when SSRS is loaded locally, you were able to access only the local instance but not the corp instance. But once u removed the local instance, you were able to access the corp instance right?

Also, you can try configuring a SQL Server account (instead of Windows account). However you need to make sure that Mixed mode authentication is configured on the Corporate server and your SQL Server account is having sufficient access (Not sure if this is allowed in your corp account, but u can give a try)
0
 
collinkAuthor Commented:
I needed to do additional research.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now