Using SQL Server to store ASP.Net session state has it’s advantages. It was time for us to switch from InProc to SQL, but we ran into some problems getting the configuration right.

The SELECT permission was denied on the object ‘sysobjects’, database ‘mssqlsystemresource’, schema ‘sys’.]

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.

These two pages got me going in the end.

Now watch your session states survive an iisreset, or even server reboot! You can also load balance your requests over multiple web servers now too.