ASP.NET MVC 5 – Session Handler on Database ( MS SQL ) for Web Application IIS Loading Balancing

ASP.NET MVC 5 – Session Handler on Database ( MS SQL ) for Web Application IIS Loading Balancing

 
   aspnet_regsql.exe -S vmser001 -E -ssadd -sstype p
 
   web.conf
 
   <?xml version="1.0" encoding="utf-8"?>
   <configuration>
 
      … …
 
      <system.web>
 
         … …
 
         <sessionState mode="SQLServer" cookieless="false" sqlCommandTimeout="30"
            allowCustomSqlDatabase="true" useHostingIdentity="true"
            sqlConnectionString="Data Source=vmser001;Initial Catalog=ASPState;Persist Security Info=True;User ID=sa;Password=xxxxxxx" />
 
      </system.web>
 
   </configuration>