Azure Data Factory with Managed private endpoints is failed to connect

Question

I am configuring the Azure Data Factory that reads the data from the storage account and updates the Azure SQL Server.

I have created the Managed private endpoints(manually) for both Storage account & Azure SQL server

Managed private endpoints:

Enabled Interactive Authoring:

and disabled the Public network access on both the Storage account and Azure SQL server.

But, it is failing to connect with the Storage account and Azure SQL server

Azure SQL Server Connection:

Storage Account Connection:

Failed to Connect - Storage Account#: 9972

Failed to Connect - SQL Server#: 22339

Update#1 As suggested in comment, I have associated the linked services with IR

It seems to be Connecting

But, Pipeline works only when I allow

Otherwise, it fails with

The service Principal has permission on the Storage account

Permissions:

Answer 1

I was able to fix this with the following Terraform Code

// Create Private Endpoint for Data Factory Portal
module "pedatafactoryportal" {
    source = "./modules/privateendpoint/"

    resource_group_name = azurerm_resource_group.resource_group.name
    location = azurerm_resource_group.resource_group.location
    name = var.privateendpointdatafactory_portal_name

    subnet_id = azurerm_subnet.endpoint_subnet.id
    private_link_enabled_resource_id = azurerm_data_factory.datafactory.id
    private_dns_zone_name = azurerm_private_dns_zone.datafactoryportalzone.name
    subresource_names = ["portal"]
    resource_name = "portal"

    depends_on = [
      azurerm_data_factory.datafactory, 
      azurerm_private_dns_zone.datafactoryportalzone
    ]
}