This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(28.799999999999997, 39%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBR%3C/text%3E%3C/svg%3E)
Hi.
We have an issue where we get below error. I believe we have set up things correctly but maybe not. Testing connection is successfull and we have added the IP of the on-prem server to the firewall of the Azure SQL Server.
We have validated server, database and user id - all correct.
ERROR:
Operation on target Copy_9wg failed: ErrorCode=SqlFailedToConnect,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Cannot connect to SQL Database: '[OUR AZURE SQL SERVER].database.windows.net', Database: '[OUR DATABASE]', User: '[OUR 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 - 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. (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.),},],''Type=System.ComponentModel.Win32Exception,Message=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=,'
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(134.4, 9%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKM%3C/text%3E%3C/svg%3E)
Hello @Brian Refshauge ,
Thanks for the question and using MS Q&A platform.
As per my understanding, you are seeing connectivity issues from Azure SQL when loading data from On Prem SQL to Azure SQL. You were able to test connection successfully but noticing issue while running the pipeline. Please correct me if I'm not accurate.
We have also noticed that you have already filed a support ticket SR#2202240050001423 and an engineer is looking into it.
By looking at the error message, it seems like firewall related issue. I would recommend looking at this article and see if that helps to overcome the issue - Error 10060: Configure Azure NSG for Azure DB and Azure DW Connectivity
Do check if you Azure SQL has firewall restrictions. If so, you may try Allow Azure services and resources to access this server to YES
Do let us know if that helps or if you get a solution from Support case so that it would help others reading this thread.
Thank you.
Hello @Brian Refshauge ,
We still have not heard back from you. Just wanted to check if the any of the suggestions were helpful to resolve your issue? If it answers your query, please do click Accept Answer and/or Up-Vote, as it might be beneficial to other community members reading this thread. And, if you have any further query do let us know.
Hey,
Based on my understanding it seems the server on which the self hosted IR is set up is unable to access the azure sql database.
In case of a copy activity, it is a necessary scenario that in case if either your source or sink is leveraging a self IR, the self IR should be able to access both source and sink.