Synapse Analytics workspace can not linked services to PostgreSQL Flexible within VNet

Question

Here is my scenario:

• A database uses Azure Database for PostgreSQL - Flexible Server with Private access (VNet Integration) setting.
• An Azure Synapse Analytics Workspace with Managed virtual network (Enable)

I can not create the linked service to my PostgreSQL - Flexible Server. It always come with error :

The remote name could not be resolved: 'hungdhm-psql-flex-private.private.postgres.database.azure.com'

Answer 1

Hi Đỗ Hoàng Minh Hưng ,

Welcome to Microsoft Q&A platform and thanks for posting your query here.

The issue you're facing occurs because Azure Synapse Analytics Managed Virtual Network (VNet) doesn't have direct access to services deployed within private VNets.

Probably you need to create a Private Endpoint for your PostgreSQL Flexible Server and link it to Synapse’s Managed VNet.

Since your PostgreSQL Flexible Server uses private access via VNet integration, Synapse can't directly communicate with it unless the proper networking configuration is in place. Creating private endpoint would help in establishing the connection between postgreSQL and Synapse Vnet.

Reference: Azure Database for PostgreSQL - Flexible Server networking with Private Link

Hope it helps. Kindly accept the answer by clicking on Accept answer button. Thankyou