121

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.

abatishchev
  • 98,240
  • 88
  • 296
  • 433
NoWar
  • 36,338
  • 80
  • 323
  • 498

12 Answers12

289

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&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.

Iman Mahmoudinasab
  • 6,861
  • 4
  • 44
  • 68
  • Thanks @Iman, I just recently came across this issue, and i have no clue how i got this issue, since everything was working normal, previously, and your solution here, solved my issue. Thanks again.!! – Ron Apr 10 '14 at 00:51
  • 10
    In my situation (Windows Server 2008 R2 Standard (x64); VS2013; no SQL Server installed) "ENU\x64\SQLSysClrTypes.msi" had to be installed before "ENU\x64\SharedManagementObjects.msi". – Erik Anderson Jul 01 '14 at 18:04
  • 1
    @Imam I have installed sql server 2008 r2 express.. it gives me the error with the code version 11.0.0, like I have installed sql server 2012. If I try to install 1033\x86\SharedManagementObjects.msi, the error doesn't change. If I try to install ENU\x86\SharedManagementObjects.msi it gives obviously error. Why? What can I do ? – Piero Alberto Feb 03 '15 at 13:00
  • @PieroAlberto: **v11** is **Sql server 2012**. What is your VS version? if VS2012 or VS2013 , when you install VS it install a light version of sql server 2012 and I think your connection string is using it instead of sql server express so you get **v11** error. typo: my name is Iman ;) – Iman Mahmoudinasab Feb 03 '15 at 14:09
  • Hey @Iman. I have VS2013 and my MSSQL v.2014 so why it requires v.11 NOT v.12 ?? – Suhrob Samiev Apr 07 '15 at 03:46
  • @SuhrobSamiev Had you checked your connection string? – Iman Mahmoudinasab Jun 25 '15 at 19:09
  • 1
    For what it's worth, I had the issue after uninstalling SQL Server 2012 and installing SQL Server 2014 after VS 2013 was installed. I needed to re-install the SQL Server 2012 shared management objects for VS2013 to work properly. Installing the 2014 shared management objects had no effect. – Chris Jul 07 '15 at 08:28
  • Hi, I have the same issue. I have done same thing as you mention in our solution but did not work in VS 2015. When I installed VS 2103 works fine. @ImanMahmoudinasab – Hanni Dec 12 '15 at 13:49
  • For some others fail at the first try. I use SQL 2008 R2 express and should install Problem: (Sql server 2012) to resolve the problem. – nguyenhoai890 Aug 15 '16 at 04:04
  • 1
    Even if you are on a 64-bit OS, you will need the 32-bit version if "Prefer 32-bit" is checked on your app properties, which it is by default for Visual Studio 2015 console apps. – mhenry1384 Jan 11 '17 at 22:23
  • 2
    An FYI to this solution, CLR Types is a requirement to install Shared Management Objects. You will need to download the appropriate x86/x64 CLR type install first and then install the Shared Management Objects after. – Mike Mar 28 '17 at 14:11
  • @ImanMahmoudinasab Sql server 2016: https://www.microsoft.com/en-us/download/details.aspx?id=52676 – ctyar Jun 12 '17 at 08:28
  • @ShahriarGholami Thanks for your comment. I'll add it to my answer so other people can find it easier. – Iman Mahmoudinasab Jun 13 '17 at 09:55
  • Microsoft.SqlServer.management.sdk.sfc version 12.0.0.0 not found. In order to work for me i followed your solution but i also had to install sqlServer2014 Express – Little-God Jul 22 '19 at 09:32
13

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.

Gellie Ann
  • 439
  • 1
  • 6
  • 10
  • 5
    I was having an issue w Visual Studio 2013 connecting to SQL Server 2014, and I continually overlooked the SQL 2012 SP1 link above, thinking it did not apply. Thanks to you @Gel, I did finally install the 2012 SP1 and solve this issue. – user426364 Dec 19 '14 at 16:28
  • @Gel so, which SharedManagementObject have you installed? – Piero Alberto Feb 03 '15 at 13:02
  • @Piero I installed the SharedManagementObject in the package of the Visual Studio 2013. – Gellie Ann Feb 09 '15 at 06:36
  • 1
    Visual Studio 2013 with SQL Server 2014... I also needed the 2012 SP1 SharedManagementObject file. Thanks for the save: http://www.microsoft.com/en-us/download/details.aspx?id=35580 – Jacob Raines Jan 12 '16 at 20:01
10

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!

Will Ediger
  • 893
  • 9
  • 17
8

I am using Visual Studio 2013 & 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.

Community
  • 1
  • 1
Sundeep
  • 2,035
  • 2
  • 23
  • 38
7

For SQL Server 2014:

http://www.microsoft.com/en-us/download/confirmation.aspx?id=42295

Select SharedManagementObjects.msi for your architectur

edwardrbaker
  • 753
  • 1
  • 9
  • 20
6

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.

Greg Veres
  • 1,770
  • 19
  • 28
3

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.

:)

NoWar
  • 36,338
  • 80
  • 323
  • 498
1

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 <path>\SharedManagementObjects.msi
SeeSharp
  • 608
  • 1
  • 13
  • 21
1

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
Hamid Jolany
  • 800
  • 7
  • 11
1

I am using Visual Studio 2013 & 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.

PRATEEK GHOSH
  • 243
  • 1
  • 15
1

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.

Radu Bartan
  • 483
  • 6
  • 12
  • 1
    Please avoid linking to off-site resources. As it might be an answer right now, the off site resource might change in the futur and won't be helpful anymore. – Korashen Aug 06 '18 at 14:22
1

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://learn.microsoft.com/en-us/sql/relational-databases/server-management-objects-smo/installing-smo?view=sql-server-2017

macnerd
  • 181
  • 1
  • 6