Azure SQL Database - TCP/IP connection to the host <Azure SQL server> on port 1433 has failed

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 Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall."" - Error message in monitor details page/Edit monitor page of Azure SQL Database monitor 

Resolution
Allow outgoing access on port 1433 on Appmanager machine for it to access the SQL Database

                  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 - 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 ...
                    • Microsoft Azure - Troubleshooting "Authentication Failed. Reason: Host Unavailable" error

                      "Authentication failed. Reason: Host Unavailable" - Error message upon adding a New Azure monitor and during data collection Troubleshooting: Ensure that the Applications Manager installed server has internet connectivity. The following hosts must be ...
                    • Unable to connect to the host

                      Follow the below steps to troubleshoot the error Check if the given Host Name / IP Address is correct. Run the below command in Applications Manger installed server to ensure Host / IP Address is reachable. ping <Host Name/IP Address> Eg: ping ...
                    • 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 -> ...