ASP.NET, SQL Server Session State, and SQL Server Service Pack 3 are a recipe for problems. Just a heads up but apparently there are some cross database ownership issues, introduced by SQL Server Service Pack 3, that will cause your database user to no longer be able to read and write to the temporary Session State tables.

Read about the problem and fix here.