Ready-to-use PowerShell script that replaces the deprecated netsh firewall commands with New-NetFirewallRule entries for the standard Microsoft SQL Server engine, Analysis Services, Service Broker, and management ports.
Tags
DatabaseIp AddressMicrosoft Sql ServerSqlTransmission Control ProtocolWindows Firewall
As Netsh Firewall commands are now deprecated , I have written a PowerShell script for use with deploying SQL or accessing remote instances.
Latest Version:
# Set the PowerShell execution policy to allow scripts
Set-ExecutionPolicy -ExecutionPolicy RemoteSigned
# Enabling SQL Server Ports
New-NetFirewallRule -DisplayName "SQL Server - TCP 1433" -Direction Inbound -Protocol TCP -LocalPort 1433 -Action Allow
New-NetFirewallRule -DisplayName "SQL Admin Connection - TCP 1434" -Direction Inbound -Protocol TCP -LocalPort 1434 -Action Allow
New-NetFirewallRule -DisplayName "SQL Database Management - UDP 1434" -Direction Inbound -Protocol UDP -LocalPort 1434 -Action Allow
New-NetFirewallRule -DisplayName "SQL Service Broker - TCP 4022" -Direction Inbound -Protocol TCP -LocalPort 4022 -Action Allow
New-NetFirewallRule -DisplayName "SQL Debugger/RPC - TCP 135" -Direction Inbound -Protocol TCP -LocalPort 135 -Action Allow
# Enabling SQL Analysis Services Ports
New-NetFirewallRule -DisplayName "SQL Analysis Services - TCP 2383" -Direction Inbound -Protocol TCP -LocalPort 2383 -Action Allow
New-NetFirewallRule -DisplayName "SQL Browser - TCP 2382" -Direction Inbound -Protocol TCP -LocalPort 2382 -Action Allow
# Enabling Miscellaneous Applications
New-NetFirewallRule -DisplayName "HTTP - TCP 80" -Direction Inbound -Protocol TCP -LocalPort 80 -Action Allow
New-NetFirewallRule -DisplayName "SSL - TCP 443" -Direction Inbound -Protocol TCP -LocalPort 443 -Action Allow
# Enable Windows Firewall with specific settings
Set-NetFirewallProfile -DefaultInboundAction Block -DefaultOutboundAction Allow -NotifyOnListen True -AllowUnicastResponseToMulticast True
