SQL Server 2014 Tutorial – Open SQL Server Instance Port in Windows Firewall

Published on March 27, 2016 by abundantcode

Filed under SQL Server

Last modified March 27, 2016

Print this page

rate 1 star rate 2 star rate 3 star rate 4 star rate 5 star
Your rating: none, Average: 2.5 (2 votes)

This article have been viewed 3344 times

Problem Statement

You need open the SQL Server Instance port number in Windows Firewall so that you can connect to SQL Server from another machine.


When you try to connect to the SQL Server instance from another machine , you might receive the connection timeout error . To allow the users of other machine to connect to your SQL Server instance , you need to open the port on which the SQL Server is running on your machine using Windows Firewall as shown below.

1. Open Windows Firewall from the Control Panel.


2. Click Advanced Settings in the left sidebar


3. Select Inbound rules from the left sidebar and click on “New rule” link from the navigation pane on the right.

5. In the Rule Type page of the New Inbound Rule Wizard , select radio button “Port” and click "Next".


6. Select the radio button “TCP” and enter 1433 in the text box “Specific Local Ports” and click Next.


7. In the Action page , select “Allow the connection” and click “Next button.


8. In the Profile , select the connection that this rule applies . Keep the checkboxes “Domain” , “private” and “public” enabled.


9. Finally , provide the name and description for the rule and click Finish button.


Now you should be able to connect to this instance of SQL Server from another machine.

If you enjoyed this post, please consider leaving a comment or subscribing to the RSS feed to have future articles delivered to your feed reader.

Leave a Comment


You might be Interested in these Posts

C Program to display Inverted half-pyramid using *

Problem Write a program in C to print Inverted half-pyramid using * as shown below.The program shou...

How to use array Rank in C# ?

In C# , the Rank property of the array is is used to get the rank of the array. In simple terms , ra...

How to append an array to another in JavaScript ?

In JavaScript , you may want to append one array to another array(s) to combine their elements resul...