Asp.net session state server with SQL Server

Question

We're trying to get session state working using the following web.config line:

<sessionState 
    mode="SQLServer" 
    stateConnectionString="tcpip=127.0.0.1:42424" 
    sqlConnectionString="Data Source=dbServer;User ID=stateUser;Password='thepassword'" 
    cookieless="false" 
    timeout="20"/>

On dbServer, we've run the following command to set up the ASPState db:

aspnet_regsql.exe -S localhost-E -ssadd -sstype p

On the webServer, we've started the ASP.Net state service, however, no records show up in tables ASPStateTempApplications or ASPStateTempSessions, and it seems very much like session is still being stored in process.

What's wrong? Should the state service be running on the DB server? Does it get installed with IIS, because it's not available on that machine, despite .net 3.5.1 being installed.

The IIS logs show no hint of failure. What's wrong?

Andomar · Accepted Answer · 2009-11-28 21:06:58Z

5

If there's really quotes around the password, try to remove them:

sqlConnectionString="Data Source=dbServer;User ID=stateUser;Password=thepassword"

And remove the following line, it has no function for SQL session storage:

stateConnectionString="tcpip=127.0.0.1:42424"

And you might as well stop the state service; it's needed for out-of-process session state, not for SQL Server session state.

Also, SQL Server session state requires you to run InstallSqlState.sql on the database, not aspnet_regsql.exe. It should create a new ASPState database.

answered Nov 28, 2009 at 21:06

Andomar

239k55 gold badges387 silver badges412 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

RickNZ Over a year ago

I agree with this answer, except for the last line. Do not try to run InstallSqlState.sql by hand; it is designed to be run by aspnet_regsql.exe; there are even comments at the top of the file that say the same thing.

spender Over a year ago

+1 for not requiring the state service. See comments under marcc's post to learn of my stupidity!

Scott Fraley Over a year ago

@RickNZ Hmmm, I ran it 'by hand' and it's working great. :shrug: (I hadn't even seen the page that told me to run the EXE until after I'd already run/EXECd the script.)

marcc · Accepted Answer · 2009-11-28 21:10:57Z

4

First, you don't need to start the State Service in order to use SQL Server session state. Forget about the ASP.NET State Service.

Are you sure that your site is creating a session variable? Just because you put these changes in your web.config, if you never use session variables, it won't be used.

answered Nov 28, 2009 at 21:10

marcc

12.4k7 gold badges51 silver badges59 bronze badges

1 Comment

spender Over a year ago

Bingo. I was under the impression that session state also is responsible for maintaining forms authentication (I'm running a few servers under a balancer). Session state is indeed being saved (just unused on the pages I was testing). What I actually needed to do was set the same machineKey keys to preserve authentication as users are shunted between nodes of my farm. A severe case of RTFM.

Larry Silverman · Accepted Answer · 2010-08-12 21:50:26Z

0

How about writing a small HttpModule? You could drop it into place for the period of time when you need to transition users to the new codebase. The module could do some work on each page request to check the user's session and decide whether it needs to be abandoned. Perhaps you store an application version string in the user's session when the session is first created and compare the current app version string against that.

answered Aug 12, 2010 at 21:50

Larry Silverman

1,0531 gold badge12 silver badges32 bronze badges

Collectives™ on Stack Overflow

Asp.net session state server with SQL Server

3 Answers 3

3 Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related