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. 220.127.116.119: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 18.104.22.1689:1234 address, but not able to telnet using the 22.214.171.1249:(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!!