473,769 Members | 4,470 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

SQLServer Session storage and multiple sites

Hi,

We have implemented a IIS NLB farm and would like to know if a SQL
Session database can be used to host multiple sites? As the entry in
web.config does not allow a database name to be specified it would mean
either multiple instances / servers if more than 1 site needed to store
session in a SQL database. As such I am guessing it will work but I would
like to confirm this.

Any info would be great

Cheers

Dave
Nov 18 '05 #1
2 1826
Dave Wright wrote:
Hi,

We have implemented a IIS NLB farm and would like to know if a SQL
Session database can be used to host multiple sites? As the entry in
web.config does not allow a database name to be specified it would mean
either multiple instances / servers if more than 1 site needed to store
session in a SQL database. As such I am guessing it will work but I would
like to confirm this.

Any info would be great

Cheers

Dave


the database is created in the tempDB of the database and it will take
care of multiple sites, in other words one database server can take care
of multiple worker processes on multiple machines

Nov 18 '05 #2
hi,
this is amit
we r into rnd phase of

SQLserver mode.
hv u been using this mode
live
any issues u faced with it
can u share it
--
Thanks and Regards,

Amit Agarwal
Software Programmer(.NET )
"Corey O'Mara" <co***@homnick. com> wrote in message
news:ON******** ******@TK2MSFTN GP11.phx.gbl...
Yes, SQL Session DB can handle multiple instances and sites without a
problem.

Framework v1.1 provides both Install_SQLStat e.sql and
InstallPersist_ SQLState.sql the different being using tempdb (volatile
storage) vs. ASPState database (durable storage).

--
Corey O'Mara
MCSD.NET, MCT

"Dave Wright" <da*******@Wrig hty.net> wrote in message
news:%2******** ********@TK2MSF TNGP11.phx.gbl. ..
Hi,

We have implemented a IIS NLB farm and would like to know if a SQL
Session database can be used to host multiple sites? As the entry in
web.config does not allow a database name to be specified it would mean
either multiple instances / servers if more than 1 site needed to store
session in a SQL database. As such I am guessing it will work but I would like to confirm this.

Any info would be great

Cheers

Dave


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.580 / Virus Database: 367 - Release Date: 2/6/2004
Nov 18 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

7
2370
by: Bart Torbert | last post by:
Hello, I am starting to examine using SQLServer instead of Oracle. I went through the SQLServer import utility to copy tables from Oracle into SQLServer. I then checked the size of the database. I then started to specify indices for the tables. I did not see the database file size grow all that much. I kept on using the shrink command to make sure that wasted space was removed. I even made sure that minimal free space was allowed.
4
4007
by: John Q. Smith | last post by:
I'm trying to find out some of the details behind OOP state management with SQL Server. For instance - how long does the session object live on any server? Is it created and destoyed with each page request? - will each reading of a session variable cause a round trip to the DB server? or does the complete session live within the HttpContext object? - when asp.net session state is enabled (in any mode), after a session has been created,...
1
2690
by: Julie Barnet | last post by:
Hi, I am having a problem with my session state through sql server. This used to work, then all of a sudden (the only change was setting up replication in the sqlserver database) it stopped working. I ran uninstallsqlstate.sql after stopping w3svc and then restarted the w3svc and rean installsqlstate.sql. This works fine on my machine and my session variables work again....but I'm an administrator on the database. I go to another...
8
8420
by: karahan celikel | last post by:
I realized that when SqlServer mode is used for session management Session_End event is not fired in global.asax. What can I do if I want to do something when a user's session end? Thanks
2
1274
by: Kishore Gopalan | last post by:
Hi, Is there a set of APIs that would let me access the tables where ASP.NET stores the state when in SQLServer mode. Thanks. Kishore
43
3435
by: davidkoree | last post by:
I mean not about cookie. Does it have something to do with operating system or browser plugin? I appreciate any help.
13
8674
by: Samir Chouaieb | last post by:
Hello, I am trying to find a solution to a login mechanism for different domains on different servers with PHP5. I have one main domain with the user data and several other domains that need a login to show data. I want the user to login only once when he visits any of my domains.
3
3461
by: Moe Sisko | last post by:
Using dotnet 2.0 sp1, I've got ASP.NET session state working ok in SQLServer mode, but the sessions never seem to expire. e.g if I add a timeout attribute like so : <sessionState mode="SQLServer" sqlConnectionString="Integrated Security=SSPI;data source=localhost" timeout="1" >
9
7812
by: Josh | last post by:
I run a Joomla website and am familiar with php in some but not all aspects. Currently I am trying to find some solutions related to session handling. Am I correct in saying that "login" is kept in sessions? I can see active sessions in my mysql database, but is that the only place this information is stored? Sessions and cookies I know are related also, but how specifically (session info stored in cookies?)? Right now, when users...
0
10223
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10051
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
10000
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
8879
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
7413
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6675
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5448
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3968
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
3571
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.