Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Visual Studio and sql server data tools

Posted on 2016-10-05
4
Medium Priority
?
86 Views
Last Modified: 2016-10-05
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
0
Comment
Question by:JohnMac328
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
4 Comments
 
LVL 30

Accepted Solution

by:
Pawan Kumar earned 2000 total points
ID: 41831003
This assembly is not there on your machine.  Microsoft.SqlServer.management.sdk.sfc version 11.0.0.0

Download the update from Microsoft.
0
 

Author Comment

by:JohnMac328
ID: 41831036
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
 

Assisted Solution

by:JohnMac328
JohnMac328 earned 0 total points
ID: 41831076
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
 

Author Closing Comment

by:JohnMac328
ID: 41831078
Thanks for pointing me in the right direction
0

Featured Post

 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

662 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question