I have a web application which connects to SQL Database to bring the data. The web server is on m/c A and the Sql server is on m/c B.
I have set impersonation to true in the web config <identity impersonate="true" />
I have Integrated Security = SSPI in my connection string
I have set authentication mode= windows
I have set my IIS to use Integrated Windows Authentication.
Anonymous access turned off.
On the Active Directory, have specified Unconstrained Delegation. Option 2 on the Delegation tab on the Properties page of Active Directory for that web server ...
Go to the complete details ...