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.
Visual Studio 2013 is only compatible with SQL Server 2014.
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.
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.
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.
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
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.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With