While working with SharePoint access services, Browsing contacts after publishing the Contacts form in SharePoint site I got an error saying that,
“This report failed to load because session state is not turned on. Contact your SharePoint farm administrator” as shown the image below.
We can fix this error by enabling the session state for SharePoint access reports. To do that we have to run the following Power Shell commands in SharePoint Management Shell with Administrator privileges,
We can see the response to provide the Database name. Enter Database base as AccessServiceReports (We can enter any name). A database will be created with the name in SQLServer. Reset IIS (IISRESET)
We can enable session state for web application if we still have the problem. We can do that by using the steps below,
Open IIS Manager and Select the web application by expanding sites list. In IIS Section, double click on “Modules”.
In Top Right side of the modules window, click on “Add Managed Module” link.
We can see “Add Managed Module” popup window. Enter any unique name in “Name” text box and specify the Type as “System.Web.SessionState.SessionStateModule, System.Web, Version=18.104.22.168, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a” from “Type” dropdown as shown the image below. Click on Ok to save the settings. Reset IIS.