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)
ThanksSetup 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 serve
r
> from a Query Analyzer Client with windows NT credentials (the linked Serve
r
> has been seted up)
> Thanks
>
>

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
>
>

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)
ThanksSetup impersonation on the linked server. That should solve your problem.
-Argenis
"Hernán 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
>
>

Logging Sql error to a table

CREATE PROCEDURE GetData
AS
SELECT * FROM Bogus
When I am executing above procedure I got following error.
Server: Msg 208, Level 16, State 1, Procedure GetData, Line 3
Invalid object name 'Bogus'.
I want to Insert above sql generated error message to a table from a
procedure (Ver.SQl 2000)
How can I do it ?You can't. Such errors are batch-aborting and need to be handled by the clie
nt application. Read the
error handling articles at www.sommarskog.se.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Sha" <Sha@.discussions.microsoft.com> wrote in message
news:D0E50949-4A04-4DF3-AD58-D0140D3A3B87@.microsoft.com...
> CREATE PROCEDURE GetData
> AS
> SELECT * FROM Bogus
> When I am executing above procedure I got following error.
> Server: Msg 208, Level 16, State 1, Procedure GetData, Line 3
> Invalid object name 'Bogus'.
> I want to Insert above sql generated error message to a table from a
> procedure (Ver.SQl 2000)
> How can I do it ?
>