.NET, Integrated Windows Authentication, and more

From: FuriousMojo (anonymous_at_discussions.microsoft.com)
Date: 12/17/03 

Date: Tue, 16 Dec 2003 16:26:07 -0800

First of all, with identity impersonate = true, I still get this blasted error: Exception Details: System.Data.SqlClient.SqlException: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.

It seems like it simply will not send the domain username and password that I'm authenticated as! It is endlessly frustrating. I have the machine.config entries as follows:

<identity impersonate="true" userName="" password=""/>

and for the process part...

userName="machine"
password="AutoGenerate"

My web.config is as follows:

<configuration><system.web><compilation debug="true"/><customErrors mode="Off"/><authentication mode="Windows" /><identity impersonate="true"/></system.web></configuration>

All I want to do is authenticate to the SQL server (which is not the same machine as the IIS box) using the domain username and password I'm signed on as. That way I can assign permissions and rights on the database side. This cannot be that hard. What am I missing?

Thanks in advance.