SharePoint 2010, this report failed to load because session state is not turned on.

The error usually comes when you install SharePoint 2010 in stand alone mode because if you do so the default behavior is that session state for access reports is not enabled and you need to do so. You generally come across this error while creating Contact, Asset and other type of Web Databases.

sessionstate

Enabling Session State for SharePoint 2010 Access Reports:

1) Open SharePoint 2010 Management Shell

2) Type in the following command PS C:\Users\sp> enable-SPSessionStateService

3) You should get the following response:-

cmdlet Enable-SPSessionStateService at command pipeline position 1
Supply values for the following parameters:

4) Type in the Database Name as accessreports (DatabaseName: accessreports) – This will create a new database in SQL names accessreports

5) You will be return to the root path PS C:\Users\sp>

sessionstate

6) Open the normal command prompt and restart the IIS by typing in iisreset

7) Go back to your site and check, Access reports will now be working ..

  • http://Website Aspergers Syndromes Symptoms

    this post is very usefull thx!

  • Pingback: SharePoint 2010: Neuerung – Access Web Access (Einführung und Beispiel) « SharePoint and relevant Technologies()

  • Amanda P

    Great job! Thanks for the help 🙂

  • Babu Nagalingam

    Nice…thank you.

  • Cstevenson

    This command crashed my web application/site collections.  Maybe it works for standalone and not farms.  If I can find additional information I will add.  Central Admin continued to work but all other webapps gave only http 500 error.  Just out of dumb luck not knowing exactly how to reverse it I typed disable-SPSessionStateService and luckily was able to recover the sites before I was flooded with phone calls.

  • Richard Collette

    How about:

    Enable-SPSessionStateService -DefaultProvision

     

    The session database being created is not application specific so naming the
    database it creates “accessreports” would be misleading to others.

  • http://quotesoftheday.net DBQuotes

    Did you remember the IISreset?

  • http://twitter.com/alexbnk Alex Benedek

    Thanks 🙂 !!!

  • Charushri Pawar

    I enabled session sate service but all of sudden after 4 to 5 month I have observed that size of database has increased to 232GB. I am not using Project wb database site. only I have created one Test site using Project web Database Template.
    Any suggestion?

    Thanks,
    Charu Pawar

  • David Carter

    Works for me without the need to iisreset

  • Manzolli

    Hello,
    I’m with the same HTTP Error 500.
    What did you do to solve this problem?

  • Andy_c

    I realize that this is a long time down the line but this may help other people so… You need to make sure your SQL server agent service is running otherwise expired sessions will not be cleaned up and the database will continue to grow.

  • Akhil Kumar

    Thanks dude it works for me