SSMS Connect to Azure SQL Managed Instance from Home with VPN

Question

We have an Azure SQL Managed Instance set up with a public endpoint. Inbound rules are set for port 3342 with IP ranges that our company uses.

When I'm in the office, I can connect fine. However, we work remotely and use a VPN when remote to connect to our office's network. I added the range of IP addresses for the VPN. When I'm on this VPN running SSMS, I cannot connect to the SQL Managed Instance. Error code received is 10060. I ran IP config and even just entered my IP from the VPN in the inbound rules even though it was covered by the range. Still could not connect.

For testing purposes, I disconnected the VPN, got my IP address from home and added that to the inbound rules. I was able to connect just fine.

Any thoughts/suggestions I could try to get this working from home with a VPN?

Answer 1

Hi,@HSB Welcome to the Microsoft Q&A forum thanks for posting your question.

If I understand correctly you are having trouble connecting to an Azure SQL Managed Instance from home using SSMS while connected to their office network via VPN

When connected through VPN it's possible that a different IP address is used for egress, and it's possible that your traffic to Azure public IPs doesn't even traverse the VPN.  The error message should tell you the IP address your connection attempt appears to be coming from.  10060 error can occur due to various reasons, including network connectivity issues, firewall settings, or incorrect login credentials.Check the IP address used for egress when connected through VPN.also check if your firewall is blocking traffic.

Regards

Geetha