Linked Servers

16 Mar 2006 4:07 PM

Alastair MacFarlane

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 MacFarlane

16 Mar 2006 4:20 PM

Alejandro Mesa

Alastair 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

Show quote

"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. Can
> someone suggest what I am doing incorrectly.
>
> Thanks again...
>
> Alastair MacFarlane