SharePoint is a configuration nightmare. There are so many settings that the more configuration settings you learn, the more you learn there are more settings that you’ve not even discovered yet. For reporting, and specifically for me, running reports under an Issue Tracking site, SessionState must be turned on for the SharePoint 2010 web application. If you don’t, you’ll get the error:
“This report failed to load because session state is not turned on. Contact your SharePoint farm administrator.”
To enable SessionState, follow these steps:
- Open Internet Information Services (IIS) Manager
- Navigate to down to the site that is your SharePoint 2010 instance. Typically, this will be named “SharePoint – 80”.
- Open the Modules settings.
- Under the Actions menu to the right, select Add Managed Module…
- Wait for the dialog to pop up…(it takes a bit)
- Enter a name for the new module, like “SessionState” (this is for reference only), and select the type of System.Web.SessionState.SessionStateModule, Version=18.104.22.168.
Now SessionState is enabled for your SharePoint site!
Note: If you decide to install Project Server or Team Foundation Server on the same server farm as your standard SharePoint instance(s), then they will automatically install the SessionState module during their configuration. If you have previously installed the SessionState module and then install SPS or TFS, then you will need to go back in and remove the SessionState module that you added, as there will then be two conflicting references and will bring down all SharePoint sites with an error. Just remove your reference and everything will be back to normal.