<div>
I fixed it!<br />
Under server X security within linked servers, Y was listed. However it was listed as connecting under current security.<br />
I checked another box and thatw as set to connect using the SA uname/pwd.<br />
<br />
So 500 points to whoever can explain what that is and what I just did please :)
</div>


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 :)

<div>
<div class="content wysiwyg-content">
I have added a new server registration and all is running fine for this new instance and the app that uses it.<br />
However, I open QA and I connect to server X and run....<br />
<br />
select * from y.myTable (Y is the new instance)<br />
and I get the error...<br />
Server: Msg 18452, Level 14, State 1, Line 1<br />
Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.<br />
<br />
Both servers have windows and sql authority.<br />
I am logged on as myself and am a member of SA on both boxes.<br />
Any ideas?
</div>
</div>


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?

Not associated with a trusted SQL Server connection.

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.