locked
Web app Session State HTTPException 0x80004005: ASP.NET version 2.0 not installed, need dbo.TempGetVersion permission RRS feed

  • Question

  • Hi,

    I'm getting this error when logging into my Web application that uses SQL Server 2012 SqlMembershipProvider:

    "Unable to use SQL Server because either ASP.NET version 2.0 Session State is not installed on the SQL Server, or ASP.NET does not have permission to run dbo.TempGetVersion stored procedure.  If the ASP.NET Session State schema has not been installed, please install ASP.NET Session State SQL Server version 2.0 or above.  If the schema has been installed, please grant permission on the dbo.TempGetVersion stored procedure to either the ASP.NET application pool identity, or the Sql Server user in the sqlConnectionString attribute."

    Don't know how to fix this.  Appreciate any help.

    Friday, November 20, 2015 4:39 PM

Answers

  • This forum is about SQL Server security in general, and your question is about some ASP .NET thing which is not in the scope for this forum.

    The error message appears to give a number of possible causes and suggests some measures you can take. Have conducted any investigations to see if any of the suggested causes apply. For instance, is Session State installed? (That Sesssion State is not an SQL Server feature, but something which supposedly is part of ASP NET.)

    Friday, November 20, 2015 10:53 PM

All replies

  • This forum is about SQL Server security in general, and your question is about some ASP .NET thing which is not in the scope for this forum.

    The error message appears to give a number of possible causes and suggests some measures you can take. Have conducted any investigations to see if any of the suggested causes apply. For instance, is Session State installed? (That Sesssion State is not an SQL Server feature, but something which supposedly is part of ASP NET.)

    Friday, November 20, 2015 10:53 PM
  • Hi NitroGem,

    For ASP.NET issues, please post the question in the ASP.NET Forums at http://forums.asp.net/ . It is appropriate and more experts will assist you.

    Thanks,
    Lydia Zhang


    Lydia Zhang
    TechNet Community Support


    Monday, November 23, 2015 1:53 AM