[Company Logo Image] 

Home Up Contents Coffee Break Credits Glossary Links Search

 
SSMS This backend version is not supported to design

 

 

Home
Analysis Services
Azure
CLR Integration
High Availability
Open Source
Security
SQL Server 2008
SQL Server 2012
SQL Server 2014
SQL Server 2016
SQL Server 2017
SQL Server 2019
Tips
Troubleshooting
Tuning

SSMS This backend version is not supported to design.


Applies to: Microsoft SQL Server 2022, SQL Server Management Studio v18.12.1 and v19.

Date created: December 21, 2022.

Date updated: September 18, 2023.
 

Problem Description.
 

After installing SQL Server 2022 on an Azure Virtual Machine, we installed SQL Server Management Studio (SSMS) v18.12.1 and tried to create a table using table designer on SSMS and received the following error message:
 

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

 

 

Workaround/Solution.


Whenever you receive this error, download the latest version of SSMS.

At the moment we are writing this web page SSMS 18.12.1 was the latest update (not in preview) of SSMS, so we were surprised to receive this error.

We uninstalled SSMS 18 and proceeded to install the latest update for SSMS v19 and we were able now to successfully use the table designer in SSMS.

For better user experience, always install the latest version of SSMS from here.

 

 

 

.Send mail to webmaster@sqlcoffee.com with questions or comments about this web site.