SCCM 2012: Hierarchy Monitoring detected that the ConfigMgr SQL Server <SQL_Name> ports 1433,4022, are not active on Firewall exception
July 24, 2012
Posted by on
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