We're monitoring an Azure SQL DB with the latest version of DPA. Upon setting up the connection, we found that a DPA would not work unless we opened port 11033 on the NSG. This was due to some sort of redirection going on.
Since then, DPA has been running fine, until early this morning when it lost connection to the Azure SQL DB. Checking the logs, reveals that DPA now needs port 11056 opened up in order to connect.
These ports, are they coming from DPA when monitoring Azure SQL DB? Is there a port range that we can add to the NSG to prevent DPA from falling over in the future?
Exact error is below, with server and database names removed;
Date: 5/26/23, 10:23:08 AM
com.confio.ignite.common.jdbc.exceptions.DatabaseConnectionException: A connection to the database could not be established: Invalid Host or Port [cause=com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host <xxxx>.westeurope1-a.worker.database.windows.net (redirected from <instance>), port 11056 has failed. Error: "connect timed out. 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.".]