question

JohnAherne-6191 avatar image
0 Votes"
JohnAherne-6191 asked NandanHegde-7720 commented

ADF Copy - Cannot find server, but linked service and preview data work

Hi All,

I am trying to copy data to an Azure SQL Database using ADF copy. The linked service works, it's using the ADF managed identity to connect, and I can preview data on the Azure SQL Database in my dataset.

However, the copy activity throws an error saying it cannot find the server (error below).

Any ideas what I am missing?

Thanks!


 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 - A connection attempt failed because 
 the connected party did not properly respond after a period of time, 
 or established connection failed because connected host has failed to respond.),
 Source=.Net SqlClient Data Provider,SqlErrorNumber=10060,Class=20,ErrorCode=-2146232060,State=0,
 Errors=[{Class=20,Number=10060,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.


azure-data-factoryazure-sql-database
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @JohnAherne-6191 ,

Could you please post the error number from the error?

Meanwhile please check the link as it might help you fix the error.

Thank you.


1 Vote 1 ·
JohnAherne-6191 avatar image JohnAherne-6191 SubashriVasudevan-1752 ·

The error number is in my comment - 10060.

0 Votes 0 ·

1 Answer

NandanHegde-7720 avatar image
0 Votes"
NandanHegde-7720 answered NandanHegde-7720 commented

Hey,
Can you please clarify whether the source in copy activity is leveraging any integration runtime?
Based on the above scenario, it seems to be the case. So you need to make sure that the Azure sql database is accessible from the server hosting the ir. That should resolve your issue

· 5
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

The source is an on prem SQL Server using a self hosted IR. The sink is the Azure SQL db that uses the autoresolveintegrationruntime.

As I said in my comment - The linked service tests successfully, and I can preview data in datasets with no issues for both source and sink.

0 Votes 0 ·

Hey @JohnAherne-6191 ,
Please log in into the IR server and try accessing the Azure SQL database from that server :)

In case of linked service, the Azure SQL database has Azure IR so the test connection is success but in case of a copy activity with either source or sink leveraging the IR, both the sources should be accessible from the IR.

Hope this statement clarifies the issue.

So to debug, try logging into the IR server and check whether you are able to connect to the Azure SQL database

1 Vote 1 ·

Thanks Nandan - That's good info!

I don't have access to the IR directly, so will need to reach out to our engineering team.

0 Votes 0 ·

Yup, that was it. The IR couldn't access the Azure DB. Thanks!

0 Votes 0 ·
Show more comments