<t>This can be solved by configuring the Firewall of the Azure SQL Server where the SQL database resides. I am using the new Microsoft Azure Portal. Please see the screenshot below,<br/>
<br/>
Remember, you need to configure the Firewall and manage the IP addresses in SQL Server, not the SQL database.<br/>
<br/>
Once you have selected the SQL Server,<br/>
<br/>
- Click the Settings -> Firewall<br/>
<br/>
- You will be requested Add a new Rule.<br/>
<br/>
- Add a name and enter the IP address(or the range) that will access<br/>
the database. note: Azure automatically detects your current IP.<br/>
<br/>
<br/>
<br/>
Wait for 5 minutes and you are ready to go. I hope this helps.</t>
