The Error Message:
"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."
Event & Solution:
This error happens when you are trying to access SQL Server 2005 from Visual Studio 2008 or 2010 (like adding a connection). So go to this link and download the following stuff
* Microsoft SQL Server System CLR Types
* Microsoft SQL Server 2008 Management Objects
* Microsoft SQL Server 2008 Native Client
Solution References:
http://social.msdn.microsoft.com/Forums/en-US/sqlsetupandupgrade/thread/5a032073-7217-40ae-b953-d00886d71503
http://chiragrdarji.wordpress.com/2009/05/14/could-not-load-file-or-assembly-microsoft-sqlserver-management-sdk-sfc/
http://www.aghausman.net/dotnet/could-not-load-file-or-assembly-microsoftsqlservermanagementsdksfc.html
http://www.microsoft.com/downloads/en/details.aspx?FamilyId=C6C3E9EF-BA29-4A43-8D69-A2BED18FE73C&displaylang=en#filelist
