I’m moving a legacy application using asp.net 3.5 to docker, I was able to make the application run on container. This application connect to a SQL Server hosted on another server (not container). When I try to access some parts of my application that try to connect to SQL Server I’m getting this error (The network path was not found - I’m using a static IP on my connection string). I understand the container cannot find my SQL host on network, I open port 1433 on container, but is not working, tried to set --net=host not working.
How can I fix this, so container can access my external SQL server database that is hosted on another server on my network?