If you receive an error message similar to "Unable to add data connection. Could not load file or assembly 'Microsoft.SqlServer.Management.Sdk.Sfc, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified" and you are looking for a solution to the same, then you have come to the right place.
The following helped me solve this problem:
Install the following from the Microsoft SQL Server 2008 Feature Pack, August 2008 site:
1) Microsoft SQL Server Management Objects, and
2) Do a repair install on Microsoft SQL Server System CLR Types
This should solve the problem you are having.
Happy debugging!
