Hi @GarrySingh-4786,
Welcome to Microsoft Q&A forum and thanks for reaching out. In addition to @Nandan Hegde 's response, please see below related information:
By looking at the error message and the error code, below could be the possible root case and resolution for the issue.
Error code=40615
- Possible root cause:
ADF Azure IR unable to connect to Azure SQL server with firewall enabled. IP address mentioned in the error message has not been whitelisted. - Possible resolution/workaround:
a). As the Azure IR IP Ranges gets updated weekly basis, new Azure IP range of the region should be whitelisted if this error is noticed. For more info about Azure IR IP range please refer to this doc : Azure Integration Runtime IP addresses: Specific regions
b). Another option is to Turned OFFAllow all Azure Services in SQL Server firewall Settings
. In case if your corporate policy don’t allow you to turn off Allow Azure Services in SQL Server Settings, then you will have to create Azure IR within managed Virtual Network and establish a Private Endpoint connection from ADF to Azure SQL Server and then used Managed VNET Integration Runtime to run the pipeline.
Additional information:
Here are couple of helpful resources related to connectivity issues and ADF Managed Virtual Network with Private Endpoint.
- Troubleshooting connectivity issues and other errors with Azure SQL Database and Azure SQL Managed Instance
- Azure SQL Database and Azure Synapse IP firewall rules
- Managed Virtual Networks and Private Endpoints in Azure Synapse and Azure Data Factory
Hope this information helps. Do let us know if you have further query.
----------
Thank you
Please do consider to click on "Accept Answer" and "Upvote" on the post that helps you, as it can be beneficial to other community members.