19Nov/102
This report failed to load because session state is not turned on
Like I said in one of my comments, I’ll be posting some about SharePoint 2010. Here’s the first.
I ran into an issue when checking out the new Asset Web Database site template. When I tried to access the reports I was confronted with the error “This report failed to load because session state is not turned on”.
After some googling I found the answer. Because I installed SharePoint 2010 as a standalone server the Session State Service was not enabled. To enable the Session State Service you have to run the Enable-SPSessionStateService cmdlet in the SharePoint 2010 Management Shell. This will create a database with the name that you need to provide in the command line or after it’s asked. After doing an iisreset you should be good to go.
December 3rd, 2010 - 00:17
This may be a silly question, but how do I know which DatabaseName to use?? I’m having the same issue…
December 3rd, 2010 - 08:57
It’s a new database that will be generated on the database server. So the name is all up to you, or up to the naming standards provided you have standards. I named mine SPSessionState.