This backend version is not supported to design database diagrams or tables как исправить

I’m trying to add a table to my newly created database through SQL Server Management Studio.
However I get the error:

the backend version is not supported to design database diagrams or tables

To see my currently installed versions I clicked about in SSMS and this is what came up:

What’s wrong here?

kkuilla

2,2263 gold badges33 silver badges37 bronze badges

asked Aug 5, 2014 at 19:08

This is commonly reported as an error due to using the wrong version of SSMS(Sql Server Management Studio). Use the version designed for your database version. You can use the command select @@version to check which version of sql server you are actually using. This version is reported in a way that is easier to interpret than that shown in the Help About in SSMS.

Using a newer version of SSMS than your database is generally error-free, i.e. backward compatible.

BPX

8881 gold badge8 silver badges20 bronze badges

answered Aug 5, 2014 at 19:14

Gary WalkerGary Walker

8,7613 gold badges18 silver badges41 bronze badges

I found the solution. The SSMS version was older. I uninstalled SSMS from the server, went to the microsoft website and downloaded a more current version and now the Database Diagrams works ok.

Jeremy Caney

6,99961 gold badges48 silver badges76 bronze badges

answered Nov 17, 2022 at 13:14

if you got this error in SQL Server Management Studio (SSMS) 18.12.1 in 2022, please download Download SQL Server Management Studio (SSMS) 19 (Preview) and install it, a link is here, download the latest one, this provided link is the current latest version.

answered Dec 23, 2022 at 6:22

Just a heads up, Got the same message when I installed SQL Express 2022… Literally Installed SSMS (v18) by clicking the link after Express finished installing. I deleted V18 and downloaded V19, which is still in beta, and it fixed the problem.

answered Nov 30, 2022 at 15:58

I ran into this problem when SQL Server 2014 standard was installed on a server where SQL Server Express was also installed. I had opened SSMS from a desktop shortcut, not realizing right away that it was SSMS for SQL Server Express, not for 2014. SSMS for Express returned the error, but SQL Server 2014 did not.

answered Mar 12, 2015 at 1:18

MikeSNPMikeSNP

1031 gold badge2 silver badges4 bronze badges

I was having the same problem, although I solved out by creating the table using a script query instead of doing it graphically. See the snipped below:

USE [Database_Name]
GO

CREATE TABLE [dbo].[Table_Name](
[tableID] [int] IDENTITY(1,1) NOT NULL,
[column_2] [datatype] NOT NULL,
[column_3] [datatype] NOT NULL,

CONSTRAINT [PK_Table_Name] PRIMARY KEY CLUSTERED 
(
[tableID] ASC
)
)

answered Aug 30, 2019 at 13:59

Consider using other design tools like Visual Studio. You can connect to your DB from Visual Studio and use VS design tools which is very easier and faster than writing T-Sql commands.

answered Nov 17, 2021 at 17:48

EhsanEhsan

112 bronze badges

You only get that message if you try to use Designer or diagrams. If you use t-SQL it works fine:

Select * 

into newdb.dbo.newtable
from olddb.dbo.yourtable

where olddb.dbo.yourtable has been created in 2008 exactly as you want the table to be in 2012

answered Feb 27, 2015 at 15:50

Источник

Remove From My Forums

Question
SQL server database: Microsoft SQL Server 2016 (RTM-GDR) (KB4019088) — 13.0.1742.0 (X64)
Jul 5 2017 23:41:17
Copyright (c) Microsoft Corporation
Express Edition (64-bit) on Windows 10 Home 6.3 <X64> (Build 16299: )

Visual Studio Version: Professional 2015

SSMS Version: Hmmm, it looks like even though I installed SSMS 2017 v 17.3, there is no uninstall link for SSMS 2012.

2012 does not show up in the uninstall programs list.

When I type SQL Server Management into Cortana, it ONLY shows SSMS 2012, not 2017.

That’s why when I try to edit tables on my SQL Server 2016 server, I get the error, it wants to launch SSMS 2012.

I’d rather live with false hope than with false despair.

Answers

- Proposed as answer by
  
  Thursday, December 7, 2017 5:24 AM
- Marked as answer by
  Ed Price — MSFTMicrosoft employee
  Tuesday, April 10, 2018 11:49 PM
Hi Bryan,

As mentioned by Uri Dimant, we can find SSMS 17 in the «C:Program Files (x86)Microsoft SQL Server140ToolsBinnManagementStudioSsms.exe» folder, we can create a shortcut to the desktop for it.

If you think it is not convenient, you can also uninstall SSMS 2012, because SSMS 2012 is installed with SQL Server 2012, we will need to use the «Microsoft SQL Server 2012 (64-bit)» item in the uninstall programs list to uninstall it, for
more information, please refer to this case: https://dba.stackexchange.com/questions/55446/how-to-uninstall-sql-server-management-studio-2012

Best Regards,

Teige

MSDN Community Support
Please remember to click «Mark as Answer» the responses that resolved your issue, and to click «Unmark as Answer» if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to
MSDN Support, feel free to contact MSDNFSF@microsoft.com.
- Marked as answer by
  Ed Price — MSFTMicrosoft employee
  Tuesday, April 10, 2018 11:49 PM

Источник

Remove From My Forums

Question
Hi Experts,

Why I always get the error message when creating table in SSMS.

The backend version is not supported to design database diagrams or tables.

Thanks in advance.

Answers

Hi Eric,

Based on my test, I used the SSMS 2014 to connect to the SQL Server 2017. When I right clicked the «Table»>»New»>»Table…» in Object Explorer, I got the same error.
Please see the screenshot:

But if I used the SSMS 2014 to connect to the SQL Server 2012 and did the same operation. The table design page appeared normally.

The error happens when the SQL Server version is newer than the SSMS version you are using.

As workarounds:

1. please use the T_SQL to execute operations instead of GUI.

2. please use the matched or higher version of
SSMS.

By the way, SSMS is free for download. You can download the latest SSMS from the link.

https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-2017

Best Regards,

Emily

MSDN Community Support
Please remember to click «Mark as Answer» the responses that resolved your issue, and to click «Unmark as Answer» if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to
MSDN Support, feel free to contact MSDNFSF@microsoft.com
- Marked as answer by
  
  Thursday, January 17, 2019 4:09 PM

Источник

Varinder Sandhu

SQL, SQL-Tips and Tricks, Varinder Sandhu

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

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

Cause :
The database to which you are connected does not allow schema modification with the Visual Database Tools.

Resolution :
Be sure you are connected to the correct database or Use the correct version SQL Server Management tool.

Compress SQL Server Backup in Right Way
SQL Server – Single Instance vs. Multiple Instances
Effective Database Maintenance and Management – Index Fragmentation
Unable to connect the SQL Server Instance – 26 – Error Locating Server/Instance Specified
SQL Server – How to read the SQL Server Error log files using TSQL

SQL Server, SQL Server Management Tool

Источник

April 6, 2023 by Muhammad Imran

Recently, I was working on one of the databases and I tried to insert a table through SQL Server Management Studio (SSMS) and I came across the following error.

Error:

The backend version is not supported to design database diagrams or tables.

Reproduce Error:

Let me reproduce this error step by step.

Step 1:

Let’s create a new database namely ‘TestDB’ as shown below.

 
CREATE DATABASE TestDB;
GO

Step 2:

Now, lets expand the database TestDB, then right click on the Tables option and then select New and then select Table… as shown below.

Step 3:

This will display the following error.

Solution:

This error occurs when you have the older version (18) of SSMS installed on your device. To check the version installed on your device, navigate to the Help menu and click on About menu in the menu bar as shown below.