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