Thor Logo dbatools

TCP

Get-DbaTcpPort

Chrissy LeMaire (@cl), netnerds.net

Get-DbaTcpPort View Source Chrissy LeMaire (@cl), netnerds.net Windows, Linux, macOS 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. Remote sqlwmi is used by default.

Read more

Set-DbaTcpPort

@H0s0n77

Set-DbaTcpPort View Source @H0s0n77 Windows, Linux, macOS 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. The function can target all IP addresses (IPAll setting) or specific IP addresses, disables dynamic port allocation, and sets static port numbers.

Read more