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 and END IP. In this scenario, we will click on Add 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 by navigating to the database and clicking on Set server firewall, as shown in the following screenshot:
Make sure that port 1433 is open in your environment, which is used for communication between the SQL Server and the client (SQL Server Management Studio (SSMS)).