SSMS 17.9 opens database on SQL Server 2014 instead of 2016
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.
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
- Math.Sin() gives incorrect value
- How to run my python script when the sunOS is start booting
- Express-session: not resetting cookie expiration on each request
- Getting a stack overflow exception when normalizing a vector
- Edit default summary function in R gives error for multiple variables
- What was a For loop? Why isn't it needed in R?
- How to use download button in shiny and save results in various formats (csv, texte, pdf, spss...)?
- Why are there two assignment operators, `<-` and `->` in R?
- lm()$assign: what is it?
- How to get the value of list(...) in R and S functions
- Design matrix for MLM from library(lme4) with fixed and random effects
- how to generate elements not included in my sample
- Create a matrix with gradually changing values without a for loop
- Emacs ESS and S-plus ( S+ ) 8.1 compatability
- How to lag date-index in a time-series in R?
- Nonlinear regression in R / S
- Calling R from S-Plus?