Azure SQL Connection through ADF having transient failure
We have build ADF Pipeline where we have a step to connect to Azure SQL and run a query. So the ADF pipeline runs every single day and this step runs almost 98% of the time, but once in a while gets failed with the following error,
|ErrorCode=SqlFailedToConnect,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Cannot connect to SQL Database
Note : This issue gets resolved on restart.
We need a way to have this automated without manual intervention.
We need to find if there is any way to retry if this fails the first time?
Read more here: Source link
