ASP+, SQL, and Config.web?
Does anyone have and example of how to set up
the SQL Session Service, the config.web file, and
ASP+ in order to let SQL handle the sessions?
I set up a Win2000 server, installed the pre-beta
software, and IE5.5. I cannot find the SQL session
service anywhere...should it be there?
I searched through the news groups, and the web,
but i have yet to find a good resource for this topic.
Any help is greatly appreciated!! Thanks in advance!
Mike Gibson
mgibson@usbid.com
# 1 Re: ASP+, SQL, and Config.web?
I've seen this post elsewhere (haven't trid it yet, tho)
look for 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>".
Hope this helps.
MCA
Michael Gibson <mgibson1@cfl.rr.com> wrote in message
news:39a3c5ee@news.dev-archive.com...
> Does anyone have and example of how to set up
> the SQL Session Service, the config.web file, and
> ASP+ in order to let SQL handle the sessions?
>
> I set up a Win2000 server, installed the pre-beta
> software, and IE5.5. I cannot find the SQL session
> service anywhere...should it be there?
>
> I searched through the news groups, and the web,
> but i have yet to find a good resource for this topic.
>
> Any help is greatly appreciated!! Thanks in advance!
>
> Mike Gibson
> mgibson@usbid.com
>
>
# 2 Re: ASP+, SQL, and Config.web?
Thanks for the help!
I do have another question though....I can't seem to find
the "state.sql" file anywhere on my box.
Where can I find it, or can anyone send it to me?
Thanks in advance for the help!
Mike Gibson
mgibson@usbid.com
"Mike Amundsen" <news@amundsen.com> wrote in message
news:39a46d6f$1@news.dev-archive.com...
> I've seen this post elsewhere (haven't trid it yet, tho)
>
>
> look for 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>".
>
> Hope this helps.
>
> MCA
>
> Michael Gibson <mgibson1@cfl.rr.com> wrote in message
> news:39a3c5ee@news.dev-archive.com...
> > Does anyone have and example of how to set up
> > the SQL Session Service, the config.web file, and
> > ASP+ in order to let SQL handle the sessions?
> >
> > I set up a Win2000 server, installed the pre-beta
> > software, and IE5.5. I cannot find the SQL session
> > service anywhere...should it be there?
> >
> > I searched through the news groups, and the web,
> > but i have yet to find a good resource for this topic.
> >
> > Any help is greatly appreciated!! Thanks in advance!
> >
> > Mike Gibson
> > mgibson@usbid.com
> >
> >
>
>