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

Posted on 2016-10-02
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.
Question by:Harreni
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 4
LVL 34

Expert Comment

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

Author Comment

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
LVL 34

Assisted Solution

ste5an earned 500 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.
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.


Author Comment

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

the file directory is corrupted and unreadable 80070570

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

Accepted Solution

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

Author Comment

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?
LVL 34

Expert Comment

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

Author Closing Comment

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

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SQL Server how to create a DYNAMIC TABLE? 11 50
Removing SCCM 2016 4 48
Sql server query 8 20
*** Windows Server 2012 Websites Set Up *** 17 26
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

737 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