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
3 replies
Last post Aug 04, 2015 12:43 PM by sirajhussain
Last post Aug 04, 2015 12:43 PM by sirajhussain
None
0 Points
6 Posts
Unable to use SQL Server because ASP.NET version 2.0 Session State is not installed on the SQL se...
Mar 07, 2006 10:24 AM|Scout77|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?
None
0 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 04:27 AM|Eng_Ahmad_2007|LINK
None
0 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 04:58 PM|Tesfaye Gari|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.
None
0 Points
4 Posts
Re: Unable to use SQL Server because ASP.NET version 2.0 Session State is not installed on the SQ...
Aug 04, 2015 12:43 PM|sirajhussain|LINK
Either install ASP.NET version 2.0 Session State, else change sessionState from <sessionState mode="SQLServer" to "<sessionState mode="InProc" in web.config