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.
menu --> click Run
--> type WF.msc
2. Create New Rule
under Inbound Rules
in Windows Firewall with Advanced Security
3. Select Rule Type
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.