Impersontation problem ASP .NET -> COM+ -> SQL
I am using SQL Server 2008 under windows authentication, front end is ASP.NET which uses COM+ to access database.
COM+ components are configured to run as domain user.
When looking through the logs (SQL Profiler), I can see the login name as the configured identity instead of windows indentity.
I have got Website running under "Intergrated Windows Authentication" and database is running locally on webserver.
Web configure contains entry for <identity impersonate="true"/>.
My connection string is
connectionString="data source=db01\test01;initial catalog=test; integrated security=SSPI;persist security info=False; Trusted_Connection=Yes"
Any ideas?
Regards
Sandeep