Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

SQL SERVER Error Message: the backend version is not supported to design database diagrams

Posted on 2016-10-02
8
Medium Priority
?
2,013 Views
Last Modified: 2016-10-03
Hi Experts,

Recently, I have downloaded (SQL SERVER DEVELOPER edition 2016) beside (SQL SERVER 2012 Express).
When I right click on any table inside (DEVELOPER edition 2016) to see it in design mode I got this message:
the backend version is not supported to design database diagrams


Thanks a lot In advance.
Harreni
0
Comment
Question by:Harreni
  • 4
  • 4
8 Comments
 
LVL 36

Expert Comment

by:ste5an
ID: 41825254
Yup, you cannot use this feature of SSMS 2016 with your SQL Server Express version.
0
 

Author Comment

by:Harreni
ID: 41825262
Thanks ste5an.
How to download managment studio for 2016 (if it will solve this issue), I tried but I couldn't find anything
0
 
LVL 36

Assisted Solution

by:ste5an
ste5an earned 2000 total points
ID: 41825299
You have it already installed, cause you said you're using SQL Server Developer 2016..

btw, what is the verson of your SSMS? Maybe you have forgotten to install the 2016 version. Just use you install media of the dev edition. Otherwise it could be downloaded here.
0
Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

 

Author Comment

by:Harreni
ID: 41825330
I download it from the given link and when I tried to install it, it gives me this error:

SETUP FAILED
the file directory is corrupted and unreadable 80070570

I move the file to another location on external HDD but same issue still exists.
0
 
LVL 36

Accepted Solution

by:
ste5an earned 2000 total points
ID: 41825338
Download it again.  But as I said, it is also part of your install media.
0
 

Author Comment

by:Harreni
ID: 41825454
CaptureSQL.PNGI installed everything on my instance and here is a snapshot of my features that are installed.
Where is the SSMS here?
0
 
LVL 36

Expert Comment

by:ste5an
ID: 41825463
It's imho some steps before that. In the main dialog.
0
 

Author Closing Comment

by:Harreni
ID: 41826226
After downloading it again , I got it works finally.
Thanks a lot ste5an.
0

Featured Post

Granular recovery for Microsoft Exchange

With Veeam Explorer for Microsoft Exchange you can choose the Exchange Servers and restore points you’re interested in, and Veeam Explorer will present the contents of those mailbox stores for browsing, searching and exporting.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
Windocks is an independent port of Docker's open source to Windows.   This article introduces the use of SQL Server in containers, with integrated support of SQL Server database cloning.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Suggested Courses

577 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question