Hands-On Azure for Developers

Firewall

When browsing your SQL Database, you probably noticed the Set server firewall button that is available on the Overview blade:

This is the easiest way to set a firewall rule that allows traffic to Azure SQL.

In Azure SQL, initially all traffic is rejected—you have to whitelist all IPs of computers that should be allowed to communicate with the server.

Before we start configuring the firewall, you have to understand why we really need it. Here is what happens if I try to connect to my server using Microsoft SQL Server Management Studio:

As you can see, it automatically detects that my IP is not whitelisted, hence the server refuses ...