Configure Firewall to Allow SQL Server Port

Hi Buddy's

Firewall helps to prevent unauthorized access to computer resources. if firewall is not correctly configured then a attempts to connect to SQL might be blocked.

You can configure port by following steps as mentioned.


A.  Open control panel >> Windows Firewall >>  Advanced setting >> click on Inbound rules >> New Rule >> select  PORT >> select >> TCP >> Enter 1433 >> Allow connection >> select network type  >> Name = SQLPort >> Finish.

B.   Use following command line in CMD.

 
netsh firewall set portopening protocol = TCP port = 1433 name = SQLPort mode = ENABLE scope = SUBNET profile = CURRENT


No comments:

Post a Comment