Login failed for user "NT AUTHORITY\ANONYMOUS LOGON"

[Guest]

Hello,

I have an issue here. Hope someone can help me.

Issue:

Developer is using a web application from one server (IIS) (say Server A).
A second server (say Server B, which is SQL Server 2000) hosts the stored procedures.
The SQL datawarehouse is hosted on a third server (say Server C ,which is SQL Server 2000)
and contains allof the data.

Developer's queries work correctly when executed directly from the
second server (Server B) to the data warehouse. When he initiates the same query
hosted on the second server from the web server, the follow error is
generated Login failed for user "NT AUTHORITY\ANONYMOUS LOGON" The web
applications uses Visual Studio.net to link to the server hosting the
stored procedures.

Question 1: Is it possible to successfully link from web app to data warehouse through the second
server using Windows Authentication? If possible,please explian how.

I do not have SQL Server account on Server C. Thats why I want to use only Windows Authentication.

Thanks in Advance for your time and help.

VC

 

[Sanjeeva]

Check the directory security tab -> edit. check the anonymous access
checkbox
and integrated Windows authentication checkbox, Allow IIS to control
password...
even After this if it doesnt work... try uninstalling and installing ASP.NET
USer should work
after this step...
the commands for unistall and install are

aspnet_regiis -u // unistall
aspnet_regiis -i //install ...

after this it should work..