Installing Balanced Data Distributor on SQL Server 2008 R2 SP1

Edit: This post refers to an older version of the BDD installer. As per JasonH’s comment below, Microsoft has released a new installation package which should hopefully fix the installation bug. It can be found here: http://www.microsoft.com/en-us/download/details.aspx?id=4123

Original post:

Microsoft’s Balanced Data Distributor does not install on top of SQL Server 2008 R2 SP1. It installs fine without SP1 but otherwise comes up with the error:

“The installation is not successful. Check the following prerequisites: 1. Either Integration Services or BIDS has to be installed. 2. The version of these components has to be either SQL Server 2008 SP2 (or future SPs) or SQL Server 2008 R2 (or future SPs)”

In my case all the pre-requisites were met. As per this thread I examined the registry keys it was checking for the version numbers using Process Monitor. I then modified the keys to pretend I was running SQL Server 2008 R2 RTM, ran the BDD installer again (successfully) and modified the keys back to their original values.

Warning: This is not best practice advice! If you do the same as I did and your production system is rendered unusable, this will be entirely your fault. I did this on a throwaway development environment to save time uninstalling SP1 and reinstalling it.

The keys I altered were all in the following path:

  • HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\100\

The specific keys and the values I set them to were:

  • DTS\Setup\SP = 0
  • DTS\Setup\Version = 10.50.1600.1
  • BIDS\Setup\SP = 0
  • BIDS\Setup\Version = 10.50.1600.1

When setting up a production system, please ensure you apply the BDD installation before SP1. Don’t use this technique, which will probably render your environment unsupportable!

Advertisements
This entry was posted in Computers and Internet, SQL Server. Bookmark the permalink.

12 Responses to Installing Balanced Data Distributor on SQL Server 2008 R2 SP1

  1. Sean Hawkes says:

    Thank you for this. I still wish MS would just release an update to this transform that installed properly, but thats a seperate issue. Again thank you.

  2. Devin Knight says:

    Thanks for saving me a ton of time! Very frustrating to try and debug.

  3. Pingback: Balanced Data Distributor | sqlzapper

  4. Pingback: Balanced Data Distributor | SQLZapper

  5. Keith Washer says:

    Glad you all ran into the problem before I did :/ . Fixing up my new dev instance now…..

  6. David Stein says:

    Thanks for this blog post. Unfortunately, I can’t use BDD because of this issue as I’m unwilling to edit the registry of production servers.

    • Josh says:

      David, it’s also pretty easy to uninstall the service pack, install BDD then re-install the service pack. As Sean mentioned, I wish MS would just fix the BDD MSI.

  7. JasonH says:

    Microsoft issued a fix to the BDD installer here http://www.microsoft.com/en-us/download/details.aspx?id=4123

  8. Miljan says:

    Hi guys,
    I am having exactly the same error with 2012 version of the component. It says: “Either Integration Services or SSDT has to be installed…”. Is there any similar fix for 2012 (I was not able to find in on google nor microsoft forums).

    Thanks

  9. Belinda Tinsley says:

    MilJan, did you find a resolution? I am having the same issue with 2012…….

    • Miljan says:

      Yes, install Integration Services to your computer first – after that BDD installs normally. I didn’t try to uninstall Integration Services after, but you can try and let us know 🙂

  10. Belinda Tinsley says:

    Miljan, I wish it was that simple. I already have that installed.

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