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 ...

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:

enter image description here

What’s wrong here?

kkuilla's user avatar

kkuilla

2,2063 gold badges33 silver badges37 bronze badges

asked Aug 5, 2014 at 19:08

JensOlsen's user avatar

2

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's user avatar

BPX

8881 gold badge8 silver badges20 bronze badges

answered Aug 5, 2014 at 19:14

Gary Walker's user avatar

Gary WalkerGary Walker

8,5753 gold badges18 silver badges41 bronze badges

9

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.

enter image description here

Jeremy Caney's user avatar

Jeremy Caney

6,83354 gold badges48 silver badges74 bronze badges

answered Nov 17, 2022 at 13:14

Clayton A. Santos's user avatar

2

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

MikeSNP's user avatar

MikeSNPMikeSNP

1031 gold badge2 silver badges4 bronze badges

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

GLENN SAHLIN's user avatar

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

Chinthaka Sandaruwan's user avatar

1

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

Muarucha's user avatar

0

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

Ehsan's user avatar

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

Petter Friberg's user avatar

answered Feb 27, 2015 at 15:50

Alison Coughtrie's user avatar

Источник
  • 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

Источник

Solution 1

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.

Solution 2

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.

Solution 3

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
)
)

Comments

  • 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:

    enter image description here

    What’s wrong here?

  • I ran the query and this is what got returned: Microsoft SQL Server 2012 (SP1) — 11.0.3000.0 So yea — I see I need to update my SMSS to 2012. However every time I run the exe offered at: microsoft.com/en-us/download/confirmation.aspx?id=29062 I get a message saying no updates are available. I cannot find any way to update SMSS — even though it sounds insanely dumb.

  • Always include the exact error message. You should be able to install SqlExpress 2012 (to get SMSS). You might be able to just do a reconfigure or repair install to make sure SMSS 2012 is running. You also might have 2008 & 2012 and are running SMSS 2008 when you could be using 2012

  • I launch the exe file. I click «Upgrade from SQL Server 2005, 2008, or 2008 R2». Then I get the message: «There are no updates for SQL Server found online»

  • I think this is supposed to be an informative message, you should be able to continue with the install IIRC

  • Ahh finally I got the 2008 version removed and yes you were right — the 2012 version was already installed. Works now — thanks!

  • Also, if you let Visual Studio create the database for you with Code First then that can cause the error also when using SSMS.

  • I got this error when the sql server was of version Microsoft SQL Server 2014 — 12.0.2000.8 (X64) and I used ssms 2012 version 11.0.2100.60. I only get the error when right clicking a table and then click «Design». So to see which columns the table has, I have to expand the +, which works. Is my ssms confused in some way?

  • Just install multiple version of SQL server management studio. Sometimes you’ll run into a situation where some of your DB’s are installed with SQL Server 14, 12, 11 etc. So instead of upgrading your only install of management studio, have multiple installed.

  • Yep I had some how loaded a second older version of sql management studio … Probably should uninstall that.

Recents

Related

Источник
  • 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

  • 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

Источник

Понравилась статья? Поделить с друзьями:
  • This application has no configured error view so you are seeing this as a fallback
  • This application has encountered a critical error перевод
  • This application has encountered a critical error недостаточно памяти для обработки команды
  • This application has encountered a critical error wow как исправить
  • This application has encountered a critical error wow error 132