0

I need to let my public IP connect to a database that is located within the same local network.

Ex: MY public IP is: 190.222.222.222 The local IP of that PC is: 1.1.1.4 And this server already has an MSSQL (Localhost) engine. This means that if I connect to the Public IP it automatically calls me the LOCALHOST database engine.

I need that at the time of connecting to the public IP this call / connect to the local server database engine 1.1.1.7

The connection between server 1.1.1.4 and 1.1.1.7 is working. The firewall ports are open

  • 3
    SQL Server localdb does not allow remote connections. Do connect remotely, you need a SQL Server Express instance at a minimum. – Dan Guzman Mar 17 at 21:24
  • I have SQL Server 2017 installed but how do I route the connection to the local IP? – Andres Wilches Mar 17 at 22:45
  • BTW 1.0.0.0/24 is a public IP address range. – danblack Mar 18 at 0:22
1

the proper way - you need run Configuration Manager and check if tcp/ip support enabled for all necessary interfaces.

enter image description here

0

This way I have the configuration of my SQL. But at the time of connecting to the IP Public is calling me the database of the ip 1.1.1.4 (Localhost)

enter image description here enter image description here

  • I thought it some terminology problems, localhost it always - 127.0.0.1, but default port for SQL Server - 1433, so if you do not use port in your connection it could be collisions – a_vlad Mar 18 at 11:07
  • I have configured a different port. Ex 1435. I have done the connection test from the local network and it works correctly But still connects to the local database – Andres Wilches Mar 18 at 11:15

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.