What is the specified terraform subresource_name for Azure SQL Managed Instance private endpoint?

Question

What is the specified terraform subresource_names for Azure SQL Managed Instance private endpoint?

We were told Azure SQL Managed Instance will be coming out of preview this quarter. Error & Code snippets below...

CreateOrUpdate: Failure sending request: StatusCode=400 -- Original Error: Code="PrivateEndpointCreationNotAllowedAsSubnetIsDelegated" Message="Private endpoint .... -subnet is delegated." Details=[]

(not really in powershell)

resource "azurerm_private_endpoint" "......" {

  provider                     = azurerm....subscription  

  name                = "${var..."

  location            = var.location

  resource_group_name = var.resourcegrp

  subnet_id           = azurerm_subnet.....id

  private_service_connection {

    name                           = "......"

    private_connection_resource_id = azurerm_mssql_managed_instance.mi.id

    subresource_names              = ["managedInstance"]

    is_manual_connection           = false

  }

  lifecycle {

    ignore_changes = [tags]

  }

}

Answer 1

Hi @Brian E Zupanc ,

Looks like your subnet it's already delegated to another azure service, you can create a new subnet in this vnet and point to that subnet in your terraform code. It will work.

Cheers,

Luis

---

If the response helped, do "Accept Answer" and up-vote it