10 Aug 2011

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

Setting up a new MVC 3 (ASP.NET 4) site, using SQL Session State. Got the message:

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

But I *had* set up Session State, so this was perplexing.

Turns out this was because I had only given the ASP.NET user db_datareader and db_datawriter permissions on the Session State database. Those permissions don't allow the user to EXEC sprocs. I gave the user db_owner perms and all was well.

Stupid unhelpful error message!

No comments:

Post a Comment

Comments are very welcome unless you're a spammer, in which case you should probably kill yourself.

If I helped you out today, you can buy me a beer below. Cheers!