• Register
0 votes
725 views

Problem :

Currently I am trying to add the table to the newly created database through SQL Server Management Studio. But I get the below error:

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

I am very new to SQL Server Management Studio. How can I resolve the above error?

by (3.9k points)

Please log in or register to answer this question.

1 Answer

0 votes

Solution :

This is very commonly reported as the error due to the use of the wrong version of SSMS(Sql Server Management Studio). You must use a version which is designed for your database version. To ease your task you can use below command to check which version of the sql server you are currently using.

select @@version 

This version is reported to user in a way that is easier to interpret for him than that shown in a Help About in SSMS.

Using the newer version of SSMS than the database version you are using is generally error-free, it is always backward compatible.

OR

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

by (38.6k points)

Related questions

+2 votes
1 answer
19 views asked Mar 23, 2020 by LizzyM (6.1k points)
0 votes
1 answer
0 votes
1 answer
12 views asked Oct 26, 2020 by miki (1.9k points)
0 votes
1 answer
12 views asked Oct 26, 2020 by miki (1.9k points)
0 votes
1 answer
15 views asked Oct 27, 2020 by miki (1.9k points)
0 votes
1 answer
14 views asked Oct 27, 2020 by miki (1.9k points)
0 votes
1 answer
...