Networksql serverwindows-server
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?
With TCP, you can only have one process listening on each IP/port pair.
This applies to SQL Server. The first instance you start binds itself to listen on your_ip:1433, then when you start the second, the OS will not allocate the socket to the the new instance of SQL Server, because it has already allocated that listener socket to your first SQL Server instance. If you look in your error logs, you will see a "socket already in use" error of some sort when you start up the second instance.
If you have multiple physical or logical NICs you should be able to bind the SQL Server instances to the same port on different IP addresses.
have fixed sqldwdev01 the reason I couldn't connect to UAT instance is because of a couple of reasons
i started sql browser and now can connect using sqldwdev01\uat
Best Answer
Solved that by changing SQL port on SQL Server Configuration Manager, but you'll always have to specify the port for every connections that is different from the standard 1433 port. If you have an APP, you'll also have to change the connection string method to set up a different port or work the code to get it from an external file.