could not load file or assembly 'microsoft.sqlserver.management.sdk.sfc version=11.0.0.0

.net entity-framework-6 sql-server-2008-r2 visual-studio-2012

Question

I am using Database first approach of Entity framework. When I create new connection in "ADO.NET Entity Data Model" then after adding server name and database name, then it shows me this error -

Could not load file or assembly 
'Microsoft.SqlServer.Management.Sdkc.Sfc, Version=11.0.0.0, 
Culture=neutral, PublicKey Toekn = 89845dcd8080cc91' or one of its
dependencies. The system cannot find the file specified.

Found many links on Google and tried but it doesn't solve my issue.

Could not load file or assembly Microsoft.SqlServer.management.sdk.sfc version 11.0.0.0

Tried this
SharedManagementObjects.msi (64 Bit) (Install proper and restart VS and same error occurs again) PowerShellTools.msi

Visual Studio 2012, SQL Server 2008 R2, 64 Bit Operating System

1
4
7/4/2017 12:10:34 PM

Accepted Answer

Note: x86 or x64 depending on OS Structure

Step 1: Visit the below url and then click on Download option. http://www.microsoft.com/en-us/download/details.aspx?id=35580

Step 2: select the file name:ENU\ x64 \SQLSysClrTypes.msi and then click on Next. This will shown an option to run this msi file. Please run this msi file and finish the installation.

Step 3: Again visit the above link and click on Download option. this time you need to select the file name:ENU\ x64 \SharedManagementObjects.msi and then click on Next. This will shown an option to run this msi file. Please run this msi file and finish the installation.

Step 4: Once above 2 files are downloaded and installed. Close the Visual Studio and reopen it. Now you should be able to create the database through server explorer without any errors.

1
7/4/2017 12:08:51 PM

Popular Answer

The answers posted in this thread as well as other similar threads only apply to SQL Server 2008, 2012 and 2014, but not to SQL Server 2016

I installed ENU\x64\SharedManagementObjects.msi

I also installed the SQLSysClrTypes.msi, but to no avail.

Finally, I did the following:

1) I ran the SQL Server 2016 setup,

2) I chose to install SSDT from there, SSDT Selection

3) Installed all of the things there: analysis, integration, reporting etc

That's it, no more errors



Related Questions





Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow