Opening a SQL Server Instance Port Using Windows Firewall If
you attempt to connect to SQL Server from another machine now, the connection
attempt will time out .
To connect to this instance, you must open the port . You
can do so using Windows Firewall, as follows:
1. Open Windows Firewall and click Start | Control Panel |
Windows Firewall.
2. Toward the top of the page, click Advanced Settings.
3. Select Inbound Rules from the left navigation pane .
4. Click New Rule from the right navigation pane.
5. On the Rule Type page, select the radio button labeled
Port, and click Next.
6. Ensure that the radio button labeled TCP is selected and
enter 1433 in the text box labeled Specific Local Ports. Click Next.
7. Select the Allow the Connection radio button and click
Next. 8. In the text box labeled Name, type a descriptive name for your inbound
rule. Click Finish. Now you should be able to connect to this instance of SQL
Server using various client tools, which will be discussed later in this book .
