a blog for those who code

Friday, 19 February 2016

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

In this post we will be discussing about how to solve could not load file or assembly Microsoft.SqlServer.Management.Sdk.Sfc, Version=11.0.0.0. When you try to add a database connection to Visual Studio Server Explorer you might encounter this error.

The full error says "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" as shown below :


This issue occurs when Visual Studio could not find assembly Microsoft.SqlServer.Management.Sdk.Sfc when you try to add a database connection. If you are in Visual Studio 2012 and try to add a database connection and if you do not have SQL Server 2012 installed you will get this error, similarly if you have Visual Studio 2014 and you try to add a database connection and you do not have SQL Server 2014 installed you will get this error.


To solve this error in Visual Studio 2014 you need to download ENU\x64 OR x86\SharedManagementObjects.msi from Microsoft 2014 and install it. Similarly to solve this error in Visual Studio 2012 you need to download ENU\x64 OR x86\SharedManagementObjects.msi from Microsoft 2012 and install it.

If the above solution does not work for you then you need to install Visual C++ Redistributable Packages for Visual Studio vcredist_x64.exe or vcredist_x86.exe from Microsoft Website.

Please Like and Share the CodingDefined.com Blog, if you find it interesting and helpful.

1 comment:

  1. Thanks for saving my struggle...

    ReplyDelete