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.

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?

0 Scout77 3/7/2006 3:24:08 PM

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

0 Eng_Ahmad_2007 12/4/2007 9:27:08 AM