Failed to 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.

Somehow, adding a database connection to VS will report this error, and the workaround is to reinstall the next two SQL Server components: Sharedmanagementobjects.msi and Sqlsysclrtypes.msi.

Different versions of VS corresponding SQL Server versions may not be the same, depending on the version number in the error prompt.

Microsoft Download Center: https://www.microsoft.com/zh-cn/search/result.aspx?q=Microsoft%C2%AE%20SQL%20Server%C2%AE%20%E5%8A%9F% E8%83%bd%e5%8c%85&form=dlc

In my error message, the corresponding SQL Server version is 11, which is SQL Server 2012,:https://www.microsoft.com/zh-cn/download/details.aspx?id=43339

Note that there are two versions of x86 and x64, because VS has only the x86 version, so you need to download the component that installs the corresponding x86 version.

Source: http://stackoverflow.com/questions/16906686/ Could-not-load-file-or-assembly-microsoft-sqlserver-management-sdk-sfc-version-1

Failed to 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.