Approving private link endpoint request for azure sql database from other subscription fails

prikala 1 Reputation point
2020-11-12T09:40:56.467+00:00

Any ideas what could be causing this:

I am trying to create a private link connection to access database server located in subscription "PROVIDER" from subscription "CLIENT".

Creating private endpoint (request) goes as it should. I provide the Resource ID of the server located in PROVIDER-subscription and type "sqlServer" as as target sub-resource.

Private endpoint request appears in the "Pending connections" of the "PROVIDER".
When I approve the request, I get the following error.

What could be the reason?

Failed to approve private endpoint connections
Failed to approve 1 out of 1 private endpoint connections
pvteppltest-6949e9c8-fe0b-42cc-b502-95c7014c6a7c: An unexpected error occured while processing the request. Tracking ID: '36bcc844-ec0b-4067-b585-8233f089e304'

Azure Private Link
Azure Private Link
An Azure service that provides private connectivity from a virtual network to Azure platform as a service, customer-owned, or Microsoft partner services.
461 questions
0 comments

4 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. TravisCragg-MSFT 5,676 Reputation points Microsoft Employee
    2020-11-12T19:53:34.83+00:00

    I am not able to find any information on this error while approving a private endpoint. Double check that you have the appropriate permissions on the approval subscription.

    If you have the appropriate permissions but this error still occurs, your best bet will be to speak with Microsoft Support to troubleshoot further. If you do not have a support plan, please let me know!

    0 comments
  2. prikala 1 Reputation point
    2020-11-13T12:31:39.387+00:00

    Update: It turns out this really was "An unexpected error "!

    Yesterday I tried this with multiple different accounts and asked two colleagues test the same to make sure I am not doing anything wrong - all ended with the same error.

    This morning I decided to try one more time and this time, no error!

    (this was with North Europe and West Europe regions if that matters)

    0 comments
  3. Jason Hendrix 1 Reputation point
    2021-03-04T17:52:12.667+00:00

    @TravisCragg-MSFT I'm getting this same error today while trying to approve a private endpoint. My account is assigned the "Owner" Role in the Subscription.

    0 comments
  4. FENG CHEN 16 Reputation points
    2022-02-11T23:38:46.147+00:00

    hitting the same brick today.

    action": "Microsoft.Sql/servers/privateEndpointConnections/write"
    {\"status\":\"Failed\",\"error\":{\"code\":\"ResourceOperationFailure\",\"message\":\"The resource operation completed with terminal provisioning state 'Failed'.\",\"details\":[{\"code\":\"InternalServerError\",\"message\":\"An unexpected error occured while processing the request. Tracking ID: 'abc2d417-66d4-4884-8100-80f8e0c768d0'\"}]}}",

    I am able to create a private endpoint in a vnet to a SQL Server in the same region and same subscription ( auto approved ), but when I tried to approve the request from a different tenant/region, got this error. My account in both tenant's subscription has owner role.

    Now in the request side, the PE is showing as pending; on the SQL Server side, it's showing as approved.