I have 2 different systems which are located in 2 different locations and i have developer SQL instance configured in one computer which has static IP address.
One computer, we can call it as C1 for example is connected to Wifi with static IP address(this is the computer where the actual instance/data files are present) and the other computer, we can call it as C2 for example is connected to my mobile hotspot.
Now can i connect C1 using C2 machine which are totally on different networks ? If yes, how can i connect ?
I tried to connect using tcp:<computer name>,port but i was only successful only when both are on same network.
TCP/Ip pipes are enabled with default port as 1433. Can anyone help me here?