Enable Session State in SharePoint 2007

Here's a procedure to enable Session State within your MOSS 2007 farm.

Our session state will be stored in our SQL Server database. 

This is required over the traditional memory-based session because of multiple application servers in a web farm architecture.

Secondly, in order for our web applications to store session variables in SQL, we need to "prep" the database for session state data. 

 

1.  Create a Shared Services Provider.  This is required in order to enable Session State and its content database is the location of our session data.  If you already have an SSP, you can use the existing one.

2.  If needed, associate your web application with this SSP (done by default if it is your first SSP).

3.  In Central Administration, under Application Management, choose Session State, and ensure that it is enabled.

4.  From a command prompt, navigate to the Microsoft.NET 2.0 Framework directory

(Typically:  C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727)

5.  Modify your web.config:

Uncomment the following line: 

<add name="Session" type="System.Web.SessionState.SessionStateModule" />

Modify the following line:

<pages enableSessionState="true" … />

6.  Run the following command:

aspnet_regsql.exe -S <server_name> -d <database_name> -ssadd -sstype c -E

 
 

Where:

<server_name>  is the database server where your database is located

<database_name>  is the content database of your shared services provider

 

Run aspnet_regsql.exe /?  for more information on the remaining options