Home » Posts tagged 'SQL Server 2008'

Tag Archives: SQL Server 2008


Configuring Windows Firewall for Database Engine & Report Server Access in SQL Server 2008

Configuring Windows Firewall for

1: Database Engine

2: Report Server Access in SQL Server 2008


Opening port in the Windows firewall for TCP access


On the Start menu, click Run, type WF.msc, and then click OK.

SQL Firewall1


In the Windows Firewall with Advanced Security, in the left pane, right-click Inbound Rules, and then click New Rule in the action pane


SQL Firewall2


After selecting New Rule -> New Inbound Rule Wizard dialog box will be opened.


Select Port


SQL Firewall3


click Next.


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, my case we are using the default which is 1433.


SQL Firewall4


For More Info :  TCP/IP port numbers required to communicate to SQL over a firewall


Click Next.


In the Action dialog box

You will find three options


i  : Allow the connection

ii : Allow the connection if it is Secure

iii: Block Connection


Here we can either select any one of the three based on your requirement


Allow Connection will allows the connections that are protected by IPsec and those are not


Allow the connection if it is Secure Connection will be secured using the settings in Ipsec properties and rules in connection Security Rule node. And this can be customized as shown below


SQL Firewall5

Customized settings


SQL Firewall6


Block connection will block all the connections


In our scenario we’ll select Allow Connections


SQL Firewall7


Click Next


By Default


Domain, Private & Public will selected, I will turn on Domain and I’ll turn off the other two Private & Public.


SQL Firewall8


In the Name dialog box, type “Allow SQL 1433 Inbound” and description can be written based on your requirement.


SQL Firewall9


Click Finish.


If you check Inbound rule is created


SQL Firewall10


Right Click on the “Allow SQL 1433 Inbound -> Properties -> Settings can be checked and changed according to your requirement (If required)


Configuring Firewall for Report Server Access


To open port 80 on Windows Server 2008 R2


On the Start menu, click Run, type WF.msc, and then click OK.


And follow the above steps


Click Inbound Rules.

Click New Rule in the Actions window.

Click Rule Type of Port.

Click Next.

On the Protocol and Ports page click TCP.

Select Specific Local Ports and type a value of 80.

Click Next.

On the Action page click Allow the connection.

Click Next.

On the Profile page I am leaving Domain turned on and turning off private and public.  You should check the appropriate options for your environment.

Click Next.

On the Name page enter a name of Allow SQL Report Server (TCP on port 80)


SQL Firewall11


Click Finish.



Praveen Kumar

Publisher @ Techrid.com