While trying to configure SQL PI monitoring extension, the error message is received:
Failed to enable SQL PI monitoring extension for SQL Agent
The FMS logs can be consulted to determine the hostname that the FMS is trying to use to connect to the SQL PI repository. Make sure the IP address is pingable from the FMS server.
Example error in FMS log:
Caused by: java.net.UnknownHostException: fglam_host.restricted.domain
Add the IP address and fully qualified name of the FglAM server that is hosting the SQL PI repository to the hosts file of the FMS server.
The hosts file is located here: %WINDIR%\system32\drivers\etc\hosts
For example, add the following line to the hosts file:
192.168.1.123 fglam_host.restricted.domain fglam_host
Then try pinging the FglAM host to make sure the name is now resolvable. In this example: