Could not load file or assembly 'Microsoft.SqlServer.Management.Sdk.Sfc, Version=11.0.0.0 Error


I have recently installed SQL Server Express and Visual Studio 2012 on my PC. when I opened Server Explorer in Visual Studio 2012 to create a new Database. I got the below error: Could not load file or assembly 'Microsoft.SqlServer.Management.Sdk.Sfc, Version=11.0.0.0

I have recently installed SQL Server Express and Visual Studio 2012 on my Windows 7 computer. when I opened Server Explorer in Visual Studio 2012 to create a new Database. When I Right Click DataConnections and select Create New SQL Server Database. I entered the server name and the New Database Name and then when I cliked on OK button, I got the below error:

Could not load file or assembly 'Microsoft.SqlServer.Management.Sdk.Sfc, Version=11.0.0.0.

If you are running 32 bit Windows 7 operating system. Then you need to install the below packages to get rid of the above error.

1. ENU\x86\SQLSysClrTypes.msi
2. ENU\x86\SharedManagementObjects.msi

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\x86\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\x86\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.


Comments

Guest Author: Vijaykumar S Sheth27 Feb 2014

Excellent, Million thanks for the solution, Works fine. I was struggling to solve this problem in VS 2013.

Author: Anirban Saha01 Jun 2014 Member Level: Bronze   Points : 0

When I am trying to install these components, I am getting error message that I am missing dll from my system due to which the setup cannot be continued.

Please suggest something ASAP.

Regards

Author: Vaishali Jain01 Jun 2014 Member Level: Gold   Points : 0

is it listing the name of the dll which is missing ?

Author: Shanmukh joga31 Aug 2014 Member Level: Bronze   Points : 3

Error : Could not load file or assembly 'Microsoft.SqlServer.Management.Sdk.Sfc, Version=11.0.0.0'
System cannot find the file specified
Iam using vs2013 and SQLSERVER2014 and I am trying to use entity framework to connect to the DB from vs2013. I am getting test connection succeeded when adding the Entity dat model but getting the above error.

I was struglling to fix this issue from many days .Please did any one face this issue

Author: Vaishali Jain01 Sep 2014 Member Level: Gold   Points : 0

Hi Shanmukh, could you please tell me when you are getting this exception? Is it when using entity framework or when you try to open the database from server explorer or through management studio.

Guest Author: mubarak08 Sep 2014

Error : Could not load file or assembly 'Microsoft.SqlServer.Management.Sdk.Sfc, Version=11.0.0.0'
System cannot find the file specified
Iam using vs2013 and SQLSERVER2014 and I am trying to use entity framework to connect to the DB from vs2013. I am getting test connection succeeded when adding the Entity dat model Through server exploree but getting the above error.

Author: Petr Rehurek10 Nov 2014 Member Level: Bronze   Points : 4

I have same problem as Shanmukg jogo, but have other version of SQL server.
I have VS 2012 & SQL 2008 (with instaled components and running i think correctly)
If i want to connect VSs with SQLs i use in VS Tools & Connect to Database, If i test connection it write testet sucesfully, can change databaze what i created on SQLs and if i click OK thats write error:

Could not load file or assembly 'Microsoft.SqlServer.Management.Sdk.Sfc, Version=11.0.0.0

but msi files are correctly installed and comp restarted.
If you can help me I will be a lot grateful to you for it.
I am so sorry for my bad english and Thanks for all replies.
Your Sincerely Petr

---

now i have installed more running versions of SQL server and i have still same problem

Guest Author: Aleksey18 Dec 2014

Hi. I have the same error. Trying to create property 'DataSource' of BindingSource component, I got the descussing by Petr Rehurek error.
The resolve of the problem is in progress.



  • Do not include your name, "with regards" etc in the comment. Write detailed comment, relevant to the topic.
  • No HTML formatting and links to other web sites are allowed.
  • This is a strictly moderated site. Absolutely no spam allowed.
  • Name:
    Email: