I wanted to run Reporting Services 2005 reports on my secure MOSS site so the user wouldn’t have to login twice. I did this by adding the Reports and ReportServer virtual directories to my MOSS site in IIS. The MOSS web server had an instance of Reporting Services running on it.
The Reports virtual directory is something like this
C:\Program Files\Microsoft SQL Server\MSSQL.1\Reporting Services\ReportManager
The ReportServer virtual directory is something like this
C:\Program Files\Microsoft SQL Server\MSSQL.1\Reporting Services\ReportServer
Both virtual directories need to have an “application” created in IIS and should use the same application pool that the MOSS web site uses.
Now go to the Reports directory and modify the web.config file
The <sessionState> entry should be changed to this
<sessionState mode=”InProc” cookieless=”false” timeout=”20″ partitionResolverType=””/>
Also add the following to the <appSettings> section
<remove key=”ReportViewerMessages” />
Now go to the Reports directory and modify the RSWebApplication.config file
Look for the <ReportServerUrl></ReportServerUrl> tags and add the URL to the virtual directory
If your MOSS site is http://www.mymoss.com then you would enter http://www.mymoss.com/reportserver
Find this tag <ReportServerVirtualDirectory>ReportServer</ReportServerVirtualDirectory>
and change it to <ReportServerVirtualDirectory></ReportServerVirtualDirectory>
(Remove the “ReportServer” in the tag)
If you’re using the ReportServer virtual directory to render reports, you will probably also want to modify the web.config by adding this just after the </httpHandlers>
<remove name=”PublishingHttpModule” />
This will get rid of the annoying Event Log message. See my post here for more info.