Unable to add data connection to SQL server

Question

Hello, I am a novice user of Visual Studio 2010 and SQL server 2012. 

I wanted to create a new Winform application and when I tried to create a new connection to SQL server, I seen an error message which stopped me. However connection to database was successful.

Unable to add data connection. Could not load file or assembly Microsoft.SqlServer.Management.Sdk.Sfc, Version=10.0.0.0 error Culture= neutral./......... or one of its dependencies.....

Please help, how to fix this, because I'm dead in the water on accessing the database. 

Thanks

Answer 1

Hi Piyush Vishvas,

Welcome to the MSDN forum.

Based on the error message you provided above, it seems that your system can’t find the SQL Server SDK. And I think you should consult SQL server experts on the SQL Server Setup forum.

For your issue, based on this blog ,your issue is the same because you missed these three products because you installed SQL 2012.

So please install the following products(PS: Sql 2008 is embeded in VS2010)

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

If these steps cannot help you on your issue. Please post your question to the specific forum for better support.

If you have any updates, please feel free to let me know.

Best regards,

---

Barry Wang [MSFT]
MSDN Community Support | Feedback to us