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

  • Question

  • User718865757 posted

    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.
    Tuesday, June 24, 2014 5:47 AM


  • User-734925760 posted


    According to your description and the error message, I think you should check the session configuring. We must make sure it's correct. There several Session-State Modes, so please refer to check.

    For more information about the Session-State Modes, please refer to the link below:

    Hope it's useful for you.

    Best Regards,

    Michelle Ge

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Wednesday, June 25, 2014 2:23 AM