How to configure SQL Server to manage ASP.NET sessions

Question

I need to know how to configure the .config to manage Session state in SQL Server

Sanchitos · Accepted Answer · 2011-02-02 22:52:57Z

6

First you need to create a Session database. In order to do this:

Look for the aspnet_regsql.exe
Run this command aspnet_regsql.exe -S [ServerName] -E -ssadd -sstype p

Where ServerName is your server name.

This will create this database ASPState

Now the configuration on the web.config

Add this sentence over

<sessionState allowCustomSqlDatabase="false" mode="SQLServer" sqlCommandTimeout="7200" sqlConnectionString="Server=SERVERNAME;User ID=User;Password=Password;" timeout="120" />

sqlCommandTimeout="7200" = 2hours and timeout="120" = 2hours

If you need more options regarding aspnet_regsql you can take a look HERE

answered Feb 2, 2011 at 22:52

Sanchitos

8,5996 gold badges54 silver badges53 bronze badges

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

Comments

lukiffer · Accepted Answer · 2011-02-02 22:47:40Z

2

<configuration>
  <sessionstate 
      mode="stateserver"
      cookieless="false" 
      timeout="20" 
      sqlconnectionstring="data source=127.0.0.1;user id=<user id>;password=<password>"
      server="127.0.0.1" 
      port="42424" 
  />
</configuration>

Additional options here: http://msdn.microsoft.com/en-us/library/ms972429.aspx

answered Feb 2, 2011 at 22:47

lukiffer

11.4k9 gold badges48 silver badges71 bronze badges

1 Comment

NullReference Over a year ago

I think that should be mode="SQLServer"?

Collectives™ on Stack Overflow

How to configure SQL Server to manage ASP.NET sessions

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related