If the Windows firewall feature is to be enabled, you should enable a port number on the database server. The following explains how to enable a port number:
Windows Server(R) 2003 or Windows Server(R) 2003 R2:
In the [Start] menu, select [Control Panel], and then click [Windows Firewall].
In the [Windows Firewall] window, on the [Exceptions] tab, click [Add Port].
In the [Add a Port] window, set the following:
In [Name], specify the desired name.
In [Port number], specify the Web server port number that was specified when creating the instance.
Select [TCP].
Click [OK].
On the [Exceptions] tab, in the [Programs and Services] list, check if the added port is enabled.
In the [Windows Firewall] window, click [OK].
Windows Server(R) 2008:
In the [Start] menu, click [Control Panel].
Click [Security] and then click [Windows Firewall].
In the [Windows Firewall] window, click [Change settings].
On the [Exceptions] tab, click [Add port].
In the [Add a Port] window, set the following:
In [Name], specify the desired name.
In [Port number], specify the Web server port number that was specified when creating the instance.
Select [TCP].
Click [OK].
On the [Exceptions] tab, in the [Program or port] list, check if the added port is enabled.
In the [Windows Firewall] window, click [OK].
Windows Server(R) 2008 R2:
In the [Start] menu, click [Control Panel].
Click [System and Security], and then click [Windows Firewall].
In the [Windows Firewall] window, click [Advanced settings] on the left side of the window.
In the [Windows Firewall with Advanced Security] window, click [Inbound Rules] on the left side of the window.
Click [New Rule] on the right side of the window.
In the [New Inbound Rule Wizard] window, select [Port], and then click [Next].
Select [TCP] and [Specific local ports], then specify the Web server port number specified when creating the instance, and then click [Next].
Select [Allow the connection], and then click [Next].
Select the profiles for which this rule applies, and then click [Next].
In [Name], specify the desired name, and then click [Finish].
In the [Windows Firewall with Advanced Security] window, check if the added rule is enabled under [Inbound Rules] in the center of the window.
Windows Server(R) 2012 or Windows Server(R) 2012 R2:
Right-click the [Start] screen, and then click [All apps] that is displayed in the bottom-right of the screen. In the [Apps] window, click [Control Panel].
Click [Windows Firewall].
In the [Windows Firewall] window, click [Advanced settings] on the left side of the window.
In the [Windows Firewall with Advanced Security] window, click [Inbound Rules] on the left side of the window.
Click [New Rule] on the right side of the window.
In the [New Inbound Rule Wizard] window, select [Port], and then click [Next].
Select [TCP] and [Specific local ports], then specify the Web server port number specified when creating the instance, and then click [Next].
Select [Allow the connection], and then click [Next].
Select the profiles for which this rule applies, and then click [Next].
In [Name], specify the desired name, and then click [Finish].
In the [Windows Firewall with Advanced Security] window, check if the added rule is enabled under [Inbound Rules] in the center of the window.