A great god, and my computer has sql2016 and sql2017, after I install the SSMS to open the connection is really 2016 libraries, how to get ah

CodePudding user response:

Are you even the local database or a remote database?

CodePudding user response:

Are you even the local database or a remote database?
Check if it is a remote database, you version is on a remote server database version,
If the local database, you check service is started in 2016 or 2017,

CodePudding user response:

My connection is local database, because of the need to restore a backup, 2017 sql2016 of reduction

CodePudding user response:

reference qq_39592382 reply: 3/f

my connection is local database, because of the need to restore a backup, 2017 sql2016 reduction is not the

That you take a look at your service in the start is the version of the service, if you two are installed should be two different services

CodePudding user response:

, or can't

CodePudding user response:

reference 5 floor qq_39592382 reply:

, or can't

Banned lower version of SQL server services, your box out just agent function

CodePudding user response:

You in configuration manager to open the SQL Server database engine (MSSQLSERVER2017) service,
More solid column on the same machine connected to the real name, such as your local address is 127.0.0.1, so when connecting SQL2017 server is written to 127.0.0.1 \ MSSQLSERVER2017; Because SQL2016 solid column is the default database need not fill in the instance name, lose IP address can be directly,