I am trying to query data across 2 sql servers. Both use NT authentication exclusively. I have set up a linked server on svrOne that points to svrTwo. Both servers have the NT group Developers with SQL Admin permissions. I have run sp_addlinkedsvrlogon, but when I try to query with something like
select * from svrTwo.database.dbo.table
I get the error 'Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
How do I get the logons mapped correctly?
TIA
John