Hi Jonathan,

Take a look at web.config in C:\Program Files\Microsoft SQL Server\{{YOUR RPT 
SVC INSTANCE NAME}}\Reporting Services\ReportServer.  Unfortunately, this isn't 
based on IIS so I can't say with any confidence whether or not this will 
work... but give it a shot.  I'm looking at a 2008 R2 server.  Things may have 
been different in 2005, in which case you may have to do some digging.  You are 
looking for a web.config file and a bin directory in some reporting services 
sounding directory, probably somewhere under program files.

1) Drop DotNetCasClient.dll in C:\Program Files\Microsoft SQL 
Server\MSRS10_50.MSSQLSERVER\Reporting Services\{{YOUR RPT SVC INSTANCE 
NAME}}\bin

2) Add the following inside the <configuration> tag, but before <system.web>
        <configSections>
                <section name="casClientConfig" 
type="DotNetCasClient.Configuration.CasClientConfiguration, DotNetCasClient"/>
        </configSections>

3) Drop in a correctly configured <casClientConfig ... /> tag just below the 
close of the configSections tag.  See the example website's web.config for 
reference.  Make sure you include https:// prefix on the serverName attribute.

4) Change <authentication mode="Windows" /> to:
        <authentication mode="Forms">
                <forms 
                                loginUrl="https://{{YOUR CAS 
SERVER}}/cas/login" 
                                timeout="30" 
                                cookieless="UseCookies" 
                                slidingExpiration="true" 
                                path="/ " />
        </authentication>

        You may need a defaultUrl="~/Default.aspx" in side the <forms> tag in 
step 4, but I don't know what to supply as a value for SSRS.

5) You may or may not need to remove <identity impersonate="true" />

6) Add the module definition anywhere in the <httpModules> tag below <clear />

        <add name="DotNetCasClient" 
type="DotNetCasClient.CasAuthenticationModule,DotNetCasClient"/>

Then cross your fingers and post back your findings.

-ScottH

-----Original Message-----
From: Jonathan Yanes [mailto:[email protected]] 
Sent: Thursday, January 20, 2011 5:01 PM
To: [email protected]
Subject: [cas-user] CASifying Microsoft SQL Server Reporting Services

I am interested in CASifying Microsoft's SQL Server Reporting Services and was 
wondering if you could recommend a good place to start?  I have seen the .NET 
Client portion of the CAS Wiki discussing integration with a .NET application 
using form based authentication.  I am however, unsure as to who to apply these 
concepts to Reporting Services.  

The architecture i would like is as follows:
Joomla CASified Portal Server ---> Custom Java Application with CAS client  --> 
Reporting Services 

The idea is to prevent them from having to log in once again to the Reporting 
Server.  Any thoughts?  Has this been done before?
--
You are currently subscribed to [email protected] as: 
[email protected] To unsubscribe, change settings or access archives, see 
http://www.ja-sig.org/wiki/display/JSG/cas-user

-- 
You are currently subscribed to [email protected] as: 
[email protected]
To unsubscribe, change settings or access archives, see 
http://www.ja-sig.org/wiki/display/JSG/cas-user

Reply via email to