How to enable ASP.NET SQL Server Session on your web application

In ASP.NET, there are 3 different modes for storing session information:

  • InProc
  • StateServer
  • SQLServer

We support both InProc and SQLServer session. By default, ASP.NET session is stored in-process (InProc). There are benefits and drawbacks for each method.

InProc mode offers the fastest performance because session is stored in the IIS Worker Process. The downside of InProc session is that sessions can be lost if the worker process is recycled for any reason.

SQL Server session on the other hands is slower than InProc, about 15-20% slower, but the session information remains persistent even after the worker process is recycled.

You should choose a state management mode that is appropriate for your application. For example, if losing session is not acceptable, you should consider using SQL Session rather than InProc.

To enable SQL Server Session:

- While not required, we recommend adding a new MS SQL database in the control panel, dedicated for sessions storage only, to avoid potential conflicts.

- Create a support ticket to request an installation. Include the Database name and the version of ASP.NET you are using.

- You will receive an email as soon as the Session State database schema is created.

- Update your web.config file as follows:

< sessionState
allowCustomSqlDatabase = "true"
sqlConnectionString="data Source=<SQLSERVERNAME>;database=<SQLDATABASENAME>;user id=<SQLUSER>;password=<SQLPASSWORD>"
Session information should be stored in your SQL database now.

If you run into problems while using this code, we suggest you to get the answer from related community forum. Technical support cannot assist with specific coding related issues.