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.
collinkAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2005

From novice to tech pro — start learning today.