I set up a linked server to a server named "DB6" on a domain I will call "DOMAIN2". I created the linked server and have tried every permutation of security context I can think of but keep getting "Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'" when I try to view the tables.
I was able to link back to my source server which I will call "DB1" (which is in a different domain).
My latest try: set password on sa, used sa and password to connect to linked server.
Authentication on both machines is Windows And SQL Server.
I suspect domain-related issues are behind this but I am not sure what to ask my System Admin. I asked him to allow anonymous logins but he said he will not do that.