Could not load file or assembly Microsoft.SqlServer.Management.Sdk.Sfc

Unable to add data connection. Microsoft.SqlServer.Management.Sdk.Sfc Linq to SQL Classes Could not load file or assembly

Try to add ADO.Net Entity Data Model by using Visual Studio 2013 and having SQL Server 2008 R2 and got the error "Unable to add data connection.", so change my mind and try the same by using Linq to SQL Classes and again go the same error. As usual I try some other options to connect to the database but still the error message is same so decided to explore to fix it.

Here is the complete error message:

Server Explorer
Unable to add data connection.
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.

Since I am using Windows 7 64 bit, SQL Server 2008 and Visual Studio 2013, I fixed this issue by using these two msi files

  1. ENU\x86\SQLSysClrTypes.msi
  2. ENU\x86\SharedManagementObjects.msi

I tried 64bit version but that could not worked for me so tried these 32bit version and it solved my problem, here is the steps

  1. Open URL http://www.microsoft.com/en-us/download/details.aspx?id=35580
  2. Download ENU\x86\SQLSysClrTypes.msi
  3. Download ENU\x86\SharedManagementObjects.msi
  4. Install ENU\x86\SQLSysClrTypes.msi
  5. Install ENU\x86\SharedManagementObjects.msi
  6. Restart your Visual Studio and now Everything will work smooth.

This fix was for the error (version 11.0.0.0)

Microsoft.SqlServer.Management.Sdk.Sfc, Version=11.0.0.0

If you are facing the problem for Microsoft.SqlServer.management.sdk.sfc version 10.0.0.0 then

  1. URL: http://www.microsoft.com/en-us/download/details.aspx?id=26728
  2. 1033\x64\SharedManagementObjects.msi for X64 OS or
  3. 1033\x86\SharedManagementObjects.msi for X86 OS

Check the same question on stackover flow, might be you can get more versions solution there for newer version of SQL Server 2012 and 2014

Could not load file or assembly Microsoft.SqlServer.Management.Sdk.Sfc

Ali Adravi Having 13+ years of experience in Microsoft Technologies (C#, ASP.Net, MVC and SQL Server). Worked with Metaoption LLC, for more than 9 years and still with the same company. Always ready to learn new technologies and tricks.
  • sql server
  • vs 2012
  • vs2013
By Ali Adravi On 06 Nov, 14  Viewed: 17,393

Other blogs you may like

Adding identity to an existing column in SQL Server

We can not directly change a column to identity columns, say we have a primary key column or any normal column in our table and want to make it identity column then we cannot do it directly by altering the table but there are only two way to change column to identity column 1. Create a new... By Ali Adravi   On 02 May 2013  Viewed: 387

some useful sql tricks

There are many ways which can help us to save our time to write some repeated code or to do some repeated action, in this post we will see some very common code which we need very frequently in our development life. I am not saying that after this post you will save your half say work every day but... By Ali Adravi   On 31 Mar 2013  Viewed: 517

Get precision and decimal value in SQL Server by using PARSENAME

In SQL server there are decimal and money data type to store precision and scale both together or say decimal values. Suppose we want to get precision and scale separately then how to get it. There are many ways to do this but there is a function in SQL named PARSENAME which can be used to get... By Myghty   On 26 Mar 2013  Viewed: 1,294

Available wildcards in sql server with examples

To write a good performing procedure or function we should be aware about available wildcards in SQL Server. I found most developer depends on ‘%’ wildcard only while we have others as well. In this article we will discuss all the available wildcards in detail with examples. First of all let’s see... By Dev D   On 25 Feb 2013  Viewed: 357

Concatenate multiple columns in SQL Server with NULL value

When we need to concatenate two columns simply we can use `+` sign and that is correct, but what if any of them is null, Will it return what we want, NO, it will return null. So let's discuss how we should concatenate two or more columns without creating extra space or extra comma problem. Let's... By Ali Adravi   On 13 Feb 2013  Viewed: 5,312