Microsoft Sqlserver Management Sdk

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.

SQL SERVER – Microsoft.SqlServer.Management.Sdk. /netflix-download-mac.html. Sfc.EnumeratorException: Failed to Retrieve Data for This Request. Mar 17, 2017 8:30:11 PM by Pinal Dave. Could not load file or assembly 'microsoft.sqlserver.management.sdk.sfc,Version=10.0.0.0, Culture=neutral,PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.

Here is the complete error message:

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. ENUx86SQLSysClrTypes.msi
  2. ENUx86SharedManagementObjects.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 ENUx86SQLSysClrTypes.msi
  3. Download ENUx86SharedManagementObjects.msi
  4. Install ENUx86SQLSysClrTypes.msi
  5. Install ENUx86SharedManagementObjects.msi
  6. Restart your Visual Studio and now Everything will work smooth.

This fix was for the error (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. 1033x64SharedManagementObjects.msi for X64 OS or
  3. 1033x86SharedManagementObjects.msi for X86 OS

Microsoft.sqlserver.management.sdk.sfc Version 11.0.0.0 Download

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