Get information by connecting to an external sql server

Question

I made a simple web app using the free plan.
It's a simple printing app that organizes and displays customer data.

Since the customer's data is huge, they exist on an externally configured sql server. They are exposing the IP address and port.

I need to connect to the sql server provided by the web app, get information, and process it.

I have successfully deployed the web app, but I am unable to connect to the external server.

Basically, the outgoing port seems to be blocked.
how do i set it up?

Answer 1

@네오디시젼스 주식회사 Thanks for reaching out. As per the shared description i have understood that you are trying to connect your web app to an external sql server

• Hybrid connections: If your external sql server is on on-prem you can install an exe on one of your on-prem servers. This exe will establish a tunnel between your app service and your database. This is by far the simplest and quickest way to get going. For more information and how to set up you can refer to this Q&A thread
• You can leverage the private endpoints if you want to connect to your sql server database privately from the app service.
• You can use the Azure App Service Virtual Network Integration to deploy your application inside a VNet and this enables access from your application to other services, VMs, or databases that are deployed inside the same Vnet.

Feel Free to reach back to me if you have any further questions on this.