Hi Dear Marty Spallone,
You can use the either StateServer or SqlServer to maintain the Session
State across
ASP.NET supports three modes of session state:
• InProc: In-Proc mode stores values in the memory of the ASP.NET worker
process. Thus, this mode offers the fastest access to these values. However,
when the ASP.NET worker process recycles, the state data is lost.
• StateServer:
=========
Alternately, StateServer mode uses a stand-alone Microsoft Windows service
to store session variables. Because this service is independent of Microsoft
Internet Information Server (IIS), it can run on a separate server. You can
use this mode for a load-balancing solution because multiple Web servers can
share session variables. Although session variables are not lost if you
restart IIS, performance is impacted when you cross process boundaries.
• SqlServer:
=======
If you are greatly concerned about the persistence of session information,
you can use SqlServer mode to leverage Microsoft SQL Server to ensure the
highest level of reliability. SqlServer mode is similar to out-of-process
mode, except that the session data is maintained in a SQL Server. SqlServer
mode also enables you to utilize a state store that is located out of the IIS
process and that can be located on the local computer or a remote server.
Note You can use all three modes with in-memory cookie or cookieless session
ID persistence.
StateServer
=======
Indicates that session state is stored on a remote server.
sqlConnectionString
----------------------
Specifies the connection string for a SQL Server. For example, "data
source=localhost;Integrated Security=SSPI;Initial Catalog=northwind". This
attribute is required when mode is SQLServer.
you just go through this link
HOW TO: Configure SQL Server to Store ASP.NET Session State
http://support.microsoft.com/kb/317604/
HOW TO: Configure ASP.NET for Persistent SQL Server Session State Management
http://support.microsoft.com/kb/311209/EN-US/
************************************************************
StateServer
========
Indicates that session state is stored on a remote server.
stateConnectionString
-------------------------
Specifies the server name and port where session state is stored remotely.
For example, "tcpip=127.0.0.1:42424". This attribute is required when mode is
StateServer.