store session in database

[Maideen]

hi

anybody can tell

How can session store in mssql database? How to do SQLServer Session Mode start?

Pls help me

Maideen

[JorgeM]

Here is a step by step guide. http://support.microsoft.com/kb/317604

But why do you want to store session info in a DB?

Mor about SQL session mode start.
http://technet.microsoft.com/en-us/library/cc753897(v=ws.10).aspx

[Maideen]

jorgeM.
Good Question. Thanks
our organition needs to track who visted their application. They have few branches. So the want to store in data base who used their application.Normally session expires shortly.That why the need?

Pls help me

[JorgeM]

The most common reason I'm aware of to store sessions in database is in a scenario where you have several front end load balanced web servers, so you need a shared session storage for them.

If you want to track users, one approach is to have them log on your web application. you can issue a cookie and track the user on subsequest events by checking for this cookie.

You can track by other means, maybe capturing the source IP address and storing that info in a database table.

Other options, various variations....

[Maideen]

Thanks Mr.JorgeM
Your point of view is great. I will dicuss with client IT teams about your points.

Thank you very much.