ASP.NET version 2.0 Session State is not installed on the SQL server

Sometime ago I encountered this error upgrading an ASP .NET 1.1 application to 2.0

"Unable to use SQL Server because ASP.NET version 2.0 Session State is not installed on the SQL server"

To solve it just run this command in the server of SQL

aspnet_regsql.exe -S <servername> -E -ssadd -sstype c -t <customtable>



This happened because when  I was using SQL Session State, so don't forget to change the web.config element sessionstate to have the attribute allowCustomSqlDatabase equals true

Something like this

<sessionState
mode="SQLServer"
allowCustomSqlDatabase ="true"
cookieless="true"
sqlConnectionString=" Integrated Security=SSPI;data source=MySqlServer;Initial catalog=customtable;"
sqlCommandTimeout="10" /