Azure Data Factory On Premise Copy Error RRS feed

  • Question

  • Mashup"Type=Microsoft.Mas..data protection operation was unsuccessful. This may have been caused by not having the user profile loaded for the current thread's user context which may be the case when the thread is impersonanting.Sources, "Type=Microsoft.Mashup.Evaluation.Inter...

    Thats all I can see into the error I have the gateway provisioned successfully dont now whats causing this error When I try to create a pipeline in Chrome I get invalid credentials error not sure whats causing this to have two different errors.</span>

    Wednesday, January 3, 2018 6:18 PM

All replies

  • hi there, Could you provide us more context ? What were you trying to do when this happened specifically ? Was it done via portal , Azure CLI or which medium ? 

    Wednesday, January 3, 2018 6:24 PM
  • I was building the pipeline using the ADF between a on permise sql server where the gateway is already configured and with the azure data warehouse, whenever I enter on permise details by selecting the SQL Server I get the error

    I was doing  this using the ADF, Copy feature

    • Edited by testuser421 Wednesday, January 3, 2018 6:29 PM
    Wednesday, January 3, 2018 6:28 PM
  • Hmm looking at different documentations, this seems to be a user profile issue in the configuration between SQL and ADF, Have you performed the step mentioned here : "Create and ecnrypt a SQL Server Linked Service": https://docs.microsoft.com/en-us/azure/data-factory/tutorial-hybrid-copy-powershell 

    the above tutorial includes the step by step guide on creating a pipeline, and testing the connectivity between the SQL and ADF as well. I'd suggest looking into the article since it could be a misconfig  in the setup process.

    Wednesday, January 3, 2018 6:58 PM
  • Just wanted to confirm one thing If I configure the IR Gateway into the On-premise machine, then which Type of authentication I need to use Windows or Basic, Apparently I was using SQL Auth. 
    And Also After setting the credentials will I be able to connect to the On-Premise Server using the Copy feature?
    Thursday, January 4, 2018 8:11 AM
  • How can I achieve this using the Copy Preview, feature???
    Thursday, January 4, 2018 12:31 PM
  • Hi there, So using a windows user account names the same as the windows account may do the trick. This is a similar case but with a storage account rather: https://social.msdn.microsoft.com/Forums/en-US/2ffa859b-e9ba-4364-9ca0-07c0f1c51fa4/writing-to-azure-file-storage-through-data-gateway?forum=AzureDataFactory 

    Have you also checked this post by any chance ? https://azure.microsoft.com/en-us/blog/simple-and-reliable-data-movement-with-azure-data-factory-copy-wizard/



    Thursday, January 4, 2018 5:14 PM
  • Yeah I have checked this  https://azure.microsoft.com/en-us/blog/simple-and-reliable-data-movement-with-azure-data-factory-copy-wizard/ link but I am getting the same error when setting up the on premise sql server details.
    Thursday, January 4, 2018 7:07 PM
  • I Have created the linked services and also created the pipeline to test out the table, but it gives me below error:-

    Source:SQL side: Integration Runtime (Self-hosted) Node Name=SQL,ErrorCode=UserErrorFailedToConnectToSqlServer,'Type‌​=Microsoft.DataTrans‌​fer.Common.Shared.Hy‌​bridDeliveryExceptio‌​n,Message=Cannot connect to SQL Server: 'SQL', Database: 'dev', User: 'test'.,Source=Microsoft.DataTransfer.ClientLibrary,''Type=S‌​ystem.ComponentModel‌​.Win32Exception,Mess‌​age=The user name or password is incorrect,Source=Microsoft.DataTransfer.ClientLibrary,

    I have double checked the gateway and all looks well, have also tested the diagnostics setting and it also passes the test of the user which I am using in my linked services, not sure where I am failing.

    Friday, January 5, 2018 10:05 AM
  • Looking at the error message you received, it is most likely Firewall rules/settings that are preventing you from reaching the SQL server, I'd recommend checking this documentation to allow the specific required ports in the firewall: https://docs.microsoft.com/en-us/azure/data-factory/create-self-hosted-integration-runtime
    Tuesday, January 30, 2018 4:51 PM