You need Team Explorer for VS 2008, and maybe even the update if trying to hit TFS 2010. Have you tried looking under the VIew menu for the Team Explorer Window? If it's not there as an option, you'll definitely need to install one or both of those mentioned..