StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>We recently integrated an SSO authentication method for SSRS (SQL Server 2008 R2) with our custom web application which uses forms authentication. I found these two articles to be very useful and outlined everything we needed to do in order to accomplish our SSO solution.</p> <p><a href="http://blogs.msdn.com/b/cliffgreen/archive/2011/03/29/reporting-services-single-sign-on-sso-authentication-part-1.aspx" rel="nofollow">Reporting Services Single Sign On (SSO) Authentication - Part 1</a></p> <p><a href="http://blogs.msdn.com/b/cliffgreen/archive/2011/04/06/reporting-services-single-sign-on-sso-authentication-part-2.aspx" rel="nofollow">Reporting Services Single Sign On (SSO) Authentication - Part 2</a></p> <p>Here are the basic steps, but I suggest you read those articles completely:</p> <ol> <li>Create your Validation manager which will handle the authentication specific to your system</li> <li>Create your Login page for SSRS (our page, like the example, simply calls LogonUser and then redirects to the Report Manager) - This is necessary only if you want to use SSRS's Report Manager</li> <li>After adding the ReportingService2010 & ReportExecution2005 services to your project you'll want to create a Proxy wrapper around them and override the GetWebRequest & GetWebResponse methods in order to pass the SSRS authentication ticket between SSRS and your application. </li> <li>Create your custom authentication module that implements IAuthenticationExtension & IAuthorizationExtension (see part 2)</li> <li>Configure SSRS to use your custom forms authentication module</li> <li>If you want to use Report Manager then you'll want to make sure to configure SSRS Report Manager to handle your applications authorization ticket: <a href="http://technet.microsoft.com/en-us/library/ms345241.aspx" rel="nofollow">Configure Report Manager to Pass Custom Authentication Cookies</a></li> </ol> <p>With those steps done you can either use Report Manager or just implement the web services directly in your application. </p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload