question

AzureAaronHughes avatar image
3 Votes"
AzureAaronHughes asked PRADEEPCHEEKATLA-MSFT answered

Synapse private link to Azure SQL DB not working since new network ui on azure db

So i noticed a update to the Azure SQL DB Network UI panel in Azure Portal

since this update i am unable to accept or even see the private link request from synapse workspace

200922-image.png


200895-image.png

bit of a weird one - have been looking into other ways to accept this plink on the azure db side

azure-sql-databaseazure-synapse-analyticsazure-private-link
image.png (30.3 KiB)
image.png (47.2 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

PRADEEPCHEEKATLA-MSFT avatar image
1 Vote"
PRADEEPCHEEKATLA-MSFT answered

Hello @AzureAaronHughes,

Thanks for bringing this to our attention.

As per repro from our end, we are experiencing the same issue and I had reported this to the internal team.

201410-synapse-asqldb-privateendpoint.gif
Meanwhile, you can use Azure PowerShell or Cloud Shell to approve the managed private endpoint.

Step1: Go to Azure Synapse Studio => Manage => Under Security => Select Managed private endpoints => Select the newly created private endpoint and copy Target resource ID.

201395-image.png

Step2: Use the below PowerShell command to get the private endpoint connection by replacing the above copied Target resource ID as PriaveLinkResourceId

 Get-AzPrivateEndpointConnection -PrivateLinkResourceId “<PASTE Target Resource ID>”

201471-image.png

Note: To copy the Id from the step2 result it will be used in step3.

Step3: Use the below PowerShell command to approve the private endpoint connection.

 Approve-AzPrivateEndpointConnection -ResourceId “<PASTE Id>”

201472-image.png

Hope this will help. Please let us know if any further queries.


  • Please don't forget to click on 130616-image.png or upvote 130671-image.png button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how

  • Want a reminder to come back and check responses? Here is how to subscribe to a notification

  • If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators


image.png (118.9 KiB)
image.png (90.1 KiB)
image.png (198.1 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.