Solved: “Could not load file or assembly ‘Microsoft.SqlServer.Management.Sdk. The system cannot find the file specified”

You may run into the error below while doing development in Visual Studio:

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.

Solution

You are missing SQL Server libraries that connects Visual Studio to SQL Server database. In order to fix this issue, download and install these two packages from the following URL.

  • SharedManagementObjects.msi
  • DB2OLEDBV5_x64.msi

Download: www.microsoft.com/en-us/download/details.aspx?id=35580

Note: The URL above is for SQL Server 2012. Download libraries for the version you use if it is not 2012 version.

How to install Entity Framework in Visual Studio?

There are 2 ways to install Microsoft’s data access technology, Entity Framework:

Use NuGet Package Manager UI:

  1. In Visual Studio, click “Tools > NuGet Package Manager > Manage NuGet Packages for Solution…”
  2. Search for “Entity”
  3. Select “EntityFramework” and click “Install”

Use NuGet Package Manager Console:

  1. In Visual Studio, click “Tools > NuGet Package Manager > Package Manager Console”
  2. Enter the following command:

    Install-Package EntityFramework

It will automatically install the latest version available (It’s 6.2.0 as of the date I wrote this post).

I used Visual Studio 2013 in the screenshots above.

Solved: “An error occurred while signing: SignTool.exe not found”

This issue may come up when you try to publish your project in Visual Studio:

An error occurred while signing: SignTool.exe not found

Solution

The main cause is that you are missing ClickOnce Publishing Tools component in your Visual Studio installation. Simply follow these steps to solve this issue:

Solution

The main cause is that you are missing ClickOnce Publishing Tools component in your Visual Studio installation. Simply follow these steps to solve this issue:

  1. Go to “Add/Remove Programs”
  2. Find “Visual Studio”. Click “Change”
  3. Select “Click Once Publishing Tools”
  4. Click “Next” and then click “Update”

Credits: http://stackoverflow.com/questions/7548342/an-error-occurred-while-signing-signtool-exe-not-found