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!
If I helped you out today, you can buy me a beer below. Cheers!
No comments:
Post a Comment
Comments are very welcome but are moderated to prevent spam.