Forum Discussion
SSIS Integration Runtime Private Endpoint
Hi,
Our Azure SQL Server is having a private endpoint and we have set "Deny Public Network access" to YES.
So all the traffic from and through the SQL Server databases must go over the private endpoint.
Now we have set up a Azure SSISIR that is linked to the same vnet/subnet. we're using this SSIS IR to get data from SAP on-premise using SSIS and theobald. The Vnet that is used is the same that we use to link the SQL Server and the private endpoints. The vnet is linked to the on-premise network with VPN.
When we execute the Data Factory pipeline that must receive the data through SSIS and the SSIS IR the process always failed with the error message that we need to set the "Deny public network access" to No.
Why is transfer that we do over the SSISIR not traveling over the private endpoint to the SQL Server that is the destination? And how can we fix this that we can set the setting "Deny Public Network access" to Yes?