Welcome to MSDN Blogs Sign in | Join | Help

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" />


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.

Published Monday, October 29, 2007 11:17 PM by meysun

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

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

Tuesday, December 04, 2007 9:27 AM by Lip

thank you very much you released me from a problem, which was close to driving me crazy ;-)

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

Saturday, February 16, 2008 4:04 PM by bryan harvey

added the key to the web.config

<remove key="ReportViewerMessages" />

worked for me as well.

using MOSS 2007, SQL Enterprise 05 w/ sp2, and TFS 2008 - single server (win 2003 r2 w/ sp2) install.

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

Thursday, February 28, 2008 5:18 AM by Vikram

Thanks a lot for the helpful tips.

regards & best wishes !!

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

Saturday, March 01, 2008 9:03 AM by kf

Not sure about the part about commenting out the setting in the root web.config as there isn't a web.config in the root directory.

I added the remove key setting to the web.configs in the ReportServer and ReportManager directories and seems to have resolved the problem.

Thanks.

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

Wednesday, June 11, 2008 3:49 AM by George Nordic

Thank you very much!

Very usefull. You've saved a tonn of my time! :)

Kind Regards,

George

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

Saturday, June 14, 2008 11:02 PM by gbaja biamila

By the grace of allah, I found this link, my God bless you, you saved my day....

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

Monday, July 14, 2008 11:01 AM by Will Anderson

I wish any of you guess could describe the path to this .config files

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

Monday, July 14, 2008 11:01 AM by Will Anderson

I wish any of you guess could describe the path to this .config files

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

Sunday, July 20, 2008 8:54 PM by meysun

In IIS Manager (inetmgr) ,right click on the reports virtual directory and view the properties and you can get the local path from there. The web.config will be located in that local path.

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

Thursday, July 24, 2008 3:43 AM by wkn

thank you so much for helping me out of the mess!

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

Thursday, October 30, 2008 7:29 PM by Wendell

How will servicing of either TFS or MOSS effect this change?

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

Tuesday, April 07, 2009 2:44 PM by Ramesh Krishnan

Hi,

I'm trying to use Visual studio Reports to display Reports in MOSS Enterprise version. I'm getting "The type 'Microsoft.SharePoint.Portal.Analytics.UI.ReportViewerMessages, Microsoft.SharePoint.Portal, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c' does not implement IReportViewerMessages" error. If I comment out

<!--<add key="ReportViewerMessages" value="Microsoft.SharePoint.Portal.Analytics.UI.ReportViewerMessages, Microsoft.SharePoint.Portal, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" />-->

then the report works. What is the purpose of the above key and will it interfere anywhere in the enterprise version, if I comment it out

I appreciate your help very much

Thanks

Ramesh

# Issues Seen on Windows 2008

Monday, June 15, 2009 1:52 PM by Servcing For Released Products Of Team Foundation Server

If you have Report Server and SharePoint installed on the same port you might experience the following

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

Wednesday, June 24, 2009 12:11 PM by Alan

Thankyou so much, this was driving me mad! I only needed to add the

<remove key="ReportViewerMessages" />

Leave a Comment

(required) 
required 
(required) 

  
Enter Code Here: Required
 
Page view tracker