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.