ASP.NET 2.0 SQL Server Session State

Posted on January 3, 2007 - Filed Under ASP.NET 2.0

Whilst migrating another Web app to ASP.NET 2.0 I encountered 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.”

There doesn’t seem to be a massive amount of info online about this and I found myself going around in circles a little until I discovered this gem on MSDN:

http://msdn2.microsoft.com/en-us/library/ms229862(vs.80).aspx

Rather than paraphrase what is nicely written on MSDN I’ll just say you need to run Aspnet_regsql.exe with Session State parameters (which are listed in the article).

Good luck!

Social Bookmarking