Monday, December 27, 2010

SQL Server Session State woes

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.

This error is so misleading. In our current setup, most of the time this error comes up not because SQL Session State isn't installed, but because the user account that is accessing the session state database doesn't have permissions to the sprocs. Quick and dirty fix? Grant that account db_owner on the session state DB.