Network connect to a local IP address from a static global IP address?
Is there a possible way to connect to a local SQL server on a static global IP?
Let me elaborate.
Assume that there is a server with a static global IP of 12.345.678.90 which refers to a certain windows based PC which in turn hosts a Microsoft SQL Server. Said server can be accessed remotely.
The issue is the need to connect to another SQL server hosted on another PC on the same network with a "static local IP" of 192.168.1.100.
Is there a way to connect to that server using a similar syntax to 12.345.678.90/192.168.1.100?
Just tell the router that any connection on port 12345 of 12.345.678.90 should be sent to 192.168.1.100 and the port number on which the other SQL server is listening. Anyone on the outside wanting to connect to the other SQL server should connect to 12.345.678.90:12345.