Hi
Bastien NOEL •,
Welcome to Microsoft Q&A forum and thanks for using Azure Services.
As I understand, you are getting an error "A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 2 - Connection was terminated: Connection was terminated)" when connecting from an AKS application to Azure SQL database.
We are sorry about the inconvenience you are currently facing.
In some situations, we found that application reported the following error message: A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 2 - Connection was terminated ). It might be caused when application server reaches CPU throttling, High Memory Utilization.
Also, in AKS, High CPU Reservation (Requests) plus too many pods have very large difference between their CPU Requests and CPU Limits, these pods will be affected by CPU Throttling. To Protect the pods against CPU Throttling the recommendation is to Set their CPU Request equal to the high value of the CPU Limit, only then it will be protected because it will be using Kubernetes QOS Class Guaranteed.
Let us know if above scenario helps in your case.
If not we will look further into the issue. Thanks