Can SQL Reporting Services work with ASP Membership Provider?

Question

I have an ASP.NET site that uses role-based protection through SQLMemberShipProvder.

Is it possible to provide Internet access to SSRS reports using existing existing MemberhipProvider roles?

For example, if I have the SupportPersonRole role, can I only allow those who use certain reports in this role?

The docs say SQL 2008 R2 uses basic auth for the local security authority. However, if SSRS can only provide its own primary login for SSRS content, I'm not sure how to get the chance to allow the use of MembershipProvider roles.

The ASP.Net page should handle the request for report parameters, so this seems to mean that the "remote" mode is suitable for receiving this function.

The confusing part of SSRS (remotely) has its own security credentials for roles that are independent of ASP.Net-based security. So how do you avoid security management in both places?

Answer 1

If you enable the report viewer control on your site, you can restrict who can see this page and which reports they can run through your site.

Now your connection to the SSRS server (from the web server to it) can be protected so that only your site can access these reports.

Answer 2

You can also display LocalReport at the output of your choice. This can be a good option if you do not need as many options as the control offers.

 // Controller Action public ActionResult GetReport(ReportParameters foo) { string mimeType; var stream = foo.RenderReport(out mimeType); return new FileStreamResult(stream, mimeType); } class ReportParameters { public Stream RenderReport(out string mimeType) { var localReport = new LocalReport(); // ... TODO: Set up report data sources render call out variales, etc. byte[] renderedBytes; renderedytes = localReport.Render( reportType, deviceInfo, out mimeType, out encoding, out fileNameExtension, out streams, out warnings); return new MemoryStream(renderedBytes); } }