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” privileges.
For SQL type:
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
Other ports may be required for additional services like WinMan Go.