0

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?

  • 3
    The question is a little unclear - do you have two separate servers running a SQL Server instance or a single server running multiple SQL Server instances? – HandyD May 7 '19 at 0:14
  • Sorry about late response. Two servers, two different instances – Pedro Cury May 7 '19 at 12:27
  • Okay, so you want to access databases on Server #2 from queries on Server #1, is that what you're trying to achieve? – HandyD May 9 '19 at 0:32
  • Not exactly. In the company I work for they unnecessarily bought a second server. So in order to put it to use, we'll split our clients's databases into both of them according to the type of application. I had to change SQL port then, because both servers was under the same external IP – Pedro Cury May 9 '19 at 14:22
0

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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.