The backend version is not supported to design database diagrams or tables
Question
Wednesday, January 16, 2019 4:38 PM
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.
All replies (2)
Thursday, January 17, 2019 7:54 AM ✅Answered
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.
/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
Wednesday, January 16, 2019 7:27 PM
What version of SQL Server do you connect to?
SELECT @@VERSION