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

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.

Ned Sahin

Blogger for 20 years. Former Microsoft Engineer. Author of six books. I love creating helpful content and sharing with the world. Reach me out for any questions or feedback.

Leave a Comment