I installed a new aspstate database on a virgin server, and we kept getting the following 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'd installed it from the Version 2 framework, and got successful response
C:\Windows\Microsoft.NET\Framework\v2.0.50727>aspnet_regsql.exe -ssadd -sstype c -d ASPState -S eduat1sql1 -E
Start adding session state.
....
Finished.
To use this custom session state database in your web application, please specify it in the configuration file by using the 'allowCustomSqlDatabase' and 'sqlConnectionString' attributes in the <system.web>\<sessionState> section.
You will note, that I have used the integrated switch, this is because I don't want the ultimate ASPNET user to have database creation permissions. Initially, I have the ASPNET database user db_datareader and db_datawriter roles and I think this is where the issue arose. I removed this permissions and allocated db_owner role and all is working!