Access Services: solving this report failed to load because session state is not turned on.

I noticed the following error recently in one of the Access web databases driven by Access Services in SharePoint Server 2010.

“This report failed to load because session state is not turned on. Contact your SharePoint farm administrator. Troubleshoot issues with Microsoft SharePoint Foundation. Correlation ID: 6968e6db-d139-4b88-bf5a-7c39c2e4a6be  Date and Time: 6/16/2010 7:37:01 AM”

The strange thing was that the State Service was in running state (within SharePoint Central Admin > Manage Service Applications). Underlying Access Services seems to use a ReportViewer Control so this article – Using Access Services with SQL Reporting Services provided the solution:

Enable the Session State for the farm by opening the SharePoint Management Shell. Enter the command [Enable-SPSessionStateService –DatabaseName “foobar”] — The DatabaseName value is the database that will be created on the computer that is running SQL Server. Perform an IIS reset.

Technorati Tags: sharepoint,access+services,sharepoint+2010,sharepoint+server+2010,microsoft