我已经安装了MS SQL Server 2008 R2中，当我尝试更新从下EDMX文件数据库，我面临着误差模型。

I have installed MS SQL Server 2008 R2 and when I try to update model from database under EDMX file I am facing that error.

无法加载文件或程序Microsoft.SqlServer.management.sdk.sfc   11.0.0.0版本

Could not load file or assembly Microsoft.SqlServer.management.sdk.sfc version 11.0.0.0

我试图安装Microsoft SQL Server 2008 R2共享管理对象从这里，但没有喜悦。

I have tried to install Microsoft SQL Server 2008 R2 Shared Management Objects from here but no joy.

推荐答案

问题：（SQL服务器26年）发生此问题时，装配 Microsoft.SqlServer.management.sdk。 SFC版12.0.0.0 不是由Visual Studio中。

Problem: (Sql server 2014) This issue happens when assembly Microsoft.SqlServer.management.sdk.sfc version 12.0.0.0 not found by visual studio.

解决方法：只是去http://www.microsoft.com/en-us/download/details.aspx?id=42295和下载：

ENU 64 SharedManagementObjects.msi 的X64操作系统或 ENU 86 SharedManagementObjects.msi 对于x86操作系统， ENUx64SharedManagementObjects.msi for X64 OS or ENUx86SharedManagementObjects.msi for X86 OS,

然后再进行安装，并重新启动Visual Studio。

then install it, and restart visual studio.

PS：您可能需要安装 DB2OLEDBV5_x64.msi 或 DB2OLEDBV5_x86.msi 太。 问题：（SQL SERVER 2012）此问题发生在组装 Microsoft.SqlServer.management.sdk.sfc版本11.0.0.0 不是由Visual Studio发现

PS: You may need install DB2OLEDBV5_x64.msi or DB2OLEDBV5_x86.msi too. Problem: (Sql server 2012) This issue happens when assembly Microsoft.SqlServer.management.sdk.sfc version 11.0.0.0 not found by visual studio.

解决方法：只是去http://www.microsoft.com/en-us/download/details.aspx?id=35580和下载：

ENU 64 SharedManagementObjects.msi 的X64操作系统或 ENU 86 SharedManagementObjects.msi 对于x86操作系统， ENUx64SharedManagementObjects.msi for X64 OS or ENUx86SharedManagementObjects.msi for X86 OS,

然后再进行安装，并重新启动Visual Studio。 问题：（SQL Server 2008中）发生此问题时，装配 Microsoft.SqlServer.management.sdk.sfc版本10.0.0.0 不是由Visual Studio发现

then install it, and restart visual studio. Problem: (Sql server 2008) This issue happens when assembly Microsoft.SqlServer.management.sdk.sfc version 10.0.0.0 not found by visual studio.

解决方法：只是去http://www.microsoft.com/en-us/download/details.aspx?id=26728和下载：

1033 64 SharedManagementObjects.msi 的X64操作系统或 1033 86 SharedManagementObjects.msi 对于x86操作系统， 1033x64SharedManagementObjects.msi for X64 OS or 1033x86SharedManagementObjects.msi for X86 OS,

（在大多数情况下，下载此是更好的http://go.microsoft.com/fwlink/?LinkId=123708&clcid=0x409)

(In most cases downloading this is better http://go.microsoft.com/fwlink/?LinkId=123708&clcid=0x409)

然后再进行安装，并重新启动Visual Studio。 问题：我最近安装的 SharedManagementObjects 的后得到了类似的问题。组装 Microsoft.SqlServer.ConnectionInfo，版本= 12.0.0.0 不是由Visual Studio中。问题是的Visual C ++可再发行的Visual Studio包是尚未安装。

then install it, and restart visual studio. Problem: I recently got similar problem after installing SharedManagementObjects. assembly Microsoft.SqlServer.ConnectionInfo, Version=12.0.0.0 not found by visual studio. The problem was Visual C++ Redistributable Packages for Visual Studio was not installed yet.

解决方法：的Visual Studio 2013只去http://www.microsoft.com/en-us/download/details.aspx?id=40784和下载：

Solution: for Visual Studio 2013 just go to http://www.microsoft.com/en-us/download/details.aspx?id=40784 and download:

vcredist_x64.exe 的X64操作系统或 vcredist_x86.exe 对于x86操作系统， vcredist_x64.exe for X64 OS or vcredist_x86.exe for X86 OS,

然后再进行安装，并重新启动Visual Studio。

then install it, and restart visual studio.

PS：你可以找到的的Visual C ++可再发行的Visual Studio 20XX包的为Visual Studio很容易通过使用Google其他版本

PS: You can find Visual C++ Redistributable Packages for Visual Studio 20XX for other versions of Visual Studio easily by googling it.