# IT:AD:Firewall #



<callout type="Navigation" class="small">

* [[../|(UP)]]
{{indexmenu>.#2|nsort tsort}}



##


</callout>


## FireWall ####

These days, seem to have to use this only when setting up SQL Server's 

* [MSDN Reference](http://msdn.microsoft.com/en-us/library/cc646023.aspx)


Configuration of Firewall, using netsh (I think this is only still needed for systems older than vista and WS2K8)

    netsh firewall set portopening protocol = TCP port = 1433 name = SQLPort mode = ENABLE scope = SUBNET profile = CURRENT


Configuration of Advanced Firewall, using netsh

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

## TroubleShooting ##

Use NetStat ([[IT/AD/Infrastructure/Network/NetStat/]])

    netstat -n -a.

The -n switch instructs netstat to numerically display the address and port number of active TCP connections. The -a switch instructs netstat to display the TCP and UDP ports on which the computer is listening.