My App is running with ASP.net windows authentication with impersonation enabled. It also requires windows authentication to access the SQL Server 2005 database which is granted with Integrated Security set to true. The app is being hosted in a local workstation whereas the the database server is located in a server within the same domain.
From this article
http://msdn.microsoft.com/en-us/library/ms998292.aspx
I come to know there are two scenarios in such a case: Impersonation / Delegation and Trusted Subsystem
Since impersonation is enabled, authentication is delegated from the client to the server. But the database access from the application is not granted and the following error message is given
Go to the complete details ...