Forum Discussion
Azure Synapse Serverless pool connection issues/ query timeout with DataLake in BR SOUTH
- Apr 13, 2023
Private DNS records and network security group (NSG) access rules play important roles when utilising private connections to Azure SQL resources (all types.)
Of the various outcomes you can end up facing based on the various settings that control public and private endpoints, what it sounds like - to me - is that you're creating the private endpoint via the Azure portal but not creating the necessary NSG access rules between the client system and the Azure SQL private endpoint.
These access rules are not automatically created by the private endpoint creation process.
Cheers,
Lain
Private DNS records and network security group (NSG) access rules play important roles when utilising private connections to Azure SQL resources (all types.)
Of the various outcomes you can end up facing based on the various settings that control public and private endpoints, what it sounds like - to me - is that you're creating the private endpoint via the Azure portal but not creating the necessary NSG access rules between the client system and the Azure SQL private endpoint.
These access rules are not automatically created by the private endpoint creation process.
Cheers,
Lain