I've created a linked SQL Server.
On the Security tab for the properties of the linked server I chose my domain\username for the local login and checked the box to impersonate. I have the same domain\username on the linked server (with Admin Server permissions and a dbo for all databases).
When I try to query the linked server using my laptop (WindowsXP)I recieve the error message - Error 18456: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. If I map my domain\username to a local SQL login (unchecking the impersonate field) I have no problems query the server.
Why does the NT Authority login fail. My understanding of impersonation is that it should know who I am without having to map it to a remote username. Anyone else have this problem and how did you sovle it?
Thanks
On the Security tab for the properties of the linked server I chose my domain\username for the local login and checked the box to impersonate. I have the same domain\username on the linked server (with Admin Server permissions and a dbo for all databases).
When I try to query the linked server using my laptop (WindowsXP)I recieve the error message - Error 18456: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. If I map my domain\username to a local SQL login (unchecking the impersonate field) I have no problems query the server.
Why does the NT Authority login fail. My understanding of impersonation is that it should know who I am without having to map it to a remote username. Anyone else have this problem and how did you sovle it?
Thanks