What order of installation I must follow and which versions for visual studio, SQL server and SSMS?

Question

0.00/5 (No votes)

See more:

SQL-Server-2016

VS2017

Error while installing SQL Server 2016 Developer Edition on a laptop that has Visual Studio 2017 Community version

What I have tried:

I installed Visual Studio 2017 Community version and then SQL Server 2017 successfully. While installing SSMS - I got some compatibility error.

After that I tried 3 times to properly install SQL Server again but failed due to Multiple Instances already available. Now I have unistalled all the SQL Server instances and Visual Studio. I want to start fresh installation. How do I do that?

Posted 18-Sep-17 3:13am

Member 13415725

Updated 18-Sep-17 3:59am

Add a Solution

Comments

Richard MacCutchan 18-Sep-17 9:34am

Read the installation instructions for each product first; it should tell you what you need.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2017-09-18T03:59:00

Solution 1

I always install SQL server first, then Visual studio - the reason is that VS uses SQL, so if it's already installed, it doesn't add it's own version. I've had problems with VS before after installing SQL "over the top" of it.

SSMS installs as part of SQL Server, so that shouldn't be a problem.

Posted 18-Sep-17 3:59am

OriginalGriff

Comments

AnvilRanger 18-Sep-17 16:32pm

Unless you are installing SQL 2014 or later. From that version SSMS is now a separate install.

OriginalGriff 18-Sep-17 16:46pm

My hosting service hasn't upgraded from 2012 SP1 yet, so I haven't either!