#sql #sqlserver #firewall #windowsfirewall #windows #netsh ``New-NetFirewallRule -DisplayName"SQLServer default instance" -DirectionInbound -LocalPort1433 -ProtocolTCP -ActionAllow `` ``New-NetFirewallRule -DisplayName"SQLServer Browser service" -DirectionInbound -LocalPort1434 -ProtocolUDP -ActionAllow `` ``netsh firewall set portopening protocol = TCP port = 1433 name = SQLPort mode = ENABLE scope = SUBNET profile = CURRENT `` ``netsh advfirewall firewall add rule name = SQLPort dir = in protocol = tcp action = allow localport = 1433 remoteip = localsubnet profile = DOMAIN `` Zie ook [[How to shrink an oversized SQL LOG file]]