Connectivity from ADF to Azure sql fails very often but not always

Jordi Frijters 5 Reputation points
2023-10-05T13:42:55.5766667+00:00

Since 2 days we experience multiple failures in ADF connectivity to Azure SQL. We perform multiple connection at the same time. Some succeed, some fail. We use managed service identity and user has appropriate permissions. Worked for years without issues and suddenly multiple days of failures

full error (partly dutch) below

ErrorCode=SqlFailedToConnect,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Cannot connect to SQL Database. Please contact SQL server team for further support. Server: 'XXX.database.windows.net', Database: 'XXX', User: ''. Check the linked service configuration is correct, and make sure the SQL Database firewall allows the integration runtime to access.,Source=Microsoft.DataTransfer.ClientLibrary,''Type=System.Data.SqlClient.SqlException,Message=Er is een verbinding met de server tot stand gebracht, maar vervolgens is er een fout opgetreden tijdens de handshake voorafgaand aan de aanmelding. (provider: TCP Provider, error: 0 - De opgegeven netwerknaam is niet langer beschikbaar.),Source=.Net SqlClient Data Provider,SqlErrorNumber=64,Class=20,ErrorCode=-2146232060,State=0,Errors=[{Class=20,Number=64,State=0,Message=Er is een verbinding met de server tot stand gebracht, maar vervolgens is er een fout opgetreden tijdens de handshake voorafgaand aan de aanmelding. (provider: TCP Provider, error: 0 - De opgegeven netwerknaam is niet langer beschikbaar.),},],''Type=System.ComponentModel.Win32Exception,Message=De opgegeven netwerknaam is niet langer beschikbaar,Source=,'

Azure SQL Database
Azure Data Factory
Azure Data Factory

An Azure service for ingesting, preparing, and transforming data at scale.

0 comments No comments

3 answers

Sort by: Most helpful
  1. Jordi Frijters 5 Reputation points
    2023-10-06T10:27:50.7666667+00:00

    Issue found and solved. There was a server migration being tested and the integration runtime had two instances on two identical servers on two different networks. Integration runtime showed no issues but did fail because it couldn't resolve the endpoint sometimes. a bit weird why it did not fail at all. But issue solved, thanks.

    Was this answer helpful?

    1 person found this answer helpful.

  2. Jordi Frijters 5 Reputation points
    2023-10-05T14:52:58.8733333+00:00

    HI Alberto,

    looking at the number of failures past 2 days compared to the previous 2 years is comparing very much with nothing. So it must be something is going on. I can't find any outages however.

    I will look into the timeout setting for the linked service. Retry policy could help indeed

    Was this answer helpful?


  3. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    1 deleted comment

    Comments have been turned off. Learn more

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.