FIREWALL SETTINGS TO ALLOW PORTS ON WINDOWS SERVER

Firewall settings to allow connections via ports for SQL SERVER on WINDOWS SERVER

 

 Opening up ports will allow the public/private connections to connect to DB via certain ports. This is a security feature that has to be enforced in a real time windows server in a secured environment.

 Goto >> control panel >> system and security

Then goto >> windows firewall and select advanced settings.

You will see inbound & outbound rules. These are the settings that need to be changed in order to allow or block connections.

select inbound rules and edit them. You can specify the ports that you would like to allow for inbound connections. Enter the below ports.

Select Allow the connection

Select types of connections you want to allow

Name the inbound connection rule

 Click on the inbound rules and verify the new rule has been added to list.