Home » Posts tagged 'SQL Server 2008'

Tag Archives: SQL Server 2008

Translate:

Archives

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

Translate »