Question: I am just working on setting up the connection to TFS 2010. However when I enter the TFS 2010 URL (http://servername:8080/tfs/Collection) it gives me the following error.
I have Visual Studio 2008 with SP1 so I am not sure what the issue would be. Any help would be appreciated.
Answer:
To connect Visual Studio 2008 with TFS 2010, you need to install Visual Studio Team System 2008 Service Pack 1 Forward Compatibility Update for Team Foundation Server 2010.
In VS2010 when the test are executed, it always uses a test settings configuration file. There are lot of settings you can do. We are here interested in “How to run tests in 64 bit process on 64 bit machine?”.
Step 1: First we need to identify the test settings file that the test project (Team build) uses.
Step 2: Open the test settings (example: LocalTestRun.testsettings) file and highlight/choose “Host”. See the image below
Step 3: Choose “Run Tests in 64 bit process on 64 bit machine” from the “Run tests in 32 bit or 64 bit process” dropdown. See the image above.
Step 4: If you like to change the “Test Timeouts” to avoid long running builds (25hrs +), highlight/choose the “Test Timeouts” section. See the image below
Step 5: Check the “Abort a test run if its total execution time exceeds” and/or “Mark an individual test as failed if its execution time exceeds” option(s) and type in the desired timeout in minutes/hours.
Step 6: Click apply to save changes and run the tests.
This configuration change might speed up the tests and the test process (QTAgent.exe) might be able to use more than 4GB RAM. So this would avoid any memory limitation on the test run and also the test would timeout the if the tests takes more than the specified timeout.
Hope this helps.
Issue: While opening the spreadsheet from Visual Studio 2010, you might get the following error.
Resolution
Could you check the followings?
1. Open the Excel Options (Office button on top left -> Excel options button)
2. Do you see the Team Foundation Add-in in the list (as shown below) ? Also does it point to the 10.0 folder
3. If its disabled, scroll the list to the “Disabled Application Add-ins” and try to enable it.
4. You can also load the Add-in (if its missing) by clicking on the COM Add-ins option in the drop down shown in the image above. Click the Go button
5. Verify that the Add-in shows up – If not add it.
And also make sure that the .net programmability support is installed.
How to check .Net programmability support is installed?
Go to “Start” – “Control Panel” – then double click on “Add or Remove Programs”
![clip_image002[5]](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi29bK4KKX0Zb0XRLlMCST4m_IGi3i_t_grsV6TsLDOfvgK2zpuruvpdB366q-oP1j8VxWyPOwfXNue25PER-TQ-NqZvYPtlc71ef8aK3F54-ApxMSG9TefjVfLhDOAmSCua1VVo91hRBOF/s1600-h/clip_image002%25255B5%25255D%25255B3%25255D.jpg "clip_image002[5]")
Select “Microsoft Office Professional Plus 2007” and click on the “Change” button
![clip_image004[5]](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgcDpRvdYr3OBHue_Gk6bFGCM_nWOsR4wfwTrl3odUvIrCrx8-OnwiohUj2YPy8i1wCKlfoyxZVjaTSLfQN38PoKuDL2cDtSjhHUNErKdidBgjb5KAwF52DvZNthX1Xi3WEzGS2TPpDot07/s1600-h/clip_image004%25255B5%25255D%25255B3%25255D.jpg "clip_image004[5]")
Select “Add or Remove Features” and click on the “Continue” button
Select the “.NET Programmability Support” drop down arrow, choose “Run from My Computer” 
Verify the useDefaultCredentials is true on the profiles.xml. If the value is false (or not exists), change it to true (or add the property), so that whenever the network username/pwd changes, the profile.xml no need to be changed/updated.
<property name="useDefaultCredentials" type="boolean">true</property>
The profiles.xml file can be found at
<TEE Cache folder>\Profiles\profiles.xml
Your TEE cache location can be found at
The <property name="useDefaultCredentials" type="boolean">true</property> can be found at workspaces.xml at <TEE Cache folder>\workspaces
