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.
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
Step 2: It will bring up login screen to your Microsoft Azure account
Step 3: Once login successfully, it will bring up the New Firewall Rule screen.
That’s it. We are done.
You can check your listed IP address under the section Firewalls and Virtual Networks.
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.
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)