Dec 27, 2018
Automation to list all TCP static and dynamic ports of SQL Server instances using PowerShell
Automation to list all TCP static and dynamic ports of SQL Server instances using PowerShell
I was asked by the reader on how to get all the port information of SQL Servers instances. As you all knew that PowerShell is an automation framework for any of such requirement.
In this post, I’ll show to how to gather the information without logging on to each server.
Prerequisites
PowerShell 3.0 or above
WMI Service is enabled on all the target machine
The Server List is fed to the…
View On WordPress