Can't connect to SQL Server through SSMS remotely Ok, look apologies if this is a really stupid question, but I'm struggling here.

Just started a company and they use VM's hosted externally for SQL Server.  You access the VM by RDP by putting in an IP address and a port number; e.g. 12.34.56.789:1234.

How do I connect to an instance on this server using SSMS on my local machine?  

I've reviewed multiple help articles online.  I notice my SQL Server is set to TCP Dynamic Ports, and not a static port like 1433.  Windows Firewall is turned off so no issue there.  I've checked the netstat -ano and see that TCP is listening on:
[::]:49166 and
I'm able to telnet to the server using the 12.34.56.789:1234 address, but not able to telnet using the 12.34.56.789:(dynamic port address).

Am keen to even try to connect to it through the dynamic port but can't get through to it either.

SQL Browser is on.

Thank you in advance for you help.  Going mad here!!
Windows Firewall is turned off so no issue there. 


There will be some form of firewall operating between the machine and the outside world (unless there is something really wrong with your company's infrastructure setup!) and that is most likely blocking access to the relevant ports for external connections.


  How do I connect to an instance on this server using SSMS on my local machine?


It may be that you cannot access the SQL Server directly at all, in which case you'll need to use tools installed on the VM(s) rather than local copies. It may be that there is a VPN seetup that you can connect through. It may be that there is a route through the firewalls connecting to a specific address+port from your location. In any case you will need to talk to your infrastructure people, we know nothing of your network arrangement so are unlikely to be able to help beyond these generic pointers.