I am setting up a linked server between two servers on my domain.
I am using impersonate, so that its my own account that is used on the linked server.
I set up both servers to use kerberos and confirmed its working (both servers running under domain accounts).
im logged into my desktop pc, via my domain account.
Now, when i try to query tables via the linked server i get the error:
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
I set up kerberos initially to get over this yet its still an issue. anyone able to help here?