Skip to main content

Posts

Showing posts from October, 2008

ASP.net Session Error remedy

Has your SQL server restarted lately; well if you're ASP.net application is reporting errors like these it might need some reconfigurations: SELECT permission was denied on the object 'ASPStateTempSessions', database 'tempdb', schema 'dbo'. INSERT permission was denied on the object 'ASPStateTempSessions', database 'tempdb', schema 'dbo'. UPDATE permission was denied on the object 'ASPStateTempSessions', database 'tempdb', schema 'dbo'. The cause of this is that your ASP.net application uses SQLServer session storage. This is generally a good design pattern; the SQLServer session storage allows you to have multiple webserver and thereby scale your infrastructure. SQLSession is one of three possible session storage method and is defined in the web.config with a directive like: <sessionstate mode="SQLServer" timeout="1440" sqlconnectionstring="Data Source=RelevantYellow.sql.relevanta