I have an azure hosted sql server, for development reasons, I have added the ip address of my VPN to the firewall settings, so I can connect when I am at home etc.
I have setup an azure virtual network with a gateway and setup a point-to-site connection as detailled here.
Having connected to the gateway, ipconfig shows a section PPP adaptor myNewNetwork, with the VNets public IP address. However, when connected I tried visiting http://www.whatsmyip.org/, and it shows my routers IP address (the same IP as before connecting to the VPN). I have also tried connecting to my Database and that failed too.
Have I misunderstood what the SSTP VPN does, or is there some additional configuration required to route traffic through the VNet's public IP.
Best Answer
Based on my knowledge, it is a design behavior. When you create a Point-to-Site VPN, the traffic transfer to Internet will continue use your ISP network, the traffic will not go to Azure VNet. So, you only get your ISP public IP address.
Do your database on Azure Virtual Network? Please ensure your database and your vpn gateway in the same VNet. You could test database in your lab.
telnet <database private ip> port.