Two physical servers with sql server on same network

IS there a way I can remotely access sql server DB having two different servers in the same network/public IP? The first Server is configured to listen to 1433 port but we make the connections using No-Ip provider. As both servers will be under the same DNS, how can I configure my app/sql server to connect to the DB in the second server?