Unable to use SQL Server because ASP.NET version 2.0 Session State is not installed on the SQL server. Please install ASP.NET Session State SQL Server version 2.0 or above. RSS

• • Reply
  

  Scout77

  Member

  35 Points

  7 Posts

  Unable to use SQL Server because ASP.NET version 2.0 Session State is not installed on the SQL se...

  Mar 07, 2006 02:24 PM|LINK

  Can anybody point me in the direction of how to resolve this error,

  Unable to use SQL Server because ASP.NET version 2.0 Session State is not installed on the SQL server. Please install ASP.NET Session State SQL Server version 2.0 or above.

  I am running Visusl Studio 2005, SQL Server 2005 Standard, running on WIndows XP Pro.

  I am trying to use SQL for session state management. I originally ran the following code from the command line prompt,

  aspnet_regsql.exe -E -ssadd -sstype p

  This created an ASPState database. I then manually added my default ASP.NET login as a user. In my web.config file I have the following

  <sessionState mode="SQLServer" sqlConnectionString="Integrated Security=SSPI;data source=localhost;" timeout="20" />

  I have searched the web without success and this issue is starting to drive me crazy! I am sure that it must be something totally stupid that I am missing. Can anybody help?

• • Reply
  

  Eng_Ahmad_20...

  Member

  2 Points

  1 Post

  Re: Unable to use SQL Server because ASP.NET version 2.0 Session State is not installed on the SQ...

  Dec 04, 2007 08:27 AM|LINK

   Go to aspstate database èright click è propertiesèpermission èadd (public ) database role ègive permission to this role è>and enjoy
• • Reply
  

  Tesfaye Gari

  Member

  2 Points

  1 Post

  Re: Unable to use SQL Server because ASP.NET version 2.0 Session State is not installed on the SQ...

  Aug 05, 2010 08:58 PM|LINK

  Thanks for the post. I had got the same problem after I add a webpart on my Share Point site. I have given the Control Permission to the user who logged to the site and It started working.