Configuring firewall settings for SQL Server Engine on Windows 2008 R2
If SQL Server is installed on Windows Server 2008 R2, then we have to open firewall port so that database instance can be connected from outside the physical server. Steps to open the port in Windows Server 2008 R2 are quite different from Windows Server 2008.
Following are the steps to be followed in order to open firewall port for SQL Server engine so the that instance can be connected from outside the physical server.
1) Navigate to Administrative Tools à Windows Firewall with Advanced Security.
2) Below window will open. Here go to Inbound Rules à Right click à New Rule…
3) In the new Inbound Rule wizard, select the rule as Port – Rule that controls connections for a TCP or UDP port. And click Next.
4) In this Protocol and Port window, select TCP and then specify the local port, which to which SQL Server is listening to. Default port used by SQL Server is 1433. Click Next.
5) In this window we need to provide details about the action to be taken by system when the specified conditions. We will select Allow the connection and move to next step.
6) If you want the SQL Server instance to be connected only from the systems in same domain the select Domain. You can also select Private and Public as per your requirement. Then move to Next step.
7) Provide a relevant name to the rule like SQL Server <instance name> and click Finish.
8) To verify that the rule is created and is enabled, you can click on Inbound Rules and will be able to see the rule by name ‘SQL Server <instance name>’ or the name you provided in last step.
Also, you can see that the rule is enabled by default.