jeudi 18 décembre 2014

SSMS can't connect to database hosted in a remote server which uses a specific port


We have a customer who has a Windows Server hosted in a IP such as 10.1.1.100:3200.


His database has no instance, and it is under 1433 port.


enter image description here


Now I am trying to connect to customer's database, from my SSMS installed in my workstation.


I can't connect to his SQL Server with SSMS. I have tried 10.1.1.100, 10.1.1.100:3320, 10.1.1.100,3320, 10.1.1.100:3320,1433. None works.


enter image description here


With SSMS, how can I connect to a remote SQL Server (1433 port) hosted in a Windows Server that uses a different (3200 port)?





Aucun commentaire:

Enregistrer un commentaire