servers

Dear All,
I am trying to link 2 servers together and get the following message:
Server: Msg 18452, Level 14, State 1, Line 1
Login failed for user '(null)'. Reason: Not associated with a trusted SQL
Server connection.
If I query MyServer and OtherServer independantly I can see the expected
results but when I run the following query I get:
select
Ref
from
MyServer.MyDB.dbo.MyTable inner join
OtherServer.OtherDB.dbo.OtherTable T on T.Ref = Ref
I have tried sp_addlinkedserver 'OtherServer'. This generated no error. Can
someone suggest what I am doing incorrectly.
Thanks again...
Alastair MacFarlaneAlastair MacFarlane,
You will have to elaborate a little bit more about your configuration.
- OS version in each server?
- SQL Server version in each server?
- What kind of authentication is being used in each sql server?
AMB
"Alastair MacFarlane" wrote:

> Dear All,
> I am trying to link 2 servers together and get the following message:
> Server: Msg 18452, Level 14, State 1, Line 1
> Login failed for user '(null)'. Reason: Not associated with a trusted SQL
> Server connection.
> If I query MyServer and OtherServer independantly I can see the expected
> results but when I run the following query I get:
> select
> Ref
> from
> MyServer.MyDB.dbo.MyTable inner join
> OtherServer.OtherDB.dbo.OtherTable T on T.Ref = Ref
> I have tried sp_addlinkedserver 'OtherServer'. This generated no error. Ca
n
> someone suggest what I am doing incorrectly.
> Thanks again...
> Alastair MacFarlane