Return
-
Title
Monitoring SQL Server instances using dynamic ports -
Description
What settings should be used to monitoring SQL Server instances using dynamic TCP ports?
-
Resolution
For named instances,
1). Ensure that the SQL Server browser service is running on the host server.
2). Open UDP port 1434 between the FglAM and monitored host for the SQL Server Browser to function.
3). Dynamic ports in the range of 49152 to 65535 are used, so you'll need to either configure a static port or allow all dynamic ports through the firewall between the FglAM and the host.
4). In the connection fields of the SQL Server agent used the hostname and instance name, then use 0 (zero) for the port.