Security Configuration › Allow Remote Connections through Windows Firewall

Allow Remote Connections through Windows Firewall

Follow these steps:

1. Open Server Manager.
2. Right-click Computer, and select Manage.
3. Expand Configuration.
4. Expand Windows Firewall with Advanced Security.
5. Highlight Inbound Rules.
6. Select New Rule, under Actions.

   The New Inbound Rule Wizard opens.

   1. Select Port and click Next.
   2. Verify that TCP and Specific local ports are selected, enter the SQL port (1433), and click Next.
   3. Verify that Allow the connection is selected and click Next.
   4. Verify that the rule applies to all Profiles (Domain, Private, and Public), and click Next.
   5. Enter a Name for this Rule (SQL) and click Finish.
7. Verify the connection from a machine with only the SQL Client installed.