identity impersonate not working without username and password

[zerkat]

We are developing an application in our development environment; the app is on windows 2003, iis 6, .net 2.0. In the web.config we have identity impersonate = true and in iis site is set up for integrated authentication only. We are running SQL 05 in mixed mode for authentication (SQL Server and windows authentication). IIS and SQL are on the same machine.

We repeatedly get an error stating that NT Authority/Network Service can not connect to the database. It seems like identity impersonate is not working at all. It will only connect us to the database when I supply a username and password within the identity tag.

I have this working in another app - just using identity impersonate = true to grab the identity of the user to connect to the database but can't get it to work here. We need to know the identity of the user so we can properly audit the database.

I have scoured the internet for possible solutions but have yet to find anything that works. Any one have any ideas??

 

[jmeckley]

make sure anonymous access is disabled in IIS. post the relevant pieces of the web.config file as this may aslo provide some insight.

Jason Meckley
Programmer
Specialty Bakers, Inc.

faq855-7190

 

[zerkat]

Hey Jason

- Thanks for the help as always. This morning my coworker had a solution. He found an article on Microsofts website what we are trying to do is not possible. Oh well, that's how we learn...