Using TFS 2010 With BIDS 2008

Well, my good mates at Microsoft have managed to leave us developers in a bit of a lurch, AGAIN.

The situation this time is that Visual Studio 2010 does not have support for SQL Server 2008 R2 in there yet, so we are forced to use BI Development Studio (BIDS) 2008 with SQL 2008 R2.

What makes this painful is that VS2010 should support everything, but now we are forced to work in 2 different environments. Additionally, BIDS 2008 will not work with Team Foundation Server 2010 out of the box.

In an even funnier situation, we have to use VS2010 to version control the SQL 2008 R2 databases, as this cannot be done in BIDS.

I hate to say this, but Microsoft seems to have dropped the developer ball since Bill left. Sad smile

Anyways, there is a solution, but not a simple one sadly. The post here describes how to get this working.

I already had BIDS2008 installed with VS2010 side-by-side. The steps I followed to get this working were:

  1. Install VS 2008 Team explorer (download here)
  2. Install VS 2008 SP1 (download here)
  3. Install VS2008 SP1 Forward compatibility Update For TFS2010 (download here)
  4. Update registry entry as per this blog (Medo Blog) HKEY_CURRENT_USER\Software\Microsoft\VisualStudio\9.0\TeamFoundation\Servers with the URL to your Project Collection in TFS so that BIDS can connect to TFS properly. URL looks like http://TFSServer:8080/tfs/collection (assuming default install paths, virtual directories, etc.). Just add a new string type (REG_SZ) with name = tfsservername and value = URL (as above).

Once that is done, open BIDS and connect to TFS, the server should already be there when you go to connect in Team explorer 2008.

VS2010 connects natively (possibly dependent on VS version) to TFS so we can version control the databases, but it sure would be a lot nicer to just have all this stuff work OOTB like it should, re-align SQL and VS releases if you need to Microsoft, I’d be happier to wait for an aligned release than deal with this mess.

Happy BI Development Smile

Advertisements
    • Cliff Cotterill
    • January 5th, 2011

    I tried your solution and when in Visual Studio 2008 I attempt to ‘Add Project to Source Control’ there is a Microsoft Visual Studio Error:

    Value cannot be null.
    parameter name: name

    The same error occurs when File->Open Team Project.

    I tried several registry entries and none of them resolved the error.

    [HKEY_CURRENT_USER\Software\Microsoft\VisualStudio\9.0\TeamFoundation\Servers]
    @=”http://servername:8080/tfs/DefaultCollection”
    “tfsservername”=”http://servername:8080/tfs/DefaultCollection”
    “servername”=”http://servername:8080/tfs/DefaultCollection”
    “name”=”http://servername:8080/tfs/DefaultCollection”

    • Cliff, if your internal server for TFS was named TFS and you wanted to connect to the default collection, it would be TFS=http://TFS:8080/tfs/DefaultCollection, change to another collection if you want to connect to a different project collection.

        • Phil
        • January 30th, 2012

        Thanks! – adding DefaultCollection to the end made everything work

    • Lee
    • May 27th, 2011

    Great post! this helped me connect my BIDS 2008 R2 to TFS 2010. Thanks

      • KateT
      • January 20th, 2012

      I am hitting a problem with BIDS 2008 R2 to TFS 2010. I’m getting same error as a gentleman below, but yours worked fine?

      When trying to install the Forward patch I get a notice that:

      None of the products that are addressed by this software update are installed on this computer. Click Cancel to exit setup.

    • Scott Paulsen
    • July 29th, 2011

    Thanks alot for the information! This worked perfect!

  1. @ Cliff: After establishing the connection between VS2008 and TFS2010, you’ll find that you can neither add a new project nor delete an existing one. You’ll have to use VS 2010 or get a TFS administrator to do that. I’ve hit the same roadblock, had to use the work-around and been told it will be fixed with the release of SQL Denali.

    • Dean
    • November 3rd, 2011

    Thanks this worked for me.

  2. Worked for me. Thanks.

  3. Didn’t work for me as I only have the SQL server BIDS not VS2008
    When trying to install the Forward patch:

    None of the products that are addressed by this software update are installed on this computer. Click Cancel to exit setup.

      • KateT
      • January 20th, 2012

      Yes, I am in the same boat, wondered if you ever found a work around.

      • Joao
      • October 25th, 2013

      Same here but with TFS 2012… any solution ?

    • Roy Jones
    • January 27th, 2012

    I don’t see this path in my registry HKEY_CURRENT_USER\Software\Microsoft\VisualStudio\9.0\TeamFoundation\

    There is no TeamFoundation folder in this directory installing the 3 programs.

    • Roy,

      From experience, you need to fire up VS2008 (BIDS) after installing the stuff and this folder gets created. Then shut-down VS and make the registry change.

      Also, occasionally you get and error in VS2008 BIDS saying Team Explorer is busy. In this case, need to remove the “/” from the end of the TFS URL you added in the registry.

      …Derek

  4. Yep seems we had to download these:

    Run this First:
    VS90sp1-KB945140-ENU.exe
    http://www.microsoft.com/download/en/details.aspx?id=10986

    Then

    VS90SP1-KB974558-x86.exe
    http://www.microsoft.com/download/en/details.aspx?id=10834

    And all works as expected

    Sorry for delay

    • Albenino
    • March 16th, 2012

    If anyone is encountering the issue, which KateT noted above, all you have to do is re-run VS90sp1-KB945140-ENU.exe again. After that completes again, run VS90SP1-KB974558-x86.exe and now it should find the necessary VS2008 components and install just fine…
    Cheers

    • Dana
    • March 20th, 2012

    Derek Miller :
    Cliff, if your internal server for TFS was named TFS and you wanted to connect to the default collection, it would be TFS=http://TFS:8080/tfs/DefaultCollection, change to another collection if you want to connect to a different project collection.

    Worked like a charm! Thanks Derek

    • venkat Golla
    • March 22nd, 2012

    Great post! this helped me connect my BIDS 2008 R2 to TFS 2010. All links put together.
    Thanks

    • Ron Smith
    • April 6th, 2012

    Thank you for this. I am doing a fresh restore of all my software and I couldn’t remember how to get this working.

    • Sam
    • July 25th, 2012

    God bless you! This worked perfectly.
    The only [good] exception is, the TeamFoundation Registry node didn’t exist under 9.0, but I was able to simply connect to the TFS instance by going to:
    Tools->Connect to Team Foundation Server…

    • Jude The Law
    • September 5th, 2012

    The new forward patch is released for Team Foundation 2012. It works much better (with TFSpreview for example) you dont need the Registry hacks

    • David (OH)
    • October 11th, 2012

    Hi – I used this a while back and successfully integrated the BIDS int to TFS 2010. However now my computer name has changed. While I was able to update my VS 2010 mapping by using tf workspaces /updateComputerName /s:http://tfsservername, it did not apply it to VS 2008, and when trying to do the same command in “c:\program files\microsft visual studio 9.0\common7\ide” I get an error about workspace not being present. Perhaps because I have to use a normal command prompt instead of a visual studio one here – no vc program is present in BIDS 2008 install. Anhy help on how to fix this would be greatly appreciated.

    • nojetlag
    • December 1st, 2012

    MSFT BI Tools got such a big big mess, unbelievable. I like Apple, they screw up on maps and the responsible manager gets fired, at MSFT they can go on and on. VS2012 and BI development is still the same mess.

    • T Peavey
    • January 9th, 2013

    Thank you, it worked after following the steps you outlined.

    • troop
    • November 20th, 2013

    Thank you for this instruction, it was very helpfull. cheers

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: