PowerShell Script for SQL Firewall rules

As Netsh Firewall commands are now deprecated , I have written a PowerShell script for use with deploying SQL or accessing remote instances.   Set-ExecutionPolicy -ExecutionPolicy RemoteSigned  #Enabling SQL Server Ports New-NetFirewallRule -DisplayName “SQL Server” -Direction Inbound –Protocol TCP –LocalPort 1433 -Action allow New-NetFirewallRule -DisplayName “SQL Admin Connection” -Direction Inbound –Protocol TCP –LocalPort 1434 -Action allow... Continue Reading →

Create a website or blog at WordPress.com

Up ↑

%d bloggers like this: