Configuring ASP.NET Session State
In this example we will setup the different modes of session state management that ASP.NET supports.
- SQLServer (out of process)
- This is where the session state is store out of process within a database
- StateServer (out of process)
- This is where the session state is store out of process on a remove server
- InProc (In Process)
- This is where the session state is store in process on the local server
The fastest method is InProc, but if the worker process is recycled all information is lost.
You configure a web applications state management within the web.config using the sessionState element, below are a few important attributes
- mode
- InProc / SQLServer / StateServer / Off
- cookieless
- AutoDetect / UseCookies / UseDeviceProfile / UseUri
- sqlConnectionString
- The connection string to the SQL Server
- stateConnectionString
- The connection string to the State Server
- timeout
- The time in minutes a session can be idle for it is abandoned. Default 20 minutes.
To setup SQL Session State management you first need to create the database,
A installation script can be found in this folder
C:\Windows\Microsoft.NET\Framework\v2.0.50727\InstallSqlState.sql
But you should install it using
aspnet_regsql.exe
Make sure the database owner is sa
use ASPState exec sp_changedbowner 'sa','true'
Then configure your web.config like this
To setup State Server Session Management, you need to start the ASP.NET State Service on the remote server using Administrative Tools > Services
C:\Windows\Microsoft.NET\Framework\v2.0.50727\aspnet_state.exe
Then configure your web.config like this
The standard approach is In Process Session State Management
Add Yours
YOU