Configuring TCP Ports and Windows Firewall

The procedures below are required to configuring TCP ports and the Windows Firewall for SQL Server 2012.

Navigate to the Control Panel | System and Security | Windows Firewall | Advanced settings.
On the left pane, click Inbound Rules. Right-click Inbound Rules and select New Rule. The New Inbound Rule Wizard opens.
Select Program and click Next.
Click This program path and type or click Browse to "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\MSSQL\Binn\Sqlservr.exe" and click Next.
In the Action page, click Allow the connection and click Next.
In the Profile page, select any profile(s) that describe the computer connection environment when you want to connect to the Database Engine, and click Next.
In the Name page, type a name and description for the rule and click Finish.

Navigate to the Control Panel | System and Security | Windows Firewall | Advanced settings.
On the left pane, click Inbound Rules. Right-click Inbound Rules and select New Rule. The New Inbound Rule Wizard opens.
Click Port and click Next.
Click TCP | Specific local ports and type "1433-1434" and click Next.
In the Action page, select Allow the connection and click Next.
In the Profile page, select any profile(s) that describe the computer connection environment when you want to connect to the Database Engine, and click Next.
In the Name page, type a name and description for the rule and click Finish.
Create a New Rule for UDP port 1433-1434 by repeating steps 2-7 above, but altering step 4 by clicking UDP instead of TCP.
Create a New Rule for TCP port 445 by repeating steps 2-7 above, but altering step 4 by typing "445" in the Specific local ports field.