I am writing a ASP.net application. I have configured Web.Config to use Windows Authentication with Impersonation as follows:
authentication mode="Windows"
identity impersonate="true"

When I try to connect to my SQL database, it's trying to connect as the ASPNET user. That user does not have any rights to connect to my database (nor do I want to give them any rights).

I have done a lot of reading on the Identity and Principal classes, but still don't understand how to tell SQL server what user has been authenticated for my connection.

I know I must be missing something really obvious, I just can find it. Any ideas?

Mary Hintermeier (through Chris D'Arrigo)
RSA