IT Consultant Everyday Notes

Just some problems/solutions storage

SCCM 2012: Hierarchy Monitoring detected that the ConfigMgr SQL Server <SQL_Name> 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

Advertisements

5 responses to “SCCM 2012: Hierarchy Monitoring detected that the ConfigMgr SQL Server <SQL_Name> ports 1433,4022, are not active on Firewall exception

  1. Eric Shupps August 12, 2012 at 1:31 pm

    Excellent post. Very helpful. Thanks for the info.

  2. TerryWa August 16, 2012 at 3:06 pm

    This worked! Thanks!

  3. sridhar Bala November 2, 2012 at 2:19 pm

    Way to go. Thanks for the post.

  4. panky January 14, 2013 at 12:07 pm

    hi, thx for this post. even after adding these rules on SQL nodes in cluster, I am getting the same error. any tip- what else can be wrong?

    • alex416 January 14, 2013 at 1:23 pm

      do not forget ConfigMgr itself! Originally I added the rules on SQL only and it did not remove the issue. I recommend enable firewall and stop it for Domain profile (if you are not using it)

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: