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.SqlSessionSta teResolver,
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.
: 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.SqlSessionSta
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