"Henry Calo" <wuzaap123> wrote in message
news:03f501c360fc$00c63280$a101280aphx.gbl...No. This is a limitation of Windows Integrated Authentication and is known> Problem: IIS server unable to pass NT user logon to an SQL
> server on a different machine.
> I currently have an IIS server setup with "Integrated
> Windows authentication". I can successfully connect my ASP
> code to an SQL Server database that is located in the same
> machine (W2K server) with IIS.
> However, when I try to use ASP code to connect to an SQL
> server located on another W2K machine(for which I also
> have authorization), I get the error message: "Login
> failed for user 'NT AUTHORITY\ANONYMOUS LOGON'."
> It appears that IIS is not able to pass the NT user login
> ID to the other SQL server.
> Is there a special IIS setting Im not aware off?
as a delegation issue. Since the password isn't actually sent by IE to IIS,
IIS doesn't have it and can't authenticate the user to the SQL box.
Tom Kaminski IIS MVP
[url]http://www.iistoolshed.com/[/url] - tools, scripts, and utilities for running IIS