Session State works for InProc, but not for SQLServer mode

Discussion in 'ASP .Net' started by Jamie Schatte, Jul 21, 2006.

  1. We have two ASP.NET 2.0 websites, both running on the same production web
    server. One website uses SQLServer mode for session state with no problems.
    However, although the other website works great when we use InProc session
    state, when we change to SQLServer mode for this website, it does not
    work--session variables are not retained page to page (and no errors are
    raised indicating a problem). The second website is using the same
    connection string to the SQL Server as the first. Both websites use WebForms
    authentication, both use the FormsAuthentication.RedirectFromLoginPage as
    recommended after a user is successfully authenticated.

    Any ideas? Thanks in advance!

    Jamie Schatte
    ProCare Rx
    Jamie Schatte, Jul 21, 2006
    1. Advertisements

  2. This is now fixed...upon additional debugging it was discovered that a
    non-serializable type was being stored in session state, which is a no-no
    when using StateServer or SQLServer session state mode. Jamie
    Jamie Schatte, Jul 21, 2006
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.