I have a standard scenario where I'm running an ASP.NET 2.0 application on one machine and need to access a SQL Server database on another machine via Windows Authentication (not SQL Server security). Both machines are on the same domain.
I followed the documentation for ASP.NET Impersonation and created a new domain user and granted this domain user appropriate authorizations on the IIS machine and within SQL Server. I added the following entry to my web.config file:
<identity impersonate="true" userName=" Go to the complete details ...