SQL Azure – Add IP Address to Firewall

I have a strict rule during my Comprehensive Database Performance Health Check, that I will not access the client’s machine while doing SQL Server Performance Tuning because this way I can protect them and they can protect me on the security aspects. However, recently my client was working from home and he was not able to access the SQL Azure database. Let us learn how we can and IP Address to Access Server for SQL Azure.

SQL Azure - Add IP Address to Firewall ipaddress-800x450

Add IP Address to Azure Portal

When you try to login to SQL Azure account, and if your IP is not in the allowed IP list, it will bring up the popup for you to log in to the Azure account. If you successfully login into your Azure account, it will bring up the popup screen where you can directly add your IP address. You can see the entire experience in the images over here.

Step 1: Try to login to your SQL Azure account

SQL Azure - Add IP Address to Firewall azureipaddress1

Step 2: It will bring up login screen to your Microsoft Azure account

SQL Azure - Add IP Address to Firewall azureipaddress2

Step 3: Once login successfully, it will bring up the New Firewall Rule screen.

SQL Azure - Add IP Address to Firewall azureipaddress3

That’s it. We are done.

You can check your listed IP address under the section Firewalls and Virtual Networks.

SQL Azure - Add IP Address to Firewall azureipaddress4

On the same screen, you can see all the IP address which has access to your SQL database. If you see any IP address you are not confident, You can remove them by clicking on the three digits next to it.

One thing I must remind you that, once you delete the IP the page does not have by itself and you will have to explicitely save it.

SQL Azure - Add IP Address to Firewall azureipaddress5

Well, that’s it for today. Do let me know your feedback in the comments sections. Security is a very important one should not take it for granted.

Reference: Pinal Dave (https://blog.sqlauthority.com)

, , ,
Previous Post
Open Source Cloud – Final Post
Next Post
SQL Server – T-SQL – Add and Remove IP Address to Azure Firewall

Related Posts

Leave a Reply

Menu