How to maintain sessions in ASP.Net using SQL Server

V

Vikram Sinha

In the sessionstate element of web.config for your app,
specify the mode as sqlserver. In addition to this, do the
following:

1. Run InstallSqlState.sql (installed by default in
<Drive>:\WINNT\Microsoft.NET\Framework\v1.0.2914) on the
machine with SQL Server that will store the session state.
This creates a database called ASPState with new stored
procedures and ASPStateTempApplications and
ASPStateTempSessions tables in the TempDB database.

2. Set the sqlConnectionString attribute. For example,
sqlConnectionString="data source=sarath;user
id=sa;password=MyPassword".

for more help refer...

ms-
help://MS.VSCC/MS.MSDNVS/cpgenref/html/gngrfsessionstatesec
tion.htm
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,744
Messages
2,569,484
Members
44,903
Latest member
orderPeak8CBDGummies

Latest Threads

Top