SQL Server to manage ASP.NET sessions doesn't work

Posted by windforceus on Stack Overflow See other posts from Stack Overflow or by windforceus
Published on 2012-05-30T21:42:05Z Indexed on 2012/05/30 22:41 UTC
Read the original article Hit count: 208

I follow the direction in here How to configure SQL Server to manage ASP.NET sessions to create ASPState db. I have 2 web application in IIS 7. In IIS web application setting, i go to "Session State" and set session state as "SQL Server" and provide connection string. In each web application web.config, i add

<sessionState
       mode="SQLServer"
       allowCustomSqlDatabase="false"
       sqlConnectionString="data source=server;user id=user;password=password"
       cookieless="false"
       timeout="7200"
/>

I create a session ,

Session["Data"] = "test"

in Web App A and go to Web App B in the same browser to print it

Response.Write(Session["Data"]);

It shows NOTHING. I can see there are data in table : ASPStateTempApplications and ASPStateTempSessions under ASPState Database. Also, i dont see any error in event log. Can anyone think anything i may do wrong?

Thanks!!

© Stack Overflow or respective owner

Related posts about ASP.NET

Related posts about iis7