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.

Question

User1953919853 posted

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?

Answer 1

User2036345665 posted
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p> </o:p>Go to aspstate database èright click è propertiesèpermission èadd (public ) database role ègive permission to this role è>and enjoy<o:p></o:p>

Answer 2

User-1950623348 posted

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.

Answer 3

User-1873776877 posted

Either install ASP.NET version 2.0 Session State, else change sessionState from <sessionState mode="SQLServer"  to "<sessionState mode="InProc" in web.config