SQL Server 2012 DataTools + Visual Studio 2012 = An incompatible DacFx version is installed

visual-studio-2012 sql-server-2012 sql-server-2012-datatools
DioBrando picture DioBrando · Nov 11, 2013 · Viewed 23.2k times · Source

I'm going crazy, trying to use SSDT in Visual Studio 2012. I created a database but I can't add tables etc. because of this error.

I installed:

  • Visual Studio 2012 Ultimate
  • SQL Server 2012 Express x64 with Advanced Services, plus WinUpdates
  • Microsoft SQL Server Data Tools - Business Intelligence for Visual Studio 2012 x86 (couldn't find a specific x64 version)
  • SQL Server 2012 Data-Tier Application Framework (August 2013 both x86-x64 versions)

Basically I followed this MSDN piece of advice, http://social.msdn.microsoft.com/Forums/sqlserver/en-US/04ee07bf-31d9-4a60-90ad-bf48c16eb4d1/ssdt-vs2012-error-dac-framework-compatibility?forum=ssdt but without results

Is there something I have to do, or follow a particular order?

Really this stuff is driving me crazy

Thx evbdy

Answer

Kevin Cunnane picture Kevin Cunnane · Nov 19, 2013

You need to download the latest version of SSDT from http://msdn.microsoft.com/en-us/data/hh297027. Or you should be able to get it inside Visual Studio by choosing "SQL-> Check for Updates" from the top menu bar. This will install the latest SSDT and DacFx bits, and fix this error.

Unfortunately SSDT and SSDT-BI have confusingly similar names but are separate downloads with different functionality. That's why your installation of the SSDT-BI tool didn't fix this error.

Related questions

SQL Server 2012 installation Reporting Services Catalog error

I'm installing SQL Server 2012 at the moment and when I was about to run the installation, this error pops up: On clicking the first failed test, which is "Reporting Services Catalog Database File Existence", this is what i get: On …

Read More
SSIS 2012 Method not found: void

I recently got this error in every SSIS package (using Visual Studio 2012), when I want to open a OLE DB source component: =================================== Method not found: 'Void Microsoft.DataTransformationServices.DataFlowUI.DataFlowConnectionPage.set_DataPreviewTimeout(Int32)'. (Microsoft Visual Studio) ------------------------------ Program Location: …

Read More
How can I fix the T-SQL editor in VS 2012 after installing SQL Server 2012 SP1?

I can suddenly no longer open .sql files in VS 2012 by simply double clicking in the Solution Explorer. I get the error message: Unable to open Transact-SQL file in custom editor I strongly suspect this is after installing SP1 for …

Read More