Unable to connect the Azure SQL DB from ADF

Question

Hi All,

I am unable to connect the azure SQL DB from Azure data factory. I am getting below error message, although my linked service is showing connection successful when testing connection to DB. Also I am able to connect to Azure SQL DB manually with same credentials. Also I have increased the DB size . Completely clueless now.

Operation on target Copy_sw1 failed: ErrorCode=SqlFailedToConnect,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Cannot connect to SQL Database:, Database: , 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=A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 0 - No connection could be made because the target machine actively refused it.),Source=.Net SqlClient Data Provider,SqlErrorNumber=10061,Class=20,ErrorCode=-2146232060,State=0,Errors=[{Class=20,Number=10061,State=0,Message=A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 0 - No connection could be made because the target machine actively refused it.),},],''Type=System.ComponentModel.Win32Exception,Message=No connection could be made because the target machine actively refused it,Source=,'

Answer 1

Hi @HarithaMaddi-MSFT ,
I am facing the same issue when trying to create credentials for the External SQL Server Database hosted in Azure VM.
I used the following PowerShell Code Snippet from
create-data-source

Please guide me I am doing anything wrong.