Hi there,

need ideas how to let a Azure Web App connect to a Azure SQL DB (managed by Azure Managed Instance). 

Web App has public network access but no private endpoint:

SQL Managed Instance is added to Azure virtual network/subnet.

So, Web App is facing to the internet only. SQL Server is connected to the internal network only. 

Web App cannot connect to sql instance. 

I tried to create a private endpoint on the managed instance to get it work. But without success.

As I am not too deep into the networking part of Azure I hoped to get help how to approach this. I need to be able to connect the web app to the managed instance. Just creating a private endpoint on the Web App ressource shows a warning that this undermines security. So I am looking for a secure way how to achieve connection from Web App to SQL instance/database.

Thanks in advance.

Additional information:
The sql instance and databases are reachable from in Azure running virtual machines that have network adapters in the virtual network where the sql server is running. It’s only the web app that is not able to connect (most likely because of missing internal network connection). 

Microsoft.Data.SqlClient.SqlException (0x80131904): A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 0 – An attempt was made to access a socket in a way forbidden by its access permissions.)

—> System.ComponentModel.Win32Exception (10013): An attempt was made to access a socket in a way forbidden by its access permissions.

​Hi there,need ideas how to let a Azure Web App connect to a Azure SQL DB (managed by Azure Managed Instance).  Web App has public network access but no private endpoint: SQL Managed Instance is added to Azure virtual network/subnet. So, Web App is facing to the internet only. SQL Server is connected to the internal network only. Web App cannot connect to sql instance.  I tried to create a private endpoint on the managed instance to get it work. But without success. As I am not too deep into the networking part of Azure I hoped to get help how to approach this. I need to be able to connect the web app to the managed instance. Just creating a private endpoint on the Web App ressource shows a warning that this undermines security. So I am looking for a secure way how to achieve connection from Web App to SQL instance/database. Thanks in advance.Additional information:The sql instance and databases are reachable from in Azure running virtual machines that have network adapters in the virtual network where the sql server is running. It’s only the web app that is not able to connect (most likely because of missing internal network connection).  Microsoft.Data.SqlClient.SqlException (0x80131904): A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 0 – An attempt was made to access a socket in a way forbidden by its access permissions.)

—> System.ComponentModel.Win32Exception (10013): An attempt was made to access a socket in a way forbidden by its access permissions.    Read More

​