none
Data connection RRS feed

  • Question

  • Trying to establish a data connection in visual studio 2013 with a local sql server 2014 database. The test works, after you hit OK, you get the following error message.

    

    Could not load file or assembly 'Microsoft.SqlServer.Management.Sdk.Sfc, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.

    Thanks

    Thursday, May 1, 2014 6:06 PM

Answers

  • Hello,

    >>Could not load file or assembly 'Microsoft.SqlServer.Management.Sdk.Sfc, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.

    For this error, it seems to be that there is some missing component in VS installation as described here:

    http://sqlbeyond.blogspot.com/2012/08/vs-2012-error-could-not-load-file-or.html

    The solution is to install them follow steps in the link.

    By the way, 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.

    Regards.


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.

    Friday, May 2, 2014 6:54 AM
    Moderator