Visual Studio and sql server data tools

I am trying to create a report with Visual Studio and sql server data tools.  I connect to the data source (northwind) with no problems and then i go to the query designer and try to add tables.  That is when I get this error - I can't find anything googling.

Any help is appreciated - this is a local sql 2014 express on a laptop with visual studio 2012 - no external server connection

screen
Thanks
JohnMac328Asked:
Who is Participating?
 
Pawan KumarDatabase ExpertCommented:
This assembly is not there on your machine.  Microsoft.SqlServer.management.sdk.sfc version 11.0.0.0

Download the update from Microsoft.
0
 
JohnMac328Author Commented:
I found this link and followed the directions - I can't get past step 2 because I get an error saying my versions are higher and they have to be uninstalled first - also I am using sql 2014 and they keep referencing sql 2012

https://social.msdn.microsoft.com/Forums/silverlight/en-US/c4a9717b-e3c0-4c92-9125-d587ba088d22/could-not-load-file-or-assembly-microsoftsqlservermanagementsdksfc-version-11000-on-visual?forum=visualstudiogeneral
0
 
JohnMac328Author Commented:
After some research it looks like uninstalling sql 2014 and installing 2012 is the fastest way to resolve this problem.  The SQL version does not matter in this situation.
0
 
JohnMac328Author Commented:
Thanks for pointing me in the right direction
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.