The error message indicates that the IP address of the client trying to connect to the Azure SQL server is not allowed through the server's firewall. You can follow the steps below to create a firewall rule to allow your client's IP address to access the server:
Log in to the Azure portal and navigate to the SQL server that you want to modify the firewall settings for.
In the left-hand menu, click on "Firewalls and virtual networks."
Add the IP address of the client machine that you want to allow access to the server. You can either add a specific IP address or a range of IP addresses.
Save the changes and wait for up to five minutes for the new firewall rule to take effect.
If you are still unable to connect after adding the firewall rule, ensure that the login credentials you are using to connect to the server are correct and that the login has been granted appropriate permissions to access the server and its databases.