Azure SQL Database - Troubleshooting - Add client IP to Azure firewall

Azure SQL Database - Troubleshooting - Add client IP to Azure firewall

"Connection to the database failed with error : Cannot open server <ServerName> requested by the login. Client with IP address <SomeIP> 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" - Error message in monitor details page of Azure SQL Database"

In Azure portal, the user should add the client IP(mentioned in the error message) under the firewall settings in SQL server. This step is necessary for APM serve to communicate with the SQL server in Azure.

In case if the user changes the network, the client IP also changes. So it is better to add all possible client IPs of the user in Azure portal.

                    New to ADSelfService Plus?

                      • Related Articles

                      • Azure SQL Database - FAQ

                        1. Why have we removed the Diagnostic Settings dependency in Azure SQL Database monitor? Till APM v15240: Azure SQL Database was using Diagnostic Settings to perform data collection. Prerequisites had to be fulfilled to turn on Diagnostic Settings ...
                      • Azure SQL Database - TCP/IP connection to the host <Azure SQL server> on port 1433 has failed

                        "Connection to the database failed with error : The TCP/IP connection to the host <Azure SQL server>, port 1433 has failed. Error: "Connection timed out: no further information. Verify the connection properties. Make sure that an instance of SQL ...
                      • Microsoft Azure - FAQ

                        1. What happens to the Azure monitor in Applications Manager when you delete any of the supported services from the Azure portal? When you perform a delete operation on any of the supported Azure resources in the Azure portal, the respective monitor ...
                      • Issues while installing or starting Applications Manager with Microsoft SQL Server backend database

                        Problem: Unable to install or start Applications Manager using Microsoft SQL Server database as backend. Solution: Follow the below troubleshooting steps to resolve the issue: 1. On the Microsoft SQL server host, go to Start -> All Programs -> ...
                      • Troubleshooting WinRM errors

                        This KB serves as a guide for troubleshooting errors when using the WinRM mode of data collection. First, ensure that all the following conditions are met: Refer to the below link and check if all the WinRM prerequisites have been completed properly ...