Azure App Service
Azure App Service is a service used to create and deploy scalable, mission-critical web apps.
connect on premise database with azure web app
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(307.2, 80%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAL%3C/text%3E%3C/svg%3E)
Albin Lukose
45
Reputation points
I have an asp.net core web app which is containerized using docker
The app is connecting to a SQL Server, using connection string passed to the docker during deployment.
Th docker image is deployed in azure as a web app.
The connection string is passed as environment variable.
The issue is:
The database I am trying to connect is an on premise database.
So I have created a hybrid connection from my app. The endpoint is the device in which SQL server is installed and the port 1433 .
Endpoint:[MachineName:1433] Name:hybridtest,namespace:bus1433
Installed Hybrid connection Manager on other device and the status is showing as connected.
So I deployed the app in azure and passed this environment variable as connection string
"SqlConnection": "Server=<ip-adress|MachineName>,1433; Initial Catalog=MYDB; User ID=sa;Password=PWD;TrustServerCertificate=True;"
ip-address of the sql servermachine/Device Name
It's not working. How can I resolve this
Azure App Service
{count} votes
-
VenkateshDodda-MSFT 25,241 Reputation points Microsoft Employee Moderator2024-03-20T07:56:46.8333333+00:00 @Albin Lukose Thanks for reaching out to Microsoft Q&A, apologize for any inconvenience caused on this.
Are you trying to run your application on Windows based Container webApp or Linux based Container webApp?
If you are trying to host it on windows container-based app service, then it is not supported as mentioned in this documentation here.
Hope this helps, let me know if you are still having any further questions on this.
-
Albin Lukose 45 Reputation points
2024-03-20T19:52:04.4366667+00:00 @VenkateshDodda-MSFT .It's a Linux based container. This is my base image.
FROM mcr.microsoft.com/dotnet/aspnet:8.0-alpine AS finalI have followed these steps for the hybrid connection. and it's showing connected in Hybrid connection Manager.
https://learn.microsoft.com/en-us/azure/app-service/app-service-hybrid-connections.
Is there any way I can check connectivity between my web app and on premise SQL-Server. Is there any commands to ping from the docker container to my local machine to check connectivity ?Is my connection string format is right?
-
VenkateshDodda-MSFT 25,241 Reputation points Microsoft Employee Moderator
2024-03-21T11:05:03.7333333+00:00 @Albin Lukose Thanks for you response you can do a tcpping from the ssh to the on-prem sql server and check. Refer to this blog post on how to install tcpping on Linux App Service.
-
VenkateshDodda-MSFT 25,241 Reputation points Microsoft Employee Moderator
2024-03-26T04:10:29.1133333+00:00 Hello @Albin Lukose ,
Following up to see if you have a chance to check my previous response and helped. Do let us know if you have any further questions on this.
Sign in to comment
Sign in to answer