Tuesday, December 04, 2007

Cannot use 'partitionResolver' unless the mode is 'StateServer' or 'SQLServer'

Issues: When you install Report Services 2005 on server that is running sharepoint (WSS 3.0) or MOSS. You will receive this error message when you try to access


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 133:    webParts
Line 134: machineKey validationKey="7A64E08BE8080CFA1C6B0855A414997E85C880F666CCA555" decryptionKey="25444543D5621B3EF55E53EB54E0A71A9FA23E97C5965C48" validation="SHA1"
Line 135: sessionState mode="SQLServer" timeout="60" allowCustomSqlDatabase="true" partitionResolverType="Microsoft.Office.Server.Administration.SqlSessionStateResolver, Microsoft.Office.Server, Version=, Culture=neutral, PublicKeyToken=71e9bce111e9429c"

Source File: C:\Inetpub\wwwroot\wss\VirtualDirectories\80\web.config Line: 135

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


Here are the steps I followed to resolve this issue:
  1. Locate the Web.config file for reporting services
  2. Usually located in "DRIVE:\Program Files\Microsoft SQL Server\MSSQL.5\Reporting Services\ReportManager"
  3. Save a copy of web.config file (as web_old.config)
  4. Open the web.config file and search for "sessionState mode"
  5. Add partitionResolverType="" as shown below
  6. Save the web.config file

  7. Try to access report manager http://servername/reports