Setting Up the Firewall on Local System/Computer to Connect to SQL Azure

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

Follow the following steps to create Exception on Windows 7 machine

Step 1

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


Step 2

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



Step 3

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



Step 4

You will get the following window


Step 5

Click on OutBound rules and then create on New Rules



Step 6

Now select PORT radio button and click Next



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.



Step 8

Click Next , select Allow the Connection radio button.



Step 9
 
Click next and select all the options in the checkboxes.


Step 10

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



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