none
Self Hosted Integration Runtime - Copy Data -activity fails RRS feed

  • Question

  • We have created Self Hosted Integration Runtime (IR), which has specific ip-address. Each Connection in Data Factory use this IR. When we run pipeline that use those connections, Lookup-activity use right IP from IR but Copy Data-activity not? So Copy Data -activity fails because our firewall accepts traffic only from IP which is specified in IR. 

    In Copy Data-activity which fails, source is AzureSqlDatabase and sink is AzureBlobStorage. 

    Error message:
    Failure happened on 'Source' side. ErrorCode=UserErrorFailedFileOperation,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Upload file failed at path ****,Source=Microsoft.DataTransfer.Common,''Type=System.Data.SqlClient.SqlException,Message=Error retrieving data from ****  The underlying error message received was: "Cannot open server "****" requested by the login. Client with IP address "This is not IP from IR " is not allowed to access the server... 

    Each connection works when we press "Test connection"-button in Edit Linked Service. Is there some magic properties in IR  that we have missed?
    Tuesday, April 30, 2019 10:45 AM

All replies

  • Can you please let me know what happens when you remove the whitelisted IP and try the test-connection ? 

    Thanks Himanshu

    Friday, May 3, 2019 5:52 PM
    Moderator