Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connect

I have tried
sp_serveroption 'SERVER2','data access', true
sp_serveroption 'SERVER1','data access', true
SERVER2 appears as a remote server in the Enterprise Manager under
SERVER1
and
SERVER1 appears as a remote server in the Enterprise Manager under
SERVER2
They are in different Domains and ther is a Trust in place.
DTS works
alos: I am using NT Authentication
All I want to do in select records from a table in a different
database.
If I try to setup a Linked Server it wont let me becuase it already
exists as a Remote Server.
MarkRemoteServer allows you to execute remote procedures. However, here is a
trick to send a query to the remote server and execute it.
e.g.
exec SERVER2.DB1..sp_executesql N'select * from mytable'
--
-oj
RAC v2.2 & QALite!
http://www.rac4sql.net
"Mark Kuhnke" <markkuhnke@.yahoo.com> wrote in message
news:1eb9cc2a.0311171113.4e72b99e@.posting.google.com...
> I have tried
> sp_serveroption 'SERVER2','data access', true
> sp_serveroption 'SERVER1','data access', true
> SERVER2 appears as a remote server in the Enterprise Manager under
> SERVER1
> and
> SERVER1 appears as a remote server in the Enterprise Manager under
> SERVER2
> They are in different Domains and ther is a Trust in place.
> DTS works
> alos: I am using NT Authentication
> All I want to do in select records from a table in a different
> database.
> If I try to setup a Linked Server it wont let me becuase it already
> exists as a Remote Server.
> Mark|||I get the same error
using sp_executesql
Any other suggestions
Mark
"oj" <nospam_ojngo@.home.com> wrote in message news:<e7NLrKUrDHA.2216@.TK2MSFTNGP12.phx.gbl>...
> RemoteServer allows you to execute remote procedures. However, here is a
> trick to send a query to the remote server and execute it.
> e.g.
> exec SERVER2.DB1..sp_executesql N'select * from mytable'
> --
> -oj
> RAC v2.2 & QALite!
> http://www.rac4sql.net
>
> "Mark Kuhnke" <markkuhnke@.yahoo.com> wrote in message
> news:1eb9cc2a.0311171113.4e72b99e@.posting.google.com...
> > I have tried
> > sp_serveroption 'SERVER2','data access', true
> > sp_serveroption 'SERVER1','data access', true
> >
> > SERVER2 appears as a remote server in the Enterprise Manager under
> > SERVER1
> > and
> > SERVER1 appears as a remote server in the Enterprise Manager under
> > SERVER2
> >
> > They are in different Domains and ther is a Trust in place.
> > DTS works
> >
> > alos: I am using NT Authentication
> >
> > All I want to do in select records from a table in a different
> > database.
> >
> > If I try to setup a Linked Server it wont let me becuase it already
> > exists as a Remote Server.
> >
> > Mark|||Also:
If I run the quert on Server2 accessing Server1 I get this message
instead:
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
I have the guest user on each server.
I am a user in the Domain of Server2 and have been added as a user to
both SQL Servers.
Server1 is on NT and Server2 is on W2k3
Mark
"oj" <nospam_ojngo@.home.com> wrote in message news:<e7NLrKUrDHA.2216@.TK2MSFTNGP12.phx.gbl>...
> RemoteServer allows you to execute remote procedures. However, here is a
> trick to send a query to the remote server and execute it.
> e.g.
> exec SERVER2.DB1..sp_executesql N'select * from mytable'
> --
> -oj
> RAC v2.2 & QALite!
> http://www.rac4sql.net
>
> "Mark Kuhnke" <markkuhnke@.yahoo.com> wrote in message
> news:1eb9cc2a.0311171113.4e72b99e@.posting.google.com...
> > I have tried
> > sp_serveroption 'SERVER2','data access', true
> > sp_serveroption 'SERVER1','data access', true
> >
> > SERVER2 appears as a remote server in the Enterprise Manager under
> > SERVER1
> > and
> > SERVER1 appears as a remote server in the Enterprise Manager under
> > SERVER2
> >
> > They are in different Domains and ther is a Trust in place.
> > DTS works
> >
> > alos: I am using NT Authentication
> >
> > All I want to do in select records from a table in a different
> > database.
> >
> > If I try to setup a Linked Server it wont let me becuase it already
> > exists as a Remote Server.
> >
> > Mark|||Try using a SQL login for the security mapping. Refer to the
following article for more information on the error:
PRB: Message 18456 from a Distributed Query
http://support.microsoft.com/?id=238477
-Sue
On 18 Nov 2003 06:40:25 -0800, markkuhnke@.yahoo.com (Mark
Kuhnke) wrote:
>Also:
>If I run the quert on Server2 accessing Server1 I get this message
>instead:
>Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
>I have the guest user on each server.
>I am a user in the Domain of Server2 and have been added as a user to
>both SQL Servers.
>Server1 is on NT and Server2 is on W2k3
>Mark
>
>"oj" <nospam_ojngo@.home.com> wrote in message news:<e7NLrKUrDHA.2216@.TK2MSFTNGP12.phx.gbl>...
>> RemoteServer allows you to execute remote procedures. However, here is a
>> trick to send a query to the remote server and execute it.
>> e.g.
>> exec SERVER2.DB1..sp_executesql N'select * from mytable'
>> --
>> -oj
>> RAC v2.2 & QALite!
>> http://www.rac4sql.net
>>
>> "Mark Kuhnke" <markkuhnke@.yahoo.com> wrote in message
>> news:1eb9cc2a.0311171113.4e72b99e@.posting.google.com...
>> > I have tried
>> > sp_serveroption 'SERVER2','data access', true
>> > sp_serveroption 'SERVER1','data access', true
>> >
>> > SERVER2 appears as a remote server in the Enterprise Manager under
>> > SERVER1
>> > and
>> > SERVER1 appears as a remote server in the Enterprise Manager under
>> > SERVER2
>> >
>> > They are in different Domains and ther is a Trust in place.
>> > DTS works
>> >
>> > alos: I am using NT Authentication
>> >
>> > All I want to do in select records from a table in a different
>> > database.
>> >
>> > If I try to setup a Linked Server it wont let me becuase it already
>> > exists as a Remote Server.
>> >
>> > Mark