Solved

Visual Studio and sql server data tools

Posted on 2016-10-05
4
70 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 28

Accepted Solution

by:
Pawan Kumar earned 500 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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

735 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