How to do sqlserver mode session

Question

User1120488935 posted

Hi I want store my session values in sqlserver

what is procedure?

Answer 1

User541108374 posted

Hi,

HOW TO: Configure SQL Server to Store ASP.NET Session State

Another way would be to follow these procedures: Session-State Modes.

Grz, Kris. 

Answer 2

User-1062158585 posted

1. execute below path sqlquery

\\WINDOWS\Microsoft.NET\Framework\v2.0.50727/InstallSqlState.sql

aspnet_regsql.exe  //for install commnad prompt

if it is .net 4.0  use  compressionEnabled="true"

<sessionState
  mode="SQLServer"

  
   sqlConnectionString="Data Source=.;Initial Catalog=mural;Integrated Security=True;"
   cookieless="false"
   timeout="1"
  />

If you are using trusted connections to connect to your server,
you must change ownership of the state database to sa after creation. In Query Analyzer run use ASPState

exec sp_changedbowner 'sa','true'

goto security-> check u r user name has public and  local admin check boxes has checked or not

aspnet_regsql -ssadd -S .sqlexpress -E -sstype p                 /*integrated security turned on */