SQL Server – Fixing Database Version Higher Than SSMS Error

sql serversql server 2014visual studio 2017

I have installed VS 2017. After that I have installed SQL Server 2014.

Whenever I create a DB using SSMS and attempt to create a table it returns the following error:

This backend version is not supported to design database diagrams or
tables. (MS Visual Database Tools).

When creating the database using SSMS the compatibility level has no value to select from.

Version of the SQL Server is 2017 and version of SSMS is 2014. How do I resolve this?

As there any way to use SQL Server 2017 with SSMS 2014?

Best Answer

AS MSDN Blog Here Use the SSMS version designed for your database version. You can use the command select @@version; to check which version of SQL Server you are actually using. Update your SSMS to the latest version and try. You may have the latest version of SQL Server and older version of SSMS.

To Download the latest SQL Server Management Studio (SSMS) https://msdn.microsoft.com/en-us/library/mt238290.aspx

For your further ref https://stackoverflow.com/questions/25146474/the-backend-version-is-not-supported-to-design-database-diagrams-or-tables

Related Question