Configuring firewall rules for SQL Server

For access to the SQL server by the clients the server will need to have a rule added to the firewall.

SQL - Port 1433 TCP
Reporting Services - Port 80 TCP

You can do this with a command.

Open a command prompt with run as administrator.

For SQL type:

netsh advfirewall firewall add rule name = SQLPort dir = in protocol = tcp action = allow localport = 1433 remoteip = localsubnet profile = DOMAIN

netsh advfirewall firewall add rule name = SQLPort dir = in protocol = tcp action = allow localport = 1433 remoteip = localsubnet profile = DOMAIN

For Reporting Services type:

netsh advfirewall firewall add rule name = RSPort dir = in protocol = tcp action = allow localport = 80 remoteip = localsubnet profile = DOMAIN

xxxxxxxxxx

netsh advfirewall firewall add rule name = RSPort dir = in protocol = tcp action = allow localport = 80 remoteip = localsubnet profile = DOMAIN

Other ports may be required for additional services like Winman Go.