We use SQL session state on our hosted environment for OnTime 2007, and we wanted to see what sessions were currently active, and how many sessions were active for a given application. Our first glance at the table structures provided didn't yield any immediate clues. There is an ASPStateTempApplications table that looks like this: In this ...

The following knowledge based article from Microsoft gives you detailed instructions on how to make the current SQL 2005/Express instance available for remote connections through the local network.   How to configure SQL server 2005 to allow remote connections: http://support.microsoft.com/kb/914277