Getting this error

Hk 0 Reputation points

ErrorCode=SqlFailedToConnect,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Cannot connect to SQL Database. Please contact SQL server team for further support. Server: 'ABC', Database: 'ABC', User: 'ABBC'. 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=Login failed for user 'ABC'.,Source=.Net SqlClient Data Provider,SqlErrorNumber=18456,Class=14,ErrorCode=-2146232060,State=1,Errors=[{Class=14,Number=18456,State=1,Message=Login failed for user 'ABBC'.,},],'

What are the possible fixes for this?

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
8,050 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Suba Balaji 8,551 Reputation points

    Hi Hk

    Thanks for using MS Q&A portal and posting your query.

    Looks like data factory is not able to access Azure SQL DB. Below is a thread that addresses similar issue, could you please take a look at this and try ?

    Kindly let us know how it goes.


    0 comments No comments