how to solve 'This report failed to load because session state is not turned on. Contact your SharePoint farm administrator ' error when configure the SharePoint 2010 web database picture(just grab it from other same problem post) below
when I try to create a sharepoint 2010 web database, everything is ok, but the report does not show up.
it gives me the error above. I check the some answer about that. someone says use PS C:\Users\sp> enable-SPSessionStateService to solve that problem. but it doesn't work on my case, actually, I can not executive that command, then I think maybe something wrong with my reporting service, my reporting service is integrated with sharepoint already. then found it is because IIS 7 has separate modules for each website. then use this way to solve the error, it works fine for me.
1.Open Internet Information Services (IIS) Manager
2.Go to your SharePoint site my case is “SharePoint - 80”.
3.Open the Modules settings. it's in the second block in right section
4.In the Actions menu to the right, select Add Managed Module…
5.Enter a name for the new module, like “SessionState” (this is for reference only), and select the type of System.Web.SessionState.SessionStateModule, Version=2.0.0.0.
6. reset your IIS.
7 go to your database page , you can see the report works now.
