Visual Studio Unable to Add Data Connection to SQL Server
sql, sql-server-2008-r2, visual-studio, visual-studio-2012
Solution
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
The install does not require a restart but you will need to close and reopen your Visual Studio.
Problem
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: As you can see the Test succeeds but when I try to add I receive error.