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 ...Discovery of Redis server fails with message "Unable to connect to host: <hostname> port: <port number>".
Solution: Confirm that the Redis host and port are accessible from the server on which the Applications Manager product is installed. Ensure that there are no network restrictions or firewall rules preventing access to the Redis server. To verify the ...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 -> ...