Prasad Bolla's SharePoint Blog

Click Here to go through the Interesting posts within my Blog.

Click Here to go through the new posts in my blog.

Thursday, December 01, 2011

Installing SQL Reporting Services and MOSS 2007 on the Same port ( default : 80)

 Installing SQL Reporting Services and MOSS 2007 on the Same port ( default
: 80)
 If you have both MOSS 2007 ( Microsoft Office SharePoint Server) and
Reporting Services ( not in SharePoint integrated mode) installed on the
same IIS virtual server, then you have to make the below updates in
web.config for them to work:

   1. In the Root web.config to comment out the below. Otherwise the
   reportserver will give sessionState partitionResolver Issue
   <!-- <sessionstate mode="SQLServer" timeout="60"
   allowcustomsqldatabase="true"
   partitionresolvertype="Microsoft.Office.Server.Administration.SqlSessionStateResolver,
   Microsoft.Office.Server, Version=12.0.0.0, Culture=neutral,
   PublicKeyToken=71e9bce111e9429c" />-->
   2. In both Reportserver and ReportManager vdir web.config, the following
   should be added under appSettings. Otherwise you will get ReportViewer error
   messages
   <remove key="ReportViewerMessages">
   or
   you disable inheritance from Root Web.Config. You can use
   inheritInChildApplications attribute in a configuration file to specify that
   the settings defined in the
   location element for the root of a Web site should not be inherited by
   child applications:

   This is because , by default MOSS uses /reports url for it’s report
   center and it’s the same virtual dir url for native SQL Reporting Services
   report manager as well.

No comments:

Post a Comment