Making all Apps on a Server Use SQL Session Manager

Question

Is there any way to make all the applications on a server use SQL Server as the session manager?

The reason is that we have a server with hundreds of applications and we want to start load balancing the server but it will be a big hassle to configure each individual application to use SQL Server as the session manager. It will also prevent from human error when deploying an application if the user forgets to set it up as SQL Session Manager.

Answer 1

You can specifiy the SQLServer session manager in \Microsoft.NET\Framework\v2.0.50727\CONFIG\web.config