Can SQL Reporting Services work with ASP Membership Provider?

Question

I have an ASP.NET site using role based security via the SQLMemberShipProvder.

Is it possible to provide internet access to SSRS reports using my existing MembershipProvider roles?

For example, if I have a role SupportPersonRole, can I allow only people in that role to use certain reports?

The docs say SQL 2008 R2 uses basic auth to the local security authority. However if SSRS can only present it's own basic auth login for SSRS content, I'm not sure how I would get a chance to authorize using the MembershipProvider roles.

The ASP.Net page needs to handle report parameter prompting so it seems this implies "remote" mode is appropriate to get this functionality.

The confusing part is SSRS (in remote mode) has it's own role security credentials, which are separate from ASP.Net role based security. So how do you avoid managing security in both places?

Answer 1

If you include the report viewer control in your site, you can then limit who can see this page, and what reports they can run via your site front end.

Your connection through to the SSRS server (from web server to it), can then be secured so that only your site can access these reports.