news and infos about microsoft, technology, cloud and more

Add your local IP address to a SQL Azure Firewall easily

When working with SQL Azure you are aware that a connection is just established, if the client's IP address is configured in the firewall of the SQL Azure database server. You needed to open the Azure Portal-SQL servers service and add your IP address manually. Well, the good story is, now the SQL Server 2016 Management Studio does this for you!

At my home, the ISP renews IP addresses constantly. So, it's always an effort to add my current IP address manually in the Azure Portal to be able to connect. Well, this can be done with Azure PowerShell as well, but I never automated that.


Now, my SQL Management Studio surprised me by offering to add my current IP address with a new wizard. You just need to authenticate with an Azure account and add the suggested client IP address without the need to perform this action in the Azure Portal, simply as follows.


Maybe this is not a new feature, but I just stumbled about that and thought, well, that's a useful addition to SQL Management Studio 2016!

Happy connecting! Winking smile

Comments (7) -

  • Randalltbartel

    11/10/2017 6:11:25 AM |

    It's fortunate that I have gorgeous profile in informal community. The blog was absolutely incredible. Lots of extraordinary information which can be helpful in a few or the other way. Continue refreshing the blog, looking forward for more contents. Incredible job and keep it up.

  • Mitchell John

    11/19/2018 6:22:45 AM |

    There are examples of several error codes that are associated to this error. They are: Error: “File System Mistake 3006”, Error: “File System Mistake 3008”, Error: “File System Mistake 3014”, Error: “File System Mistake 3020” etc.
    How to Fix Sage 50 Mistake 3004
    This error 3004 may be due to various factors like:
    • System communication error
    • Program conflicts related (Anti-Virus/ Firewall/ hardware/NIC/Switches/Routers/Cabling)

  • Mitchell John

    11/19/2018 6:23:58 AM |

    Windows 10 users: In screen 10, there is already has Online Traveler 11 and TLS 1.2 automatically.
    You can examine that TLS 1.2 allow or not by following these actions.
    Click on the resources selection on Online Traveler.
    After that Choose Online Choices.
    Click on the Innovative tab and scroll down to the Protection area.
    To Verify, see if you have TLS 1.2 allowed,  if not, examine the box to allow it.

  • Mitchell John

    11/19/2018 6:30:09 AM |

    When composing an email, start typing their name in the To field. As you do, suggestions from senders and your contacts will be displayed. If your intended contact is shown, click the name to add it as a recipient. Otherwise, click Search People to extend your contact search.

  • Mitchell John

    11/19/2018 6:30:57 AM |

    Additionally, Microsoft provides you with a broad set of security and compliance solutions to more seamlessly implement your controls.

  • Mitchell John

    11/19/2018 6:33:44 AM |

    Aol App gives you the freedom to availability email, latest information, videos and weather forecast and many more exciting functions. Before developing this system you should validate it need which is given below:

  • Mitchell John

    11/19/2018 6:34:19 AM |

    Webroot Client Support Cellphone Number
    Webroot anti-virus is the most popular anti-virus among all anti-virus available on the market. It defends your pc from all hazards, Trojan viruses, and undesirable programs;

Pingbacks and trackbacks (1)+