Save Asp.NET Session state in SQL Server

Session states of the asp.net application can be easily saved into SQL Server using the following steps:

1. Change the settings in the web.config file.

    <sessionState mode=   allowCustomSqlDatabase="true"  
   cookieless="false" timeout="20" sqlConnectionString=
   "database=Test_globalBms ;
   user id=abc;password=abc123$;server=172.27.68.1 " />
   

2. In the database create the appropriate tables.It is done automatically wen we execute the exe aspnet_regsql.exe located at C:\WINDOWS\Microsoft.NET\Framework\v2.0. location