How to maintain Session in Load Balancer (SQLSERVER session state)

See more:

C#

ASP.NET

I implemented SQLSERVER session state for Load Balancer. Everything is ok now.

But the only problem im facing is Connection string getting null sometimes. I tried to change my Sqlserver session parameters but none of them working.

That is my staticConnectionString parameter(Declared in Entity as static string property) which used to have connection string value is getting NULL. Only with Load Balancer im facing this issue. Any body please Help.

Value cannot be null.
Parameter name: connectionString

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.ArgumentNullException: Value cannot be null.
Parameter name: connectionString

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:


[ArgumentNullException: Value cannot be null.
Parameter name: connectionString]
RLLMSBusinessLayer.LoginBL.GetCompanyInfoBL() in C:\inetpub\wwwroot\RediLearning2012\RediLearningLMS2012\RLLMSBusinessLayer\LoginBL.cs:35
RLLMSWEB.Reporting.QuizReport.Page_PreInit(Object sender, EventArgs e) in C:\inetpub\wwwroot\RediLearning2012\RediLearningLMS2012\RLLMSWEB\Reporting\QuizReport.aspx.cs:43
System.Web.UI.Page.PerformPreInit() +49
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1844