SCCM 2012: Hierarchy Monitoring detected that the ConfigMgr SQL Server ports 1433,4022, are not active on Firewall exception

ConfigMgr logs the error even though Windows Firewall is disabled or it is enabled and all exceptions are added to SQL Server(s).
Environment: I had an environment  consist of a two node SQL Cluster hosting ConfigMgr database and a separate ConfigMgr primary site server
Windows firewall service must be started on both SQL nodes and ConfigMgr itself . As soon as the service is started exceptions for TCP 1433 and 4022 must be added to SQL nodes firewall. After that the firewall profiles can be disabled using:
netsh advf set allp state off


Popular posts from this blog

The install4j wizard could not find a Java Runtime Environment on your system. Please locate a suitable JRE...

Clients Unable to update - "Cached cookie has expired or new PID is available"

Java Control Panel Icon "Application Not Found"