azureip-addressazure-sql-databasevirtual-ip-address

Unable to access SQL Azure database using IP address?

Because of my machine IP gets changed dynamically (get ip using website whatismyip.com ) I could not able to access and set Server-Level Firewall Rules to sql azure database.

I tried to add range also 0.0.0.0 to 255.255.255.255 but it is not working.

Is there any work around to access SQL Azure?

getting error: enter image description here

Solution

  • I wrote a post a while ago on how to access the SQL Azure instance using point-to-site VPN provided by Azure Virtual Network. It does not require anything to be open on the SQL Azure side. Here is a link to it: http://rtumaykin-it.blogspot.com/2015/01/using-linux-iptables-port-forwarding.html

    Here is how to create a Virtual network and VPN: https://azure.microsoft.com/documentation/articles/vpn-gateway-point-to-site-create/

    Hope this solution can help.