As I'm currently configuring multiple load balanced web servers at work I had to move ASP.Net's session state to SQL Server. This is not without problems. SQL Server SP3 breaks ASP.Net's session state, permissions are problematic and you have to make sure Application Paths are identical on the web servers.

So I documented the procedure, and the caveats here.