TroubleShooting Connections

The SQL Server Protocols Team has a blog and a great 2 part post on troubleshooting connections.

Part 1

Part 2

There is other good stuff on there and I'm sure there will be more.