We are seeing an issue with not being able to open Activity monitor for remote SQL servers.

The Activity Monitor is unable to execute queries against server . Activity Monitor for this instance will be placed into a paused state. Use the context menu in the overview pane to resume the Activity Monitor.

The RPC server is unavailable. (Exception from HRESULT: 0x800706BA) (mscorlib)

It appears some firewall is blocking it, When we look at firewall logs (on the network), we are seeing blocks from 496xx. And its different port for each server.

Is anyone aware if we can make this a static port?

enter image description here

1 Answer 1


Activity Monitor requires the firewall to allow access to the SQL Server port (default 1433) for SQL query access and the RPC ports for WMI access for things like the Processor, Network, Disk IO and Memory graphs. This blog describes this and the required permissions for viewing all of Activity Monitor.

This article describes how to configure a static port range for RPC on a machine to allow you to open those ports on the firewall, otherwise, you have to open a substantial range of ports. Due to the number of applications that can rely on RPC ports, you shouldn't restrict this range to a single port, but instead, use a range size suitable for the number of applications and that your security team is comfortable with opening on the firewall.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.