SQL Management Studio only connects remotely without the instance

Asked

Viewed 68 times

0

While trying to make a connection with a first remote SQL, I realized that my Management Studio could not connect using the instance, as follows:

tentativa de conexão com a instância

After that attempt, I removed the instance, and since this server only has one SQL, it took the default system, and logged out normally without the instance:

conexão realizada com sucesso.

Now my problem is that I am trying to connect to a database that has multiple instances, and my SQL generates the following error:

teste com o outro servidor, com instancia

Assuming I test without the instance, it generates a login error as it does not find my user and password in the default database.

I already changed the version of my Management Studio to 2014 (I was using 2017) I already formatted my computer last night I installed again Management Studio 2017

And so far, I’ve had absolutely no success. Has anyone been through the same problem, or would have some idea of a solution?

  • Experiment as follows: 192.99.140.108\MSSQLSERVER2012:1433, putting the door at the end.

  • João, I got a invalid Connection string error when trying to insert the port the way you mentioned it

No answers

Browser other questions tagged

You are not signed in. Login or sign up in order to post.