TF31002 error in Visual Studio 2008 Business Intelligence Development Studio

bidssql-server-2008ssmstfs

I'm trying to get my SQL 2008 client tools talking to TFS 2010.

The address http://tfs-server:8080/tfs works fine in VS2010, but both SSMS (SQL Server Management Studio 2008) and BIDS (Business Intelligence Development Studio 2008) both give me this error:

TF31002: Unable to connect to this Team Foundation Server: <snip>
Possible reasons for failure include:
    - The Team Foundation Server name, port number or protocol is incorrect.
    - The Team Foundation Server is offline.
    - Password is expired or incorrect.

I spent a day following the 4-step and 7-step installation sequences and tried multiple variants of the TFS server's URL, but no luck. What would you suggest?

Best Answer

Assuming you have correctly installed the prereqs for this scenario, in the following order.
Note: Even if Team Explorer 2008 is already installed, step 2 and THEN step 3 must be completed.
ie
1. Install Team Explorer 2008 component (either from TFS 2008 media or MS download)
2. Install Visual Studio 2008 Service Pack 1 (MS download)
3. Install Team Explorer 2008 forward compatibility patch for TFS 2010 (MS download)

You will need to do the following...
1. Click tools > Connect to Team Foundation Server...
2. In the "Connect to Team Project" dialog, click on the Servers button.
3. In the "Add/Remove Team Foundation Server" dialog, click on the Add.. button.
4. In the "Add Team Foundation Server" dialog, enter the URL
http://tfs-server:8080/tfs/ProjectCollectionName
5. ok, ok, ok
6. you should now be able to connect to Team Projects.

Note the difference with connecting in VS 2010, the dialog to enter the URL seems to require the fully qualified http address, as opposed to just entering the servername.