Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Question
Saturday, November 29, 2014 4:07 AM
I am getting the infamous "Could not load file or assembly Microsoft.SqlServer.management.sdk.sfc version 11.0.0.0." The set up of my system is Visual Studio 2013 Ultimate update 4 and my SQL server is 12.0.2000 Express. I am also using SQL management studio 2014. I read other comments and blogs, and reinstalled the SQL Express 12.0.2000, but no luck yet.
All replies (9)
Monday, December 1, 2014 3:23 AM
Hi payam49er,
>>I am getting the infamous "Could not load file or assembly Microsoft.SqlServer.management.sdk.
sfc version 11.0.0.0."
Based on your error, could you please tell me what you do operation and then you get the error message?
Could you please tell me if you add a data connection from Server Explorer Window in Visual studio 2013 Ultimate update 4 and then you get the error message?
If yes, to check if the issue is related to the VS IDE issue, I suggest you can execute the following commands to check if it can help you add data connection in VS2013 Ultimate Update 4.
(1)I suggest you can run your VS in safe mode by executing Devenv.exe /SafeMode to add a data connect again.
(2)I suggest you can use the Devenv.exe /ResetSettings to restores the IDE's default settings, optionally resets to the specified VSSettings file.
(3)You can execute the Devenv.exe /ResetAddin to remove commands and command UI associated with the specified Add-in.
In addition, if you used the SQL Server Express to connect the data in VS, you need to specify the server name as MyComputerName\SQLEXPRESS. If you used the SQL Server to connect the data in VS. Please you try to specify the server name as MyComputerName\InstanceName here to check the result.
If still no help, according the error, it indicates that the problem is that the system cannot locate the right assembly (SQL Server SDK). So I think you may get better response and solutions if you consult on SQL Server forums.
Thank you for your understanding.
Best Regards,
We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
Click HERE to participate the survey.
Wednesday, December 3, 2014 2:02 AM
Hi Tina
Yes, I get the message when I try to dd a data connection from Server Explorer Window in Visual studio 2013 Ultimate update 4 and then I get the error message. I followed your suggestion and no luck at the end. When I test the connection the DB Server, the connection is successful, but when I press OK to close the form, I get the error.
Wednesday, December 3, 2014 3:52 AM
I uninstalled SQL Server 2014 and installed 2012. The problem is gone now. From what I have read around, this must be a bug in VS 2013.
Wednesday, December 3, 2014 8:17 AM
Hi payam49er,
Glad to receive your reply.
According to your description, I tried to download and install a version of SQL Serevr 2014 LocalDB Express 64 bit on my Windows 8.1 machine. Then I add a data connection from Server Explorer Window in Visual studio 2013 Ultimate update 4, I found that I did not get the error message.
In addition, as you said that when you install the SQL Server Express 2012, it woks in the VS 2013 Ultimate update 4. So I doubt the issue may be more related to the SQL Server Express 2014 rather than the VS 2013 IDE issue.
If possible, I suggest you can try to re-download the SQL Server 2014 Express from the here and then select the version of SQL Server 2014 LocalDB Express 64 bit and install it again check if you get the error message.
In addition, about the error message, I found a similar thread about this issue, maybe you will get some useful message.
If the above suggestion still could not help you, as I pervious mentioned that I suggest you can ask the issue to SQL forum, it will be better help you.
Thanks for your understanding.
Best Regards,
We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
Click HERE to participate the survey.
Monday, April 20, 2015 6:07 PM
This is definitely not the answer, please un-mark. This problem is persistent and not fixed with a localdb re-install.
Monday, April 20, 2015 6:13 PM
From what I can tell, the problem is that VS2013 wants v.11 (which I assume comes with SQL Server 2012?), but the default SQL 2014 installation only includes version 12. I have a clean installation of both on Win 8.1 and I see the v.12 assemblies, but not v.11.
Sunday, July 26, 2015 6:44 PM | 5 votes
(Note: x86 or x64 depending on OS)
1. ENU\x64\SQLSysClrTypes.msi
2. ENU\x64\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\ 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.
Wednesday, August 1, 2018 5:09 PM
Nice, this solved my problem. Thanks.
Monday, August 6, 2018 2:13 PM
I got this error when using Visual Studio 2013 with Microsoft SQL Server Management Studio 2016 trying to update the database with Entity Framework migrations
The fix was to install Microsoft SQL Server Management Studio 2012 SP1 as Visual Studio 2013 was missing the necessary libraries to connect to the SQL Server database.
I put together this detailed page with all the steps I took: https://analogyofpearl.com/could-not-load-file-or-assembly-or-one-of-its-dependencies