Save Asp.NET Session state in SQL Server

dotnetlogo
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

kick it on DotNetKicks.com

Anky Goyal

I am MCPD certified in .NET and working on .NET technologies for past 3yrs. I am very passionate about the new features which get introduced in the technology. I am here to share the new features i get to know in the world of Microsoft. Follow me on twitter @ankygoyal [email protected]Ankit Goyal

More Posts - Website