Cannot add a data source into AppManager Performance Profiler (NETIQKB53684)

Cannot add a data source.
Error: 'A configuration error has occurred: Unable to get information from SQL Server: '
SQL Server logs show no record of AMPP attempting to connect to SQL.

To correct this issue, open port 1434 to UDP between the AMPP server and the SQL Server hosting the repository on a named instance.  This port must remain open for AMPP to properly function when working with a repository in a named SQL Server instance.

NOTE: This issue only applies to repositories in named SQL Server instances.  If the repository is in the default SQL Server instance, AMPP uses TCP/IP over port 1433 to access the repository, unless otherwise configured during installation.  See NETIQKB49658 for assistance on installing AMPP where the AMPPDB will be hosted on a SQL instance that is not using the default SQL Port of 1433.

The error occurs when jTDS, a function of JDBC, times out trying to determine which named instances are available on the target SQL Server.  The connection timeout occurs when there is no server listening on port 1434, or when communication on port 1434 is blocked between the AMPP server and the SQL Server hosting the repository on a named instance.

When adding a data source that exists in a named instance in SQL Server, AMPP connects to SQL Server using JDBC drivers and determines which named instances are available using UDP over port 1434. Once AMPP has accessed the correct instance of SQL Server, it switches to TCP/IP over port 1433 to add the data source. The issue can occur when there is a firewall between the AMPP server and the SQL Server hosting the repository on a named instance or if port 1434 is not listed as open in the Access Control List (ACL).

Formerly known as NETIQKB53684