Forum Discussion
Solved
Azure Synapse Serverless pool connection issues/ query timeout with DataLake in BR SOUTH
In the last days, my synapse dev team has noticed a problem related with the connection between serverless sql buit in pool and datalake, the problem is: - query timeout when trying query a file sto...
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