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

Issue:
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
Resolution:
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

Comments

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"