IT:AD:Firewall

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

• MSDN Reference

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

Use NetStat (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.