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

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

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

VRM

Related Questions

'Microsoft.SqlServer.Types' version 10 or higher could not be found on Azure

I'm trying to make a webapi in ASP.NET MVC 4. The webapi used Entity Framework 5 Spatial types and i have wrote a very simple code. ... public List<Area> GetAllAreas() { List<Area> aList = db.Areas.ToList(); return aList; } ...Area contains DbGeometry....When i run this local it works, but when i publish it to azure it give...
asp.net-mvc azure entity-framework
asked by Thomas Bolander

Could not load file or assembly 'EntityFramework' after downgrading from 4.5 to 4.0 with EF5

I recently developed a .net 4.5 library using Entity Framework 5. Everything worked fine until I've been told I had to downgrade to .net 4.0 in order to remain compatible with Windows 2003....I uninstall EF 5 using the Package Manager Console and had the successfull message, then this one:...Failed to generate binding redirects for 'MyProjectName'....
.net asp.net entity-framework
asked by Francois Stock

Error Copying file bin\EntityFramework.SqlServer.xml to ..\bin\EntityFramework.SqlServer.xml failed

Error 1 Copying file bin\EntityFramework.SqlServer.xml to obj\Debug\Package\PackageTmp\bin\EntityFramework.SqlServer.xml failed. Could not find file 'bin\EntityFramework.SqlServer.xml'. 0 0 Karinoks ...when I try to publish my mvc 4 project, I have this error. ...there is no error on debugging or run time. it is just showed when I pub...
asp.net-mvc c# entity-framework
asked by mrTurkay

Could not load file or assembly 'EntityFramework, Version=6.0.0.0,

I am working with EF . I am trying to execute this line ...public ActionResult Edit(string id) { return View(obj.FindSemesterById(id)); } ...I installed EF Version 5 on my project....But i get this error :...Could not load file or assembly 'EntityFramework, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' ...
asp.net asp.net-mvc c# entity-framework nuget
asked by Ehsan Akbar

Could not load file or assembly 'System.Web.WebPages.Razor, Version=3.1.1

I’m trying to upgrade a project from MVC 4/EF 5 to MVC 5/EF 6. I updated the framework from 4.5 to 4.5.1 and then from NuGet updated the Solution MVC (4.0.30506.0 to 5.1.1) and EntityFramework (5 to 6.1.1). This pulled in a Razor dependency (2.0.30506.0 to 3.1.1) and WebPages (2.0.30506.0 to 3.1.1). I edited the Project and Views folder web.co...
asp.net-mvc-5 entity-framework-6 razor
asked by Joe

The Entity Framework provider type 'System.Data.Entity.SqlServer.SqlProviderServices, EntityFramework.SqlServer' could not be loaded

I created a WCF Service using dotNet 4.5. The database layer is built with Entity Framework 6....I hosted the service with IIS 8. It is working fine....Now I need to consume the service with windows forms client, that is built using dotnet framework 3.5. ...I can create the service reference successfully. But when I run the code, getting the follo...
.net entity-framework wcf winforms
asked by Ali Sakhi

Could not load file or assembly 'EntityFramework, Version=6.0.0.0

What am I doing wrong? How do I troubleshoot this?...I have a solution that has multiple projects. It is an MVC .NET 4.5 web application. ...When invoking one of the projects AFTER I start in debug mode, I am getting this error. ...The project that is causing this error has the following references:...They are both versions ...6.0.0.0...Server Erro...
.net asp.net c# entity-framework visual-studio
asked by l--''''''---------''''''''''''

error 0004: Could not load file or assembly 'MySql.Data.Entity, Version=6.9.7.0

I built an ASP.NET application using MySQL database. On my pc development server it works perfectly but gives the following error on host/production server...Error 0004: Could not load file or assembly 'MySql.Data.Entity,... Version=6.9.7.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d' or one of its dependencies"...I used MySql connect ver...
asp.net c# entity-framework-6 mysql mysql-connector
asked by Caesar

EF Migrations: Could not load file or assembly EntityFramework, Version=6.0.0.0

I have been going round in circles trying to get EF to run my migrations via powershell, but getting no where. I can run them through visual studio, using the package manager console, but when I run it using a powershell script I get the error:...migrate.exe : At line:1 char:1 + & "C:\Development\Ef\Tools\migrate.exe" "TestApp.Data.dll" /connec...
ef-migrations entity-framework-6 powershell
asked by Tom

Assembly 'Microsoft.SqlServer.Types' version 10 or higher could not be found

I Have a problem. I'm not able to add a Migration to my ASP.NET WebAPI 2 Project. I get error: ..."Spatial types and functions are not available for this provider because the assembly 'Microsoft.SqlServer.Types' version 10 or higher could not be found."...I know there are several questions and answers about this, like:...'Microsoft.SqlServer.Ty...
azure c# entity-framework sql-server visual-studio
asked by Martín

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...

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