Sooner or later you will be faced with the need to open your server or workstation firewall to allow incoming connections. This is always a pain for me since this is not a task I do regularly. Finally after researching the issue several different times for each of the services in SQL Server, I wised up and put it all down in my OneNote reservoir.
This is the first of a series of blogs that provides guidance for setting firewall and server settings to allow connections to the various components of SQL Server- SQL Server, SQL Server Analysis Services, SQL Server Integration Services and SQL Server Browser. This entry addresses opening the firewall to permit connections to the default SQL Server instance.
Access the firewall control panel. This can be accessed by running the program firewall.cpl from the start menu.
The Windows Firewall window will open. Click on the Advanced Settings window.
In the next window, right-click on the Inbound Rules node and select New Rule...
The Inbound Rule Wizard will appear. On the Rule Type screen, choose a port rule type and then click Next.
On the Protocol and Ports screen select TCP and "Specific load ports". If no changes are made to the default installation of SQL Server, it will use port 1433. Enter 1433 in the text box.
On the Action screen select "Allow the connection".
On the Profile page, select the appropriate items. You may need to check your NIC card settings to determine the correct zone(s).
On the final screen titled "Name", enter a descriptive name and description. Click Finish.
You should see the new rule in the list of Inbound rules. This will allow connections to the default instance of SQL Server.
That's all you need to open the default instance of the SQL Server Engine
On the next post I will cover setting up named instances of the SQL Server Engine.