I'm trying to connect to a SQL Server hosted on a VM from an Azure Container App. Both are on the same VNET.
I get the "A network-related or instance-specific error occurred while establishing a connection to SQL Server" error when using the SQL instance name.
It looks like the Container App is not able to resolve instance name. Am I missing something ?
Tried using the private IP address of the SQL VM in the connection string and it worked fine.
