无法加载文件或程序集 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

问题描述

我已经安装了 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 server 2014) 当程序集 Microsoft.SqlServer.management.sdk.sfc version 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 并下载:

• ENUx64SharedManagementObjects.msi 适用于 X64 操作系统或
• ENUx86SharedManagementObjects.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)当 Visual Studio 未找到程序集 Microsoft.SqlServer.management.sdk.sfc 版本 11.0.0.0 时会发生此问题.

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 并下载:

• ENUx64SharedManagementObjects.msi 适用于 X64 操作系统或
• ENUx86SharedManagementObjects.msi 适用于 X86 操作系统，

• ENUx64SharedManagementObjects.msi for X64 OS or
• ENUx86SharedManagementObjects.msi for X86 OS,

然后安装它，并重新启动visual studio.<小时>问题:(Sql server 2008)Visual Studio 未找到程序集Microsoft.SqlServer.management.sdk.sfc version 10.0.0.0 时会发生此问题.

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 并下载:

• 1033x64SharedManagementObjects.msi 适用于 X64 操作系统或
• 1033x86SharedManagementObjects.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 后遇到了类似的问题.Visual Studio 未找到程序集 Microsoft.SqlServer.ConnectionInfo, Version=12.0.0.0.问题是 Visual C++ Redistributable Packages for 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 Studio 版本的 Visual C++ Redistributable Packages for Visual Studio 20XX.

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

这篇关于无法加载文件或程序集 Microsoft.SqlServer.management.sdk.sfc 版本 11.0.0.0的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！