CODEWITHSUNDEEP
sqlvisual-studiovisual-studio-2012sql-server-2008-r2
Kairan
Kairan

Reputation: 5542

Visual Studio Unable to Add Data Connection to SQL Server

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.

Upvotes: 4

Views: 28979

Answers (3)

Milad
Milad

Reputation: 11

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)

Upvotes: 0

Kairan
Kairan

Reputation: 5542

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.

Upvotes: 3

karlis
karlis

Reputation: 920

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!

Upvotes: 1

Related Questions