“This report failed to load because session state is not turned on” – Access Services issue in SharePoint 2010

When I configured my first SharePoint 2010 sandbox, I tried creating access services and received below error:

"This report failed to load because session state is not turned on" - Access Services issue in SharePoint 2010

So, it’s telling us to enable Session state. Isn’t it?

How to Enable Session State for SharePoint 2010?

  1. Open SharePoint 2010 Management Shell
  2. Type in the following cmdlet: Enable-SPSessionStateService
  3. Provide values for the following parameters:
  4. Type in the Database Name as “SP2010_Farm_Access_Service” (DatabaseName: SP2010_Farm_Access_Service) – This will create a new database in SQL names SP2010_Farm_Access_Service
  5. Do an IISReset
  6. Now, the Access reports should work!

Verify the following thing if you still get errors in access services in SharePoint 2010:

  • Access Services is installed part of the SharePoint 2010 Enterprise CAL
  • Make sure Service Infrastructure is enabled
    • Manage Services on Server – Access Database Service is started
    • Manage Services Applications – Review the Settings, No need to change any performance tuning settings
    • Manage Web Applications – Make sure application is associated with the Access Servic
  • Make sure all the features are activated
    • Central Admin -> System Settings -> Manage Farm Features -> Access Services Farm Feature
    • Central Admin -> Manage Web Applications -> Select Web Application hosting the Access Services Site -> Manage Web Application Features -> SharePoint Server Enterprise Web application features
    • Site Collection -> Site Settings -> SharePoint Server Enterprise Site Collection features
    • Site Collection -> Site Settings -> SharePoint Server Enterprise Site features
  • To the Access Reports on the web, Access Services requires
    • SSRS Add-in for SQL Server 2008 R2 (It doesn’t require SQL 2008 R2)

Salaudeen Rajack

Salaudeen Rajack is a SharePoint Architect with Two decades of SharePoint Experience. He loves sharing his knowledge and experiences with the SharePoint community, through his real-world articles!

One thought on ““This report failed to load because session state is not turned on” – Access Services issue in SharePoint 2010

Leave a Reply