How to Fix Azure SQL Server Connection Issues with P2S VPN?

0
11
Asked By TechyNinja87 On

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.

3 Answers

Answered By CloudExplorer42 On

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.

Answered By NetworkGuru33 On

Make sure that your setup is correctly resolving to the private IP rather than a public one. Double-check your configurations.

Answered By DataWhiz99 On

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!

Related Questions

LEAVE A REPLY

Please enter your comment!
Please enter your name here

This site uses Akismet to reduce spam. Learn how your comment data is processed.