It is possible a two different impersonations in ASP.NET

[Guest]

Hi,

Thanks for reading. This is what I am trying to do:

I have a SQL server 2005 with Reporting Services. This SQL Server is outside
any Active Directory and manages it its own accounts. I created a simple
report which shows perfectly with any of this accounts.

I also have a Web site using other SQL server for membership and
authentication. The authentication is working ok.

How can I configure web.config, so it use a user and password from the RR
Server for running and showing the reports, because the users will have their
own user and password?


Thanks very much,
Regards,

Lorenzo Jiménez