This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(41.6, 39%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENL%3C/text%3E%3C/svg%3E)
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
Is this error still occurring, or was it a transient error?
It is still occurring
From inside the Sink transformation in the data flow designer, does your test connection work?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(134.4, 9%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKM%3C/text%3E%3C/svg%3E)
Hi @Nemesio Lopez ,
Thanks for reaching out. Could you also please confirm if your dataset uses Self Hosted Integration runtime? The reason I would want to confirm on this because ADF Data flow doesn't support SHIR hence you will have to use a Azure IR.
We look forward to your confirmation.
Thanks
It does not work, attaching image..
Hi KranthiPakala, the datase uses a Managed Virtual Network Runtime
Hi @Nemesio Lopez ,
Sorry for the delay in response and thanks for your details. Could you please confirm if you have created a Private endpoint to Azure SQL DB from your Azure Data Factory and approved the connection? If not could you please try creating an endpoint from your ADF to Azure SQL DB and approve it and see if the test connection works fine? - Please refer to this helpful demo - Managed Virtual Networks and Private Endpoints in Azure Synapse and Azure Data Factory
In case If you already found a solution, would you please share it here with the community? Otherwise, please try above suggestion and see if that helps. In case if that doesn't help, I would recommend to file a support ticket so that a support engineer can take a deeper look into your configuration and help identify the root cause.
Please let us know how it goes.
Thanks
Hi @Nemesio Lopez ,
Following up to see if the issue still persists? If so, could you please try the above suggestion and see if that helps. In case If you already found a solution, would you please share it here with the community? Otherwise, do let us know we will continue to engage to further troubleshoot this.
Thanks
Hi ,
We haven't heard back from you. Just wanted to check if you are you still facing the issue? In case If you already found a solution, would you please share it here with the community? Otherwise, let us know and we will continue to engage with you on the issue.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(179.20000000000002, 77%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGG%3C/text%3E%3C/svg%3E)
I have the same setup on my side, using a Managed Virtual Network Runtime.
The connection was not working inside the dataflow.
What I had to do to fix this issue is starting the debug environment with my Managed Virtual Network Runtime instead of the AutoResolveIntegrationRuntime
I hope it helps :)
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(41.6, 89%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMK%3C/text%3E%3C/svg%3E)
Hi team We are Facing the same issue in Synapse data Flow can anyone let us know the solution of the issue? Thanks