I recently had my public IP address refreshed and the moment I saw that I knew a pain that was coming.
I have a couple of Azure SQL Databases sitting on different Azure directories/tenants that I am connecting to regularly from my local SSMS/Azure Data Studio instances. Now I am going to have to remove the existing firewall rule for my previous public IP address and add a new firewall rule for the new IP address in each of these Azure SQL Servers. That's something I was very much frustrated with.
Finally decided to write a script to make things easier for me. Pushed it to a repo and all the information is listed there (the link is at the bottom of the post).
And no longer I have to worry about getting my public IP address refreshed (in terms of accessing Azure SQL Servers of course).
|
| Execution |
Script and instructions:
Hope this helps.
Happy Coding.
Regards,
Jaliya
No comments:
Post a Comment