Client with IP not allowed access-Azure SQL error

Connect to Azure SQL error-Client with IP not allowed access

Client with IP not allowed access” is not a very common error, but still it does not let you do your job.
Sometimes when using SQLBackupAndFTP you might encounter an error saying that you cannot connect to your Azure SQL Database.
The error looks like: “Cannot open ‘<server>’ requested by the login. Client with IP address ‘<ip-address>’ is not allowed to access the server” 

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.

Connect to Azure SQL error-Client with IP not allowed access

Click on the link in order to configure your firewall settings. See the screnshot below as an example.


Client with IP not allowed access

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.

[Total: 1    Average: 5/5]