Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Visual Studio 2013 incompatibility with MS SQL Server 2014

Tags:

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.

like image 220
Citrus Avatar asked Jun 22 '14 13:06

Citrus


People also ask

Which version of Visual Studio is compatible with SQL Server 2014?

Visual Studio 2013 is only compatible with SQL Server 2014.

Is SQL 2014 still supported by Microsoft?

SQL Server 2014 reached its end of life on 9 July 2019 and its extended support will end on 9 July 2024. While this may seem a bit far, Microsoft encourages organisations to start planning an upgrade to avoid an expensive crisis.

Which SQL Server is compatible with Visual Studio 2019?

No. It only supports any edition before 2012 of SQL Server. The latest version is Visual Studio 2019. BTW, after upgrading Visual Studio you should use the latest SQL server (2019), which is always correct.

Does Visual Studio connect to SQL Server?

Visual Studio Code is a graphical code editor for Linux, macOS, and Windows. It supports extensions, including the mssql extension for querying a SQL Server instance, Azure SQL Database, an Azure SQL Managed Instance, and a database in Azure Synapse Analytics.


2 Answers

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

like image 70
Milica Medic Kiralj Avatar answered Oct 13 '22 07:10

Milica Medic Kiralj


I'm guessing that your VS2013 isn't fully updated and that you need to update the database tooling component (SSDT) for SQL2014. I posted an answer on this a couple of days ago with some instructions.

Look at the Extensions and Updates in VS2013 and there should be an update available for SQL Server Data Tools.

like image 31
jpw Avatar answered Oct 13 '22 07:10

jpw