Using SQL Server for session states

[Jonathan Amend]

I tried configuring my web application to use SQL Server for session states
and I installed the SQL script provided by .NET to set up the databases and
whatever goes with it but now my web application returns the following
error:

Unable to serialize the session state. Please note that non-serializable
objects or MarshalByRef objects are not permitted when session state mode is
'StateServer' or 'SQLServer'.

 

[bruce barker]

the message is pretty clear. as the object must be serialized to a binary
field in sqlserver, it must be a serializable object. only inproc sessions
support non-serialiable objects.

-- bruce (sqlwork)