As mentioned earlier, when you create an Azure Database via the Azure portal, all Azure services will be allowed to access this database with no further configuration.
However, when you want to connect to the database from anywhere else, there is some configuration that needs to be done.
To allow access to Azure SQL Database from somewhere else, you will have to set a server-level firewall rule, as described in the following steps:
- Navigate to the SQL Server and select
Firewalls and virtual networks
, as shown in the following screenshot:
- Then, you can specify the range of IP addresses you would like to allow access for, but if you want to specify a single IP address, you can add it as
START IP
andEND IP
. In this scenario, we will click onAdd client IP,
which will detect your own public IP address and add it, as shown in the following screenshot:
- Once you are done, click on
Save
. - You can do the same thing on the level of the database...