• Register
0 votes

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?

7 5 2
3,870 points

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.


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.

9 7 4
38,600 points

Related questions

2 votes
1 answer 39 views
Problem : I am very new to SQL Server 2008 Management Studio. I have recently connected my SQL Server 2008 Management Studio with Windows authentication. After that I am facing below error "The request failed or the service did not respond in a timely fashion. Consult the event ... to fix above error from past couple of days but I am unable to fix it. Can somebody guide me in fixing above error ?
asked Mar 25 morrisBson 3.2k points
2 votes
1 answer 17 views
Problem: I am new in django I was trying some code to get and post some data. I wrote a code: from rest_framework.views import APIView from rest_framework.response import Response from rest_framework import status from rest_framework import viewsets from profiles_api import ... HTTP method is not allowed for the requested resource (HTTP method POST is not supported by this URL) Can anyone help?
asked Mar 23 LizzyM 6.1k points
0 votes
2 answers 40 views
Problem: I am new, I need help, can anyone help me by filling in the blanks? ________ is used to ensure that data is organized most efficiently in a database?
asked Feb 19 maddi86 5.4k points
1 vote
1 answer 24 views
Problem: Which of the following allows users to add, change, delete, or retrieve data in a database? a) Attribute generation b) Report generation tools c) Data dictionary d) Query wizard tool e) Data manipulation language
asked Mar 23 ArifulIslam 5.7k points