If we want to connect to SQL Azure from local system then we need to create an exception at local firewall for TCP port 1433.

Follow the below steps to create Exception on Windows 7 machine

Step 1

Click on Start button and then in Search text box type Firewall.

clip_image001

Step 2

You will able to see on top under Program tab , Windows Firewall with advanced security

clip_image002

Step 3

Right click on Windows firewall advanced security and select run as administrator

clip_image003

Step 4

You will get the below window

clip_image005

Step 5

Click on OutBound rules and then create on New Rules

clip_image007

Step 6

Now select PORT radio button and click Next

clip_image009

Step 7

Select TCP and Specific Remote port radio button.

In specific port address give port number 1433 to allow local system to connect to SQL Azure.

clip_image010

Step 8

Click Next , select Allow the Connection radio button.

clip_image012

Step 9

Click next and select all the option in check box.

clip_image014

Step 10

Click Next then give name and description to rule and click on Finish button

clip_image016

Now after this step we have created rule at local firewall to connect to SQL Azure

Advertisements

5 thoughts on “Setting up the Firewall on local system/computer to connect to SQL Azure

  1. I was just shwoing to beginners , how to put exception at local system … in my next I gona show when we do test connection on SQL Azure data base . local firwwall must have exception on the port 1433 . Thank you for comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s