Unfortunately errors are present in any software system and most of the times, this is due to misconfiguration. The error “Client with IP not allowed access” is one of them. Continue to read the article in order to find the root of the issue and the solution.
Connect to Azure SQL error-Client with IP not allowed access
As we’ve said in our intro to this article, the problem you are having should be in the lines of an error with a text message similar to: “Cannot open <server> requested by the login. Client with IP address <ip-address> is not allowed to access the server.”
The solution in this situation is to login into your Windows Azure Management account and go to “SQL Databases”, on the left of the panel and click your database. Next, look for “Manage allowed IP addresses” link on the page, as can be seen in the screenshot below.
Click on the link in order to configure your firewall settings. See the screnshot below as an example.
If you need any more information please take a look at this article here, which takes you through the details of backing up a database to Azure SQL.