4

Im trying to add my local SQL Server database to Visual Studio so I can grab the connection string from it but I am getting this error message:

enter image description here

enter image description here

As you can see the Test succeeds but when I try to add I receive error.

Kairan
  • 5,342
  • 27
  • 65
  • 104

3 Answers3

3

I figured out that you need to have SDK.sfc 11.0.0.0 installed. I only had 10.0.0.0 installed.

You can use the link here to download "Microsoft® System CLR Types for Microsoft® SQL Server® 2012" and "Microsoft® SQL Server® 2012 Shared Management Objects"

Download Link

I think these are normally installed with VS 2012 but in either case it fixed the issue. You can check your version in the assembly path: C:\windows\assembly enter image description here

The install does not require a restart but you will need to close and reopen your Visual Studio.

Kairan
  • 5,342
  • 27
  • 65
  • 104
  • fine, now it would be best to accept at least one answer as the correct one; then the question is no longer unanswered. :) – karlis Aug 31 '13 at 08:08
  • 1
    This issue has direct link: http://stackoverflow.com/questions/16906686/could-not-load-file-or-assembly-microsoft-sqlserver-management-sdk-sfc-version-1 – alansiqueira27 Nov 25 '14 at 16:15
1

It seems that you are missing some updates from Microsoft: one link

You could search with google/bing/whatever and find a lot of hints to get this working!

karlis
  • 912
  • 2
  • 11
  • 22
  • Thanks I figured it out a few minutes ago, you must have been writing your message while i was writing mine – Kairan Aug 31 '13 at 06:07
0

for both type (32 bit or 64 bit ) Open URL http://www.microsoft.com/en-us/download/details.aspx?id=35580 Download ENU\x86\SQLSysClrTypes.msi Download ENU\x86\SharedManagementObjects.msi Install ENU\x86\SQLSysClrTypes.msi Install ENU\x86\SharedManagementObjects.msi Restart your Visual Studio and now Everything will work smooth. This fix was for the error (version 11.0.0.0)

Milad
  • 11
  • 1