This is partway setup, but not sure what I've been asked to achieve to 100% possible.
1 server
2 instances of SQL Server
1 internal IP for each sql instance
1 external IP for each sql instance
Both instances are installed and working for remote access from a seperate IP, so to connect via SSMS for example just type in the external IP, user, password and it connects.
SQL Instance 1
Internal IP: 192.168.0.9
Using above IP from the actual server the two instances are on, this connects as expected
SQL Instance 2
Internal IP: 192.168.0.10
Again connecting using above IP w/ correct username and password, from the SAME box the two instances are running from works fine
If you try to connect to Instance 2 from another machine on the same network, then it points to SQL instance 1 instead of 2. The only way to connect is to use the IP\InstanceName
Is it possible to have them be accessible from their own IP if they are setup on the same box, or do you HAVE to use the instance name. It works fine from the box the instances are installed on, just not from other machines on the network