SSMS 17.9 opens database on SQL Server 2014 instead of 2016

Question

I have SQL Server 2014 and I did use it and have some db on it.

Yesterday I installed SQL Server Management Studio 17.9 and when I open it I just see the same db created on SQL Server 2014 (sql 12.0.2000.8).

But I want to create or restore some db that I created on SQL Server 2016 and I cant.

How should I tell SSMS 17.9 to use this path:

C:\Program Files\Microsoft SQL Server2016\MSSQL13.SQL2016SQL2016\MSSQL

Here I installed 2016.

Answer 1

You've created an instance named SQL2016SQL2016.
So you have to add the instance to the servername in the connection window like:

localhost\SQL2016SQL2016

An instance of the Database Engine is a copy of the sqlservr.exe executable that runs as an operating system service. Each instance manages several system databases and one or more user databases. Each computer can run multiple instances of the Database Engine. Applications connect to the instance in order to perform work in a database managed by the instance.

Source: Database Engine Instances