MS KB list of apps (some by MS, including VS.NET) that have trouble under XP SP 2. Most of them are due to ports needing to be open in the built-in firewall setup that's on by default in SP2.
842242 - Some programs seem to stop working after you install Windows XP Service Pack 2