Configuring Out-of-Process Session State with SQL Server

  • Article

Applies To: Windows Server 2003, Windows Server 2003 with SP1

If you decide to store the session state in SQL Server, you need to create the session state database on the computer running SQL Server that is used by the ASP.NET state service. You can create the database by running the InstallSqlState.sql script on the computer running Microsoft SQL Server that is going to be storing the session data. This script creates a database called ASPState, which includes several stored procedures and adds the ASPStateTempApplications and ASPStateTempSessions tables to the TempDB database.

For more information about creating the SQL Server database for storing ASP.NET session state, see Create A SQL Server Database for Storing ASP.NET Session State.