SQLServerで必要なポートをあける。コピペでどーん。

はじめに

くどうです。メモです。

コピペ

netsh advfirewall firewall add rule name = "SQLServer Port" dir = in protocol = tcp action = allow localport = 1433 remoteip = localsubnet profile = DOMAIN
netsh advfirewall firewall add rule name = "SQLServer Manager Port" dir = in protocol = tcp action = allow localport = 1434 remoteip = localsubnet profile = DOMAIN
netsh advfirewall firewall add rule name = "SQLServer Browser Port" dir = in protocol = udp action = allow localport = 1434 remoteip = localsubnet profile = DOMAIN
netsh advfirewall firewall add rule name = "HTTP Port" dir = in protocol = tcp action = allow localport = 80 remoteip = localsubnet profile = DOMAIN
netsh advfirewall firewall add rule name = "HTTPS Port" dir = in protocol = tcp action = allow localport = 443 remoteip = localsubnet profile = DOMAIN
netsh advfirewall firewall add rule name = "SQLServer Service Brocker Port" dir = in protocol = tcp action = allow localport = 4022 remoteip = localsubnet profile = DOMAIN
netsh advfirewall firewall add rule name = "SQLServer Mirroring Port" dir = in protocol = tcp action = allow localport = 7022 remoteip = localsubnet profile = DOMAIN
netsh advfirewall firewall add rule name = "SQLServer Services Port" dir = in protocol = tcp action = allow localport = 135 remoteip = localsubnet profile = DOMAIN
netsh advfirewall firewall add rule name = "SQLServer Analysis Services Port" dir = in protocol = tcp action = allow localport = 2383 remoteip = localsubnet profile = DOMAIN
netsh advfirewall firewall add rule name = "SQLServer Browser Port" dir = in protocol = tcp action = allow localport = 2382 remoteip = localsubnet profile = DOMAIN