Avatar of Harreni
Harreni
Flag for Saudi Arabia asked on

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

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
Microsoft SQL Server

Avatar of undefined
Last Comment
Harreni

8/22/2022 - Mon
ste5an

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

ASKER
Thanks ste5an.
How to download managment studio for 2016 (if it will solve this issue), I tried but I couldn't find anything
SOLUTION
ste5an

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Harreni

ASKER
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.
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23
ASKER CERTIFIED SOLUTION
ste5an

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
Harreni

ASKER
CaptureSQL.PNGI installed everything on my instance and here is a snapshot of my features that are installed.
Where is the SSMS here?
ste5an

It's imho some steps before that. In the main dialog.
Harreni

ASKER
After downloading it again , I got it works finally.
Thanks a lot ste5an.
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.