Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. only from a remote computer !

[Jéjé]

Hi,

I've a simple web page on a SERVERA which access an SQL Server on a
SERVERB.
the authenticatyion mode is Windows and the anonymous logon is disable.

I received the Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. error
from a remote computer, but locally on the server, there is no errors !!! my
webpage works fine

I've tried the clear text authentication mode, but the result is the same.

what is the problem ???

I've created a second ASPX page where I just display the user name of the
active user, and I can see my login name correctly.

My web server is Windows 2003 and my SQL Server is a Win 2000 server.

thanks for your help !!!

Jerome.

 

[Miha Markic]

Under which account does asp.net application run?
It normally runs under aspnet account which is local to your computer -
that's why you are getting the error.
If this is the case you should change your Sql server connection from
windows authentication to sql auth.

 

[Jéjé]

my web site run under the network service account.
But I've also tried with the local system and others account.

what is strange, with the sa account (so an SQL Server account) instead-of
the NT authentication I've the same error !!!!

 

[Miha Markic]

Hi,

Are you sure that the connection is actually using a different connection
string - it shouldn't say 'NT AUTHORITY\ANONYMOUS LOGON' since it doesn't
care about NT user when using SQL Server authenticaton.