ASP. Session state SQL Server mode and settings

Thursday, December 5,

Asp. NET to save session state there are three modes: in-process. SQL Server.

Advantages of SQL Server mode:

State data is saved even if the Web application is restarted
Multiple Web servers can share state data
Save Memory

Set up:

In Web. config, use mode= "SQL Server", for example:

<configuration>
<system.web>
<sessionstate mode= "SQL Server"
sqlconnectionstring= "Integrated Security=sspi;data
source=samplesqlserver; "/>
</system.web>
</configuration>

Of course, this alone is not enough, and you need to run Aspnet_regsql.exe and use the wizard to
However, not enough, you must execute the InstallSqlState.sql script on the working SQL database!
All right! The state data is saved to the specified database.
If you view the database, the ASPState database is automatically generated and there is no data. Why? Originally, ASPState Only stored procedures, the data is saved in tempdb!