preventing multiple logins

[sameer.gupta]

one important problem i am facing is that my web solution
(asp.net) will be deployed on a webfarm. I am using sql
server session management on clustered sqlservers. but as
i need to prevent multiple logins through a
username/password (same credentials at a time) on the
website.

also session_end() event does not fire in sql server mode.

one solution is sychronized cache of webservers. and
maintaining usernames (loggedin) in the application cache.
This solution does not look like a robust solution.
suggest a standard solution.


please help me.

Regards
Sameer

 

[Natty Gur]

Hi,

I implement solution for one of my client, but it's not an easy one.

What I’ve done is create my one Page class and delegate all the session
functionality (since session class is sealed). the delegate function use
the session cookie ID to get Session data from DB (the same as ASP.NET
does). Using this pattern you can get what ASP.NET sql server session
gives you and still use the session’s events.

Yes, I know its not so easy but it works ...

Natty Gur[MVP]
Phone Numbers:
Office: +972-(0)9-7740261
Fax: +972-(0)9-7740261
Mobile: +972-(0)58-888377

 

[amjathrahman]

Hi,

I am sql server to store the session state, i want to add 2 more columns to the aspstatetempsessions table, ok, i use alter query to modify the table.

i dont from where i have to pass the values to that column.

what are all the sp's i have to change.

plaese guide me.

with regards
Amjath.