DataFlow error in Data Factory

Nemesio Lopez 6 Reputation points
2021-03-18T23:12:48.893+00:00

I got this error when trying to run a pipeline that include just a DataFlow task, the database uses a private endpoint and the dataset used is working in other pipelines, but we got an error when we test the connection in the Sink element of the DataFlow. The linked service uses a VNIntegrationRuntime, and it is working also, we only get this error in the DataFlow. {"StatusCode":"DFExecutorUserError","Message":"Job failed due to reason: at Sink 'SinkGen': java.lang.RuntimeException: Cannot connect to SQL database: 'jdbc:sqlserver://XXX.database.windows.net:1433;database={XXXX}', 'User: XXX'.[SQL Exception]Error Code:47073, Error Message: Reason: An instance-specific error occurred while establishing a connection to SQL Server. Connection was denied since Deny Public Network Access is set to Yes (https://learn.microsoft.com/azure/azure-sql/database/connectivity-settings#deny-public-network-access). To connect to this server, use the Private Endpoint from inside your virtual network (https://learn.microsoft.com/azure/sql-database/sql-database-private-endpoint-overview#how-to-set-up-private-link-for-azure-sql-database). ClientConnectionId:317299fa-411d-40d7-a642-deb00781ef8f, error stack:shaded.msdataflow.com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:259)\nshaded.msdataflow.com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF(tdsparser.java:256)\nshaded.msdat","Details":"at Sink 'SinkGen': java.lang.RuntimeException: Cannot connect to SQL database: 'jdbc:sqlserver://XXX.database.windows.net:1433;database={XXX}', 'User: XXX![79402-errordf.jpg][1]'.[SQL Exception]Error Code:47073, Error Message: Reason: An instance-specific error occurred while establishing a connection to SQL Server. Connection was denied since Deny Public Network Access is set to Yes (https://learn.microsoft.com/azure/azure-sql/database/connectivity-settings#deny-public-network-access). To connect to this server, use the Private Endpoint from inside your virtual network (https://learn.microsoft.com/azure/sql-database/sql-database-private-endpoint-overview#how-to-set-up-private-link-for-azure-sql-database). ClientConnectionId:317299fa-411d-40d7-a642-deb00781ef8f, error stack:shaded.msdataflow.com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:259)\nshaded.msdataflow.com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF(tdsparser.java:256)\nshaded.msdataflow.com.microsoft.sqlser"} [1]: /api/attachments/79402-errordf.jpg?platform=QnA

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,160 questions
{count} vote

1 answer

Sort by: Most helpful
  1. Muskan Khatnani 5 Reputation points
    2023-08-09T15:20:08.0533333+00:00

    Hi team We are Facing the same issue in Synapse data Flow can anyone let us know the solution of the issue? Thanks

    1 person found this answer helpful.
    0 comments No comments