When I have a linked server which is using the "use self" credentials, how can I tell what the "self" in question is?
My problem is this: when I log into SQL Server A from machine A using a domain account, I can query linked SQL Server B; when I log into SQL Server A from machine C on the same domain using the same domain account, querying SQL Server B gives
me this error:
Msg 18456, Level 14, State 1, Line 1
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
And the same thing again in GUI format: When I look at the Linked Servers node on SQL Server A in SSMS from machine A, I can see all of the objects I expect; when I look at it from machine C, the Catalogs node is empty except for the default system objects.
In both cases, if I look at the security properties of the linked server in question I see that it falls back on "be made using the login's current security context", just as I expect, and the standard little "connection" box is affirming that I'm connected
with the same domain account.
From machine C, I can log in directly to SQL Server B using windows authentication on this domain account; it's only the linked server call A-to-B that gives the error from machine C.
SQL Servers A and B are both 2008, and the SSMS install on machine C is also for SQL Server 2008 and has the same version number as the
View Complete Post