I'm trying to run the Discovery Wizard in SCOM 2016 against a few MS SQL servers, so the Health agent can be pushed to the remote computers.
I've found documentation stating that the following ports should be open: 135, 137, 139, 445, and 5723.
At the SCOM management server, I probed those ports on a SQL server already being monitored (added by the previous admin); PowerShell's Test-NetConnection cmdlet returned 'False' for each.
I'm perplexed as to how the previous admin successfully ran the Discovery Wizard against the other SQL servers. Having a list of all ports to open would lead to just a single request to the firewall management team. Is there a complete list?