Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Visual Studio and sql server data tools

Posted on 2016-10-05
4
Medium Priority
?
88 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
  • 3
4 Comments
 
LVL 35

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

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

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

When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error “Connecting to the Integration Services service on the computer failed with the following error: 'The specified service …
This month, Experts Exchange sat down with resident SQL expert, Jim Horn, for an in-depth look into the makings of a successful career in SQL.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

916 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