July 5, 2016 at 3:34 pm
I'm going through the tutorial on creating and setting up a SQL Azure[/url] (Azure SQL, I don't know which comes first) and came to the section named "Create a new Azure SQL server-level firewall". This has me stumped. I believe I could easily find out my machine's IP address, but I'm at home. I'll be doing this development at home. My IP address is assigned through a DHCP server from CenturyLink, my ISP. Whatever my IP address is, its likely to change the next time I reboot my DSL modem. And I've no idea at all what the range of IP addresses are that I'm likely to get. Does this mean that I have to get a static IP address from my ISP? Or is there something else I can do?
Rod
July 6, 2016 at 4:08 am
Generally, you'll have the same IP address for very long periods of time. However, I travel a lot and demo Azure at many different locations. It's quite easy to quickly add an IP address through the Azure portal. You go to the server. When it opens, it opens with the properties blade on the right (normally). There you'll see firewall. Click on that it'll open another blade. Right at the top it has a button, "Add Client IP". It will capture the IP address that you've connected to the portal with and you can easily add this to the firewall. Be sure you hit the save button so that it applies it. Pretty painless.
Real world, not a test or dev system, you'd want either a fixed IP address, or to assign a known range that your IP will fall within. Or, you'll be connecting from within Azure, so you'll be inside the firewall.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply