Search code examples
sql-servervisual-studio-2013sql-server-data-toolssql-server-2014

Visual Studio 2013 incompatibility with MS SQL Server 2014


I downloaded MS SQL Server 2014 Enterprise Edition from MSDN. I want to do a server backend in C# and MS SQL, but the problem is, whenever I want to do something with DB in Visual Studio 2013 Ultimate it just tells me this

===================================

An incompatible SQL Server version was detected. (Microsoft.VisualStudio.Data.Tools.SqlEditor)
------------------------------
Program Location:

   at Microsoft.VisualStudio.Data.Tools.SqlEditor.DataModel.SqlConnectionStrategy.ValidateConnectionForEditor(UIConnectionInfo ci, IServerType server)
   at Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectionThreadUser()

Honestly, I don't know what is going on, or why tells me that VS is incompatible with SQL server.


Solution

  • You should update SSDT to 2014, you can download it here:http://msdn.microsoft.com/en-us/data/hh297027

    Read more about support for SQL Server 2014 on this blog: SQL Server Data Tools for SQL Server 2014 is available

    From the post:

    For Visual Studio 2013 download check the Visual Studio update channel (Tools –> Extensions and Updates –> Updates) for this update.

    Hope this helps