SSMS 18 gives error This backend version is not supported to design database diagrams or tables

Question

SSMS 18.12.1 is the latest version right now. When I try to design a table that is in Developer Edition 2022 or Express Edition 2022 I get the error:

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

All the solutions say that is caused by the SSMS version being older than the database version. But there isn't a newer version of SSMS than 18.12.1.

Can you not use SSMS with SQL Server 2022? What gives? Do I need to revert to an older database version?

Thanks for any help,

Michael

Answer 1

Hi @Michael D ，

There is still a SSMS 2019 Preview 3 version, it is now available and is the recommended version of SSMS for SQL Server 2022

Download SQL Server Management Studio (SSMS) 19 (Preview)

-------------

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Thank you! That worked! I didn't want to try the version 19 since it was only a preview. But I guess that was what I needed. It now can view records and design, etc.

Michael

Answer 3

At the moment I installed SSMS 19.0.2 version, which is, for now, the latest general availability (GA) version, and the problem disappeared, you can design tables as you wish, on a remotly SqlServer 2022 runed on a docker on linux.