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

Question

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'

Answer 1

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!

Answer 2

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)

Answer 3

@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.

Answer 4

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.