Security Integration between ASP.Net and Reporting Services

Question

I have an ASP.Net website with a standard format membership database, and then an instance of Reporting Services with a bunch of reports.

How can I integrate security between two servers? In the worst case scenario, I could just write some code in the reports and transfer the universal credential set to the report server, but I will lose the security granularity ... I could transfer the current credential set in the same way, but then I have to keep two db synchronized. There must be a better way.

TIA

WITH

Answer 1

Sql Server Reporting Services Forms Authentication.

:

Reporting Services