Save Asp.NET Session state in SQL Server

---

About author  Working on .NET technologies for past 2yrs. 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 Read more from this author

---

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

Read more post on ASP.NET 2.0 Microsoft sql server 

Leave a Comment

Name:

E-Mail :

Website :

Comments :