Could not load file or assembly Microsoft SqlServer management sdk sfc version 11 0 0 0

Question

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      Could not load file or assembly Microsoft SqlServer management sdk sfc   version 11 0 0 0   I  have tried to install Microsoft SQL Server 2008 R2 Shared Management Objects from here but no joy

User · Answer

For SQL Server 2014   http   www microsoft com en-us download confirmation aspx id 42295  Select SharedManagementObjects msi for your architectur

User · Answer

I am running VS 2012  and SQL Server 2008 R2 SP2  Developer Edition  I ended up having to install items from the Microsoft   SQL Server   2012 Feature Pack  I think that the install instructions noted that these items work for SQL Server 2005 through 2012  I don t know what the exact requirements are to fix this error  but I installed the three items  and the error stopped appearing   Microsoft   SQL Server   2012 Feature Pack Items   Microsoft   SQL Server   2012 Shared Management Objects   x86   x64 Microsoft   System CLR Types for Microsoft   SQL Server   2012   x86   x64 Microsoft   SQL Server   2012 Native Client   x86   x64   Based on threads elsewhere  you may not end up needing the last item or two  Good luck

User · Answer

I am using Visual Studio 2013  amp  SQL Server 2014  I got the below error Microsoft SqlServer management sdk sfc version 11 0 0 0 not found by visual studio  I have tried all the things like installing   ENU x64 SharedManagementObjects msi for X64 OS or ENU x86 SharedManagementObjects msi for X86 OS ENU x64 SQLSysClrTypes msi Reinstalling Sql Server 2014      What actually solved my problem is to repair the visual studio 2013 or   any other version you are using  now the problem is removed   What i think it is   problem of Visual Studio not Sql Server as i was able to access and   use the Sql Server tool

User · Answer

For those who are running into a slight variation of this problem  I just found a solution    Pre-requisites  using VS 2015 and SQL Server 2012   Symptom   can t load this subsystem  Microsoft SqlServer management sdk sfc version 12 0 0 0  At this point you might be like me and confused that you are using SQL Server 2012 but VS 2015 is trying to use version 12 0 0 0  which comes from SQL Server 2014  It turns out that when you install SQL Server 2012  it installs a couple of components from SQL Server 2014  At one point I removed all traces of SQL Server from my machine  using the Add Programs control panel   When I re-installed SQL Server 2012  it either didn t re-install the 2014 components or I deleted them again thinking I missed them the first time around   The result was that I didn t have the necessary 2014 libraries on my system  I also tried to install the 2014 Shared Management Objects as pointed out above  but that didn t work because I didn t have the CLR runtime from 2014  So in order to get a VS 2015 system working with a SQL Server 2012  you have to make sure that these two 2014 packages are installed    ENU x64 SQLSysClrTypes msi ENU x64 SharedManagementObjects msi   from SQL Server 2014 Feature Pack  Pick the 32 bit versions if you  need to   Here is the site that helped me figure this out

User · Answer

Problem   Sql server 2014  This issue happens when assembly Microsoft SqlServer management sdk sfc version 12 0 0 0 not found by visual studio   Solution  just go to http   www microsoft com en-us download details aspx id 42295 and download    ENU x64 SharedManagementObjects msi for X64 OS or ENU x86 SharedManagementObjects msi for X86 OS     then install it  and restart 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   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   Sql server 2008  This issue happens when assembly Microsoft SqlServer management sdk sfc version 10 0 0 0 not found by visual studio   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 amp clcid 0x409   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   Solution   for Visual Studio 2013 just go to http   www microsoft com en-us download details aspx id 40784 and download    vcredist x64 exe for X64 OS or vcredist x86 exe for X86 OS     then install it  and restart visual studio   PS  You can find Visual C   Redistributable Packages for Visual Studio 20XX for other versions of Visual Studio easily by googling it

User · Answer

I got this error when using Visual Studio 2013 with Microsoft SQL Server Management Studio 2016 trying to update database with Entity Framework migrations The fix was to install Microsoft SQL Server Management Studio 2012 SP1 as Visual Studio 2013 was missing the necessary libraries to connect to the SQL Server database  I put together this detailed page with all the steps I took

User · Answer

Supplement to Iman Mahmoudinasab s answer  For SQL Server 2016  this is where to find the files   https   www microsoft com en-us download details aspx id 52676  Note that the files are in the list but you may need to scroll down to see select it   From SQL Server 2017 onwards  things change    Beginning with SQL Server 2017 SMO is distributed as the Microsoft SqlServer SqlManagementObjects NuGet package to allow users to develop applications with SMO    Source  https   docs microsoft com en-us sql relational-databases server-management-objects-smo installing-smo view sql-server-2017

User · Answer

Just want to share my experience on this   I  too  encountered this error  I m using MS Visual Studio 2013 and I have an MS SQL Server 2008  though I have had MS SQL Server 2012 Installed before   I was banging my head on this error for a day  I tried installing SharedManagementObject  SQLSysClrTypes and Native Client  but it didn t work  Why  Well I finally figured that I was installing 2008 or 2012 version of the said files  while I m using Visual Studio 2013   My idea is since it is a database issue  the version of the files should be the same with the MS SQL Server installed on the laptop  but apparently  I should have installed the 2013 version because the error is from the Visual Studio and not from the SQL Server

User · Answer

Just use MS Web platform Installer 4 5 to install all stuff for MS SQL Server 2008 R2   And don t forget to reload machine

User · Answer

for version 11 download the Microsoft SQL Server 2012 Feature Pack https   www microsoft com en-us download confirmation aspx id 43339   ENU x64 SQLSysClrTypes msi ENU x64 SharedManagementObjects msi   for version 12 download the Microsoft SQL Server 2014 SP2 Feature Pack https   www microsoft com en-us download details aspx id 42295   ENU x64 SQLSysClrTypes msi ENU x64 SharedManagementObjects msi

User · Answer

I am using Visual Studio 2013  amp  SQL Server 2014  I got the below error Microsoft SqlServer management sdk sfc version 11 0 0 0 not found by visual studio   I was actually expecting Microsoft SqlServer management sdk sfc version 12 0 0 0 error because I am using SQL Server 2014    To fix the issue  I had to install SQL Server 2012 s SharedManagementObject msi from the below site   http   www microsoft com en-us download details aspx id 35580  Note  You can use https   stackoverflow com a 19246011 1030460 answer but focus on the error version to select the download instead of focusing on SQL Server version

User · Answer

I downloaded  Microsoft   System CLR Types for Microsoft   SQL Server   2012  and  Microsoft   SQL Server   2012 Shared Management Objects  from  ImanMahmoudinasab mentioned link  but Shared Management Objects had problem while installing and it showed some dependencies message and at the end installation Failed   Finally I solved the problem with Power Shell  I run PS as administrator with the below command   Start-Process  lt path gt  SharedManagementObjects msi

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

Examples related to .net

Examples related to visual-studio

Examples related to sql-server-2008-r2

Examples related to entity-framework-5