Firewall Settings for SQL 2016 and SCCM 2016

There are some connections in System Center 2016 Configuration Manager which use ports and some use custom ports.

I am creating inbound and outbound rules for file and printer sharing and opening TCP ports for SQL 2016.

Open Server Manager go to Tools and open Group policy management to create firewall rules for SCCM 2016

101318_0547_FirewallSet1.png

At group policy management console right click on domain and click on Create a GPO

101318_0547_FirewallSet2.png

In Name type client push for SCCM 2016

101318_0547_FirewallSet3.png

Then right click on Client push policy you created and select edit this policy

101318_0547_FirewallSet4.png

Navigate to computer configuration\policies\windows settings\Security settings\Windows firewall with advance security\Windows firewall and advance security from there you can find Inbound Rule create new inbound rule

101318_0547_FirewallSet5.png

In rule type window select Predefined and from predefined select File and Printer Sharing then click next

101318_0547_FirewallSet6.png

From Predefined window select all rules and click next

101318_0547_FirewallSet7.png

Here select Allow the action after that click finish

101318_0547_FirewallSet8.png

101318_0547_FirewallSet9.png

At Rule Type select Predefined and in predefined select Windows Management Instrumentation (WMI) then click next

101318_0547_FirewallSet10.png

At predefined window select all rule then click next

101318_0547_FirewallSet11.png

Select allow the connection and click finish

101318_0547_FirewallSet12.png

101318_0547_FirewallSet13.png

Creating rules to open ports for SQL 2016 replication

I am creating rule to open ports for SQL replication, open two ports

i.e Port 1433 and Port 4022 

From group policy management console right click on domain and Create a GPO

101318_0547_FirewallSet14.png

Type name

101318_0547_FirewallSet15.png

Right click and select new rule to create rule for SQL 2016 Ports for SCCM 2016

101318_0547_FirewallSet16.png

Select Port and click next

101318_0547_FirewallSet17.png

Select TCP then select Specified local ports in specified local ports type 1433 and click next

101318_0547_FirewallSet18.png

Select allow the connection then click next

From Profile window select Domain, Private, Public and click next

101318_0547_FirewallSet19.png

 Type name and click on finish

101318_0547_FirewallSet20.png

101318_0547_FirewallSet21.png

Select Allow the connection then click next

Select Domain, Private, Public and click next

Type name and click on finish

101318_0547_FirewallSet22.png

Configuring firewall for SCCM 2016 Completed

Run command to gpupdate /force to update policies

 

 

 

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 )

Google photo

You are commenting using your Google 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 )

Connecting to %s