Hi John,
From BOL
Establishing Security for Linked Servers, "If security account delegation is not available on the client or sending server, or the linked server/provider does not recognize Windows Authentication Mode, then self mapping will not work for Windows Authenticated logins". I would check if that's the case.
>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
--sb--