Client with IP address does not have access to Azure SQL Database Server

Question

I am encountering the error below when trying to connect to my free trial account in Azure SQL Database. Can someone help me how to set the rules in my free trial account? I see no way to install them.

Cannot open server 'ccaausprddb001' requested by the login. Client with
IP address '125.16.236.150' is not allowed to access the server.  To enable 
access, use the Windows Azure Management Portal or run sp_set_firewall_rule on 
the master database to create a firewall rule for this IP address or address 
range.  It may take up to five minutes for this change to take effect. 
ClientConnectionId:f1ce6d56-c321-4458-a8dc-507f40e24108
com.microsoft.sqlserver.jdbc.SQLServerException: Cannot open server 'ccaausprddb001' requested by the login. Client with IP address '125.16.236.150' is not allowed to access the server.  To enable access, use the Windows Azure Management Portal or run sp_set_firewall_rule on the master database to create a firewall rule for this IP address or address range.  It may take up to five minutes for this change to take effect.

Answer 1

This can be resolved by configuring the Azure SQL Server firewall where the SQL database resides. I am using the new Microsoft Azure portal. See the screenshot below. Remember that you need to configure the firewall and manage the IP addresses in SQL Server, not in the SQL database.

Once you have chosen SQL Server,

• →
• .
• IP- ( ), . . Azure IP-.

5 , . , .

Answer 2

portal.azure.com(), sql ( ) " ". " IP-" "".

manage.windowsazure.com, SQL- . , , . "". IP- IP- .

Answer 3

Azure. , " SQL" , " ", .

IP . , IP- .

You can now log in to your Azure SQL Server database using SQL Server Management Studio.

Answer 4

This does not work for all problems, as indicated:
As an alternative, you need to do as follows:

Run sp_set_firewall_rulemaster in the database to create a firewall rule for this IP address or range of addresses.