The System Cannot Find the File Specified

Question

Hi Guys,

I am unable to add Database Connection in Visual Studio 2010 and facing following error when I click "OK". Test Connection get successful but when I press "OK" after successful test, it gives following error.

I'm using SQL Server 2005 and Visual Studio 2010

Answer 1

Thank You Guys - I have consulted following post and found the solution:

Could not load file or assembly Microsoft.SqlServer.Management.Sdk.Sfc, Version=10.0.0.0

Download & Install:

Microsoft SQL Server System CLR Types - http://go.microsoft.com/fwlink/?LinkId=123721&clcid=0x409

Microsoft SQL Server 2008 Management Objects - http://go.microsoft.com/fwlink/?LinkId=123708&clcid=0x409

Microsoft SQL Server 2008 Native Client - http://go.microsoft.com/fwlink/?LinkId=123717&clcid=0x409