“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 - Information Technology Expert with Two-decades of hands-on experience, specializing in SharePoint, PowerShell, Microsoft 365, and related products. He has held various positions including SharePoint Architect, Administrator, Developer and consultant, has helped many organizations to implement and optimize SharePoint solutions. Known for his deep technical expertise, He's passionate about sharing the knowledge and insights to help others, through the 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

Your email address will not be published. Required fields are marked *