Compartilhar via

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

  • Artigo

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.

Comments

  • Anonymous
    December 04, 2007
    The comment has been removed

  • Anonymous
    February 16, 2008
    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.

  • Anonymous
    February 27, 2008
    Thanks a lot for the helpful tips. regards & best wishes !!

  • Anonymous
    March 01, 2008
    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.

  • Anonymous
    June 10, 2008
    Thank you very much! Very usefull. You've saved a tonn of my time! :) Kind Regards, George

  • Anonymous
    June 14, 2008
    The comment has been removed

  • Anonymous
    July 14, 2008
    I wish any of you guess could describe the path to this .config files

  • Anonymous
    July 14, 2008
    I wish any of you guess could describe the path to this .config files

  • Anonymous
    July 20, 2008
    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.

  • Anonymous
    July 23, 2008
    thank you so much for helping me out of the mess!

  • Anonymous
    October 30, 2008
    How will servicing of either TFS or MOSS effect this change?

  • Anonymous
    April 07, 2009
    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

  • Anonymous
    June 15, 2009
    If you have Report Server and SharePoint installed on the same port you might experience the following

  • Anonymous
    June 24, 2009
    Thankyou so much, this was driving me mad! I only needed to add the <remove key="ReportViewerMessages" />

  • Anonymous
    January 24, 2010
    Problem solved :) very usefull help

  • Anonymous
    June 19, 2010
    sorry i don't know where in webconfig to add that statement please help.