Getting this error

Hk 0 Reputation points
2023-08-28T20:22:49.3133333+00:00

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
    2023-08-29T04:39:55.6166667+00:00

    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 ?

    https://learn.microsoft.com/en-us/answers/questions/950724/adf-linked-service-system-managed-service-identity

    Kindly let us know how it goes.

    Thanks

    0 comments No comments