Cannot find a dll for SQL Server from VS 2012

Question

Microsoft Visual Studio

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.

I cannot "see" the referenced DLL even though it is in the proper spot. I can therefore not bind the datasource to the control. What might I be failing to do?

Solution 1

Please see original question and answer here: Could not load file or assembly Microsoft.SqlServer.management.sdk.sfc version 11.0.0.0

---

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

Solution: just go to http://www.microsoft.com/en-us/download/details.aspx?id=35580 and download:

• ENU\x64\SharedManagementObjects.msi for X64 OS or
• ENU\x86\SharedManagementObjects.msi for X86 OS,

then install it, and restart visual studio.

---

Problem:

Microsoft.SqlServer.management.sdk.sfc version 10.0.0.0

Solution: just go to http://www.microsoft.com/en-us/download/details.aspx?id=26728 and download:

• 1033\x64\SharedManagementObjects.msi for X64 OS or
• 1033\x86\SharedManagementObjects.msi for X86 OS,

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

then install it, and restart visual studio.

Solution 2

From here:-

From the error message, we can see there is some missing component in VS 2012 installation. The assembly in question - Microsoft.SqlServer.Manangement.Sdk.Sfc version 11 - is a component DLL for SMO assemblies (even though SFC was originally created for more ambitious SSMS extension), and it is included in SQL Server 2012 Shared Management Objects.

[SQL 2012 Shared Management Objects] has dependency on [SQL System CLR types] component, so you have to install SQL Server System CLR Types first.

[SQL Server 2012 System CLR Types] can be found in the middle of SQL 2012 Feature Pack web page ( http://www.microsoft.com/en-us/download/details.aspx?id=29065 )

Comments

[cfrick]

Reinstalling is some last resort, but not really an answer

[derloopkat]

I have SQL Server 2016 which is not listed there but the version of the file is 11.0.0.0. Unfortunately there is no SharedManagementObjects.msi for SQL Server 2016 and the one for 2012 also didn't work.