Error while loading data from Azure Data Lake Gen2 to Azure Synapse Analytics using Azure Data Factory

Question

Hi All,

I am getting an error while loading data from Azure Data Lake Gen2 to Azure Synapse Analytics using Azure Data Factory. I am unable what exactly the error is? What permission has to be provided? How?.
This error occurs when I use Polybase method from data factory.

{
"errorCode": "2200",
"message": "ErrorCode=FailedDbOperation,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Please make sure SQL DW has access to ADLS Gen2 account,Source=Microsoft.DataTransfer.ClientLibrary,''Type=System.Data.SqlClient.SqlException,Message=Managed Service Identity has not been enabled on this server. Please enable Managed Service Identity and try again.,Source=.Net SqlClient Data Provider,SqlErrorNumber=105096,Class=16,ErrorCode=-2146232060,State=1,Errors=[{Class=16,Number=105096,State=1,Message=Managed Service Identity has not been enabled on this server. Please enable Managed Service Identity and try again.,},],'",
"failureType": "UserError",
"target": "Copy data1",
"details": []
}

Answer 1

Hi @ImranMaqsood ,

Welcome to Microsoft Q&A forum and thanks for your query.

• Is it a staged Copy? or Direct copy?
• Is it SQL pool or SQL On Demand?

Could you please try the below to see if this helps to resolve your issue.

• Open powershell and use Connect-AzAccount command to connect Azure account.
• Run Select-AzSubscription -SubscriptionId <subscriptionId> (replace subscription ID to your ID) Set-AzSqlServer -ResourceGroupName <your-database-server-resourceGroup> -ServerName <your-SQL-servername> –AssignIdentity (Note: Replace “your-database-server-resourceGroup” and “your-SQL-servername” with your values)
• Above three commands will generate an AAD identity for the SQL server that is hosting Azure Synapse.

Please refer to similar SO thread: https://stackoverflow.com/questions/59240875/manager-identity-error-when-running-a-pipeline-in-data-factory-with-staging-blob

Let us know how it goes.

---

Thank you
Please do consider to click on "Accept Answer" and "Upvote" on the post that helps you, as it can be beneficial to other community members.

Answer 2

I am experiencing the same issue.
Staged copy to SQL pool