All geek questions in one place

Visual Studio cannot add SQL Server connection

I am trying to add my local SQL Server database in Visual Studio so that I can take the connection string from it, but I get this error message:

enter image description here

enter image description here

As you can see, the test completed successfully, but when I try to add, I get an error.

+4
source share
3 answers

I realized that you need to install SDK.sfc 11.0.0.0. I have only 10.0.0.0 installed.

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

Download link

I think they are usually installed with VS 2012, but in any case, he fixed the problem. You can check your version on the build path: C: \ Windows \ builds enter image description here

The installation does not require a reboot, but you need to close and reopen your Visual Studio.

+3
source

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

You can search with google / bing / whatever and find a lot of hints to make this work!

+1
source

for both types (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 smoothly. This fix was for error (version 11.0.0.0)

0
source

Source: https://habr.com/ru/post/1499892/

More articles:


All Articles