Reporting Services and SharePoint 2007 install

I'm trying to install SharePoint 2007 and Reporting Services 2005 on the same server. However after installation Reporting Services will not load athttp://localhost/Reports. Instead I get the following error:

Server Error in '/Reports' Application.

Configuration Error

Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.

Parser Error Message: Cannot use 'partitionResolver' unless the mode is 'StateServer' or 'SQLServer'.

Source Error:

Line 164: </webParts>

Line 165: <machineKey validationKey="DA65D9E6980E9CDB52426BF3C793EBAF7FBA3B866117F3CC" decryptionKey="9D7E984E12AA43FDECAB1E05D1E952822680D27BD1F37439" validation="SHA1" />

Line 166: <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" />

Line 167: </system.web>

Line 168: <runtime>


Source File: C:\Inetpub\wwwroot\wss\VirtualDirectories\c76013d9-5b44-4d06-96dd-24fede1ea955\web.config Line: 166

Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42


I assume that something is wrong with my virtual server set up. I have the Default Web Site stopped and SharePoint (80) running and set Reports and ReportServer using the Report Configuration to SharePoint (80).

I can get tohttp://localhost/ReportServer but I get this error when running a report from there:

Reporting Services Error


  • An internal error occurred on the report server. See the error log for more details. (rsInternalError)Get Online Help

    • The type Microsoft.SharePoint.Portal.Analytics.UI.ReportViewerMessages, Microsoft.SharePoint.Portal, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c does not implement IReportViewerMessages or could not be found

Has anyone set these up on the same server? Is there a document around on how to set this up?

Thanks
Kevin

[4038 byte] By [Kevin_B] at [2007-12-22]
# 1

Issues I have seen in the past with previous versions of Sharepoint usually involved one of two things.

1. Sharepoint and RS were sharing the same application pool in IIS. To fix this, move the RS virtual directories to their own application pool.

2. The web.config file had permissions issues. Adding everyone read permissions to the file and folder fixed the problem.

Two of my team members work with Sharepoint 2007. One has never had an issue with side by side installs. The other mentioned that he needed to install RS to a different website because Sharepoint had exclusive use on Port:80. He created a new website and installed RS to Port:81.

BradSyputa-MS at 2007-8-30 > top of Msdn Tech,SQL Server,SQL Server Reporting Services...

SQL Server

Site Classified