Solved

Visual Studio and sql server data tools

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

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

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.
I have a large data set and a SSIS package. How can I load this file in multi threading?
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

773 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