Hello,

I have dynamic IP address from my internet provider. Thus I frequently have to update firewall rules. Is there any mean to avoid this (certificate, ...)?

Kind regards

Hello,

The SQL Azure Firewall prevents all access to databases until grant access from specific computers. Access via the SQL Azure Firewall is based on originating IP address.
If you have an Internet connection with dynamic IP addressing,you could try one of the following solutions:
1.Ask your Internet Service Provider (ISP) for the IP address range assigned to your client computers that will access the SQL Database server, and the then add the IP address range as SQL Database firewall rule.
2.Get static IP addressing instead for your client computers, and then add the IP addresses as SQL Database firewall rules.

Reference:
Windows Azure SQL Database Firewall
SQL Azure: Cloud Database Security

Regards,
Fanny Liu

If you have any feedback on our support, please click here.

Hi,

Thank you for your answer. Solution 1 is not secure. Solution 2 is not available from my ISP.

Kind regards.

• Edited by Julien LefèvreMVP Thursday, January 09, 2014 10:08 AM