Sharing session state between 2 ASP.NET applications using SQL Server
- by Dave
Hi
I'm working on a site that has a requirement to share session between a cms application and an online store application on the same domain eg.
mydomain.com
and
store.mydomain.com
I've made some progress with it and it works on my local build between
localhost/cms
and
localhost/store
Basically I have done what is suggested in this article
http://blogs.msdn.com/toddca/archive/2007/01/25/sharing-asp-net-session-state-across-applications.aspx
and hacked the TempGetAppID Stored Procedure to return the same application id (1). This appears to work as it creates sessions with ids like 'abv5d2urx1asscfwuzw3wp4500000001', which is what I'd expect.
My issue is that when I deploy it to our testing environment, it creates a new session when I navigate between the 2 sites. So when I start a session on the cms site, if I navigate to the store, it creates a new session. These are set up as 2 different websites in IIS7.
In the web.config files for both sites, the and elements are both the same and are as follows (minus sensitive information)
Has anyone got an ideas why this might not be working? I am sharing Forms Authentication across the 2 sites and that works fine. Any help or ideas would be greatly appreciated!
Many thanks
Dave