Not associated with a trusted SQL Server connection.

Posted on 2006-04-25
Medium Priority
Last Modified: 2011-10-03
I have added a new server registration and all is running fine for this new instance and the app that uses it.
However, I open QA and I connect to server X and run....

select * from y.myTable (Y is the new instance)
and I get the error...
Server: Msg 18452, Level 14, State 1, Line 1
Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.

Both servers have windows and sql authority.
I am logged on as myself and am a member of SA on both boxes.
Any ideas?
Question by:QPR
LVL 29

Author Comment

ID: 16538741
I fixed it!
Under server X security within linked servers, Y was listed. However it was listed as connecting under current security.
I checked another box and thatw as set to connect using the SA uname/pwd.

So 500 points to whoever can explain what that is and what I just did please :)

Accepted Solution

GranMod earned 0 total points
ID: 16766871
PAQed with points refunded (500)

Community Support Moderator

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.
Suggested Courses

862 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question