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 **** that I am missing. Can anybody help?
Go to aspstate database Ã¨right click Ã¨ propertiesÃ¨permission Ã¨add (public ) database role Ã¨give permission to this role Ã¨>and enjoy