User-1690212949 posted
Hello,
I have a web site that is installed on two servers that is connected to a load balancer. I have added the following to the web.config file to enable the ASP.NET session state database on the two servers: (I'm have used the following page as a
guide: https://support.microsoft.com/en-us/kb/323262)
<configuration>
<system.web>
<sessionState mode="SQLServer"
sqlConnectionString="data source= ServerName;
user id=User;password=Password"
cookieless="true"
timeout="20" />
</system.web>
</configuration>
During testing, I'm noticing that I'm getting a new entry in the ASP session state database, which is good, but there is one thing I'm wondering about. When you have the ASP.NET Session State database setup in a load balanced environment, wouldn't
that grant the ability to seamlessly switch to the second server under the load balancer when the first server happens to go down?
