Sharing sessions across applications using the ASP.NET Session State Service

by

I did it this way:

Basically the idea is both apps use native .net sessionState stored in sqlserver. By using the same machine key and making a small tweak to a stored procedure – both apps can share any session keys and/or forms authenication.

Both apps would do something like this in their web.config:

<sessionState mode="SQLServer" sqlConnectionString="Data Source=.\SQLEXPRESS;User Id=test;Password=test;Application Name=AppName"  />
    <machineKey
validationKey="SOMEKEY"
validation="SHA1" decryption="AES"
/>

Session state db would need to be set up on a database server, that both apps can see.

Docs for doing this:
http://msdn.microsoft.com/en-us/library/ms229862(VS.80).aspx

Command that would need to be run:
C:\Program Files (x86)\Microsoft Visual Studio 9.0\VC\bin>aspnet_regsql.exe -E -ssadd –sstype p -S .\SQLEXPRESS

Stored procedure (TempGetAppID) tweak to:

 @appId int OUTPUT
AS

    -- start change

    -- Use the application name specified in the connection for the appname if specified
    -- This allows us to share session between sites just by making sure they have the
    -- the same application name in the connection string.
    DECLARE @connStrAppName nvarchar(50)
    SET @connStrAppName = APP_NAME()

    -- .NET SQLClient Data Provider is the default application name for .NET apps
    IF (@connStrAppName <> '.NET SQLClient Data Provider')
        SET @appName = @connStrAppName

    -- end change

SET @appName = LOWER(@appName)

More Related Contents:

  1. How do I create a custom membership provider for ASP.NET MVC 2?
  2. ASP.NET MVC 5 group of radio buttons
  3. Questions about using Ninject
  4. Passing data between different controller action methods
  5. Is Task.Run considered bad practice in an ASP .NET MVC Web Application?
  6. Why Interface Layer/Abstract classes required in our project? [closed]
  7. Passing data to Master Page in ASP.NET MVC
  8. Displaying standard DataTables in MVC
  9. How to enable cross origin requests in ASP.NET MVC [duplicate]
  10. Do I need a Global.asax.cs file at all if I’m using an OWIN Startup.cs class and move all configuration there?
  11. How do I display the DisplayAttribute.Description attribute value?
  12. ASP.Net MVC route to catch all *.aspx requests
  13. How to create roles in ASP.NET Core and assign them to users?
  14. Visual Studio – Resx File default ‘internal’ to ‘public’
  15. Write PDF stream to response stream
  16. MvcSiteMap generating a Menu without messing the breadcumbs
  17. How do I route images using ASP.Net MVC routing?
  18. MEF with MVC 4 or 5 – Pluggable Architecture (2014)
  19. ASP.NET MVC – Slow initial load
  20. Get UserID of logged-in user in Asp.Net MVC 5
  21. Web Api Request Content is empty in action filter
  22. Redirect to another page when user is not authorized in asp.net mvc3
  23. How do you post a JSON file to an ASP.NET MVC Action?
  24. Login page on different domain
  25. How to create Select List for Country and States/province in MVC
  26. How to use multiple form elements in ASP.NET MVC
  27. Specify Date format in MVC5 (dd/MM/yyyy)
  28. Unable to resolve service for type ‘Microsoft.AspNetCore.Identity.UserManager` while attempting to activate ‘AuthController’
  29. Display string as html in asp.net mvc view
  30. LINQ to Entities does not recognize the method ‘System.String ToString()’ method in MVC 4

Leave a Comment