Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.

Hi !!
Does anybody know how can I solve this problem ?
Server: Msg 18456, Level 14, State 1, Line 1
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
I have this problem when I tryed to execute a select between two SQL server
from a Query Analyzer Client with windows NT credentials (the linked Server
has been seted up)
Thanks
Setup impersonation on the linked server. That should solve your problem.
-Argenis
"Hernn Rado" <hernan_radovitzki@.hotmail.com> wrote in message
news:%230avXC%23LFHA.2580@.TK2MSFTNGP09.phx.gbl...
> Hi !!
>
> Does anybody know how can I solve this problem ?
> Server: Msg 18456, Level 14, State 1, Line 1
> Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
> I have this problem when I tryed to execute a select between two SQL
server
> from a Query Analyzer Client with windows NT credentials (the linked
Server
> has been seted up)
> Thanks
>
|||see also
http://support.microsoft.com/?id=238477
reg
Knud
"Hernán Rado" wrote:

> Hi !!
>
> Does anybody know how can I solve this problem ?
> Server: Msg 18456, Level 14, State 1, Line 1
> Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
> I have this problem when I tryed to execute a select between two SQL server
> from a Query Analyzer Client with windows NT credentials (the linked Server
> has been seted up)
> Thanks
>
>