Hi,



I have question regarding how to manage session across

web servers. In Chapter1 of "A Preview of ASP+" page36, mention

that  the session content can be serialized out into temporary

SQL Server database table.Also, in the bottom of the page 189

said that "we do have several new options for how to manage user

sessions".  I could not find in which part of the book talking about

how to do it though except Appendic C Session Object providing

its properties and methods. Any one know or done something about it?



Thanks,

Ken

Hi Ken,



Here are the steps to enable out of process (and remote machine) session

state:



1) Start the ASP+ State Store on a target machine:



type: "net start aspstate"



2) Modify your config.web file in your application directory root to run

"out of proc" and against the state machine:



<configuration>

   <sessionstate inproc="false" server="localhost"/>

</configuration>



3) Hit save on above config.web file.



Enjoy......



Scott



-----Original Message-----

From: Ken 

Sent: Tuesday, August 22, 2000 9:17 AM

To: ASP+

Subject: [aspx] Session State





Hi,



I have question regarding how to manage session across

web servers. In Chapter1 of "A Preview of ASP+" page36, mention

that  the session content can be serialized out into temporary

SQL Server database table.Also, in the bottom of the page 189

said that "we do have several new options for how to manage user

sessions".  I could not find in which part of the book talking about

how to do it though except Appendic C Session Object providing

its properties and methods. Any one know or done something about it?



Thanks,

Ken



---

Questions about the Session state store.

I read that I have to specify the server name and port number of the 

machine on which state services are running.



In your answer you only have the server attribute, is this because the 

state servieces will use port 42424 as default ?



If I want to save the session into a SQL Server database,

how do I configure which SQL server I want to use as a session store ?



/Fredrik Normen

>In your answer you only have the server attribute, is this because the 

>state servieces will use port 42424 as default ?



I find that the state service will by default listen on port 42424.

And to change the port, I have to modify the registry key for the service: 

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\aspstate\Parameters\Port



But I realy want an answer to this question:

>if I want to save the session into a SQL Server database,

>how do I configure which SQL server I want to use as a session store ?







/Fredrik Normen

We ship a file called "state.sql". Use osql to run it on the server you're

interested in:



	osql -S <server> -U sa -P "" <state.sql



Then restart the SQL service so that the startup stored procedure that

deletes expired sessions can run.



In session state config, set "usesqlserver=true" and "server=<server>".



-----Original Message-----

From: Fredrik Normen 

Sent: Tuesday, August 22, 2000 6:01 PM

To: ASP+

Subject: [aspx] RE: Session State





>In your answer you only have the server attribute, is this because the 

>state servieces will use port 42424 as default ?



I find that the state service will by default listen on port 42424.

And to change the port, I have to modify the registry key for the service: 

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\aspstate\Parameters\Por

t



But I realy want an answer to this question:

>if I want to save the session into a SQL Server database,

>how do I configure which SQL server I want to use as a session store ?







/Fredrik Normen



---

Hi Scott,



I could not find "state.sql" you mentioned about. I have NGWS build

1812.10 and ms sql installed on my machine. Is that file shipped with

another build?





Thanks,

Ken