configure/Open Ports in Firewall

Posted by Professionaluser under Sql Server category on | Points: 40 | Views : 239
Firewall protects computer resources by preventing unauthorized access. To make connection to DB engine from other machine when a firewall is on , you must open a port in the firewall.
After you configure the Database Engine to use a fixed port, follow below instructions to open a port in the firewall.

1. Start menu --> click Run --> type WF.msc
2. Create New Rule under Inbound Rules in Windows Firewall with Advanced Security
3. Select Rule Type as Port and then in the Protocol and Ports dialog box, select TCP . Select Specific local ports, and then type the port number of the instance of the Database Engine. Type 1433 for the default instance. Type XXXXX if you are configuring a named instance and configured a fixed port in the previous task. Click Next.
4 . In the Action dialog box, select Allow the connection, and then click Next.
5. In the Profile dialog box, select any profiles that describe the computer connection environment when you want to connect to the Database Engine, and then click Next.
6. In the Name dialog box, type a name and description for this rule, and then click Finish.

Comments or Responses

Login to post response