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!
Josh's Space 
12 replies on “Installing Balanced Data Distributor on SQL Server 2008 R2 SP1”
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.
Thanks for saving me a ton of time! Very frustrating to try and debug.
[…] to joshgallagher.info for the […]
[…] to joshgallagher.info for the fix. This entry was posted in SSIS by SQLZapper. Bookmark the […]
Glad you all ran into the problem before I did
. Fixing up my new dev instance now…..
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.
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.
Microsoft issued a fix to the BDD installer here http://www.microsoft.com/en-us/download/details.aspx?id=4123
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
MilJan, did you find a resolution? I am having the same issue with 2012…….
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 🙂
Miljan, I wish it was that simple. I already have that installed.