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?

Improve this question
4
  • 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, 2019 at 0:14
  • Sorry about late response. Two servers, two different instances
    – Pedro Cury
    May 7, 2019 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, 2019 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, 2019 at 14:22

1 Answer 1

Reset to default
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.

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

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