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,
Enable-SPSessionStateService
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=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a”
from “Type” dropdown as shown the image below. Click on Ok to save the
settings. Reset IIS.
