How to Fix Azure SQL Server Connection Issues with P2S VPN?
Asked by
TechyNinja87
Hey folks! I've set up a Point-to-Site (P2S) VPN to securely connect to my Azure SQL Server and access my resources. I've made sure to deny public access to the server and added a private endpoint for the VPN. However, I'm still running into a 'connection denied' error because public access is turned off. When I look at the connection trace, it seems I'm not going through the VPN to reach the server since I get a response from a public IP that I can't identify. I'm looking for any suggestions or ideas to resolve this issue.
Answers
You're probably experiencing DNS resolution issues. I suggest checking out these resources: the Azure Private Endpoint DNS Zone documentation and the Microsoft Q&A on DNS resolution issues for P2S VPN users. Both links have relevant info that could help you sort things out. A quick Google search brought them up!
Reply to this answer
Make sure that your setup is correctly resolving to the private IP rather than a public one. Double-check your configurations.
Reply to this answer
It sounds like a DNS issue. You should set up a private DNS resolver in Azure and configure it as the DNS IP for your VPN clients. This often helps resolve connections correctly without hitting public IPs.
Reply to this answer
Add your answer
Answers are reviewed before publication.
Related Discussions