Synapse notebook connect to Sql database hosted on Azure virtual machine using private endpoint

Scotty Tarvan 6 Reputation points
2023-06-04T13:43:17.43+00:00

Hello All,

Im trying to connect a synapse notebook to an Azure VM that's hosting a sql server database. I need to connect via a private endpoint and linked service and not the public IP. I have been following examples like this: https://www.linkedin.com/pulse/azure-synapse-connection-db-hosted-vm-from-spark-notebooks-pathak/

I setup all components like load balancer, private link service and also approved the managed private endpoint from Synapse workspace. I just cant get it connect using the private IP or the link servivce alias.

Is there any documentation or examples I can follow?

Thanks

Azure Virtual Network
Azure Virtual Network
An Azure networking service that is used to provision private networks and optionally to connect to on-premises datacenters.
2,291 questions
Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,671 questions
{count} votes