TCP | dbatools | Command-line superpowers for SQL Server automation

Get-DbaTcpPort

Chrissy LeMaire (@cl), netnerds.net

Get-DbaTcpPort View Source Chrissy LeMaire (@cl), netnerds.net Windows, Linux, macOS On this page: Synopsis · Description · Syntax · Examples · Parameters · Outputs Synopsis Returns the TCP port used by the specified SQL Server. Description By default, this function returns just the TCP port used by the specified SQL Server. If -All is specified, the server name, IPAddress (ipv4 and ipv6), port number and an indicator of whether or not the port assignment is static are returned.

Set-DbaTcpPort

@H0s0n77

Set-DbaTcpPort View Source @H0s0n77 Windows, Linux, macOS On this page: Synopsis · Description · Syntax · Examples · Parameters · Outputs Synopsis Configures SQL Server TCP port settings for specified instances and IP addresses. Description Configures TCP port settings for SQL Server instances by modifying the network configuration through SQL Server Configuration Manager functionality. This replaces the manual process of opening SQL Server Configuration Manager to change port settings for security hardening or network compliance.