Protocol

Get-DbaClientProtocol

Klaas Vandenberghe (@PowerDBAKlaas)

Get-DbaClientProtocol View Source Klaas Vandenberghe (@PowerDBAKlaas) Windows, Linux, macOS Synopsis Retrieves SQL Server client network protocol configuration and status from local or remote computers. Description Retrieves the configuration and status of SQL Server client network protocols (Named Pipes, TCP/IP, Shared Memory, VIA) from local or remote computers. This function helps DBAs audit and troubleshoot client connectivity issues by showing which protocols are enabled, their order of precedence, and associated DLL files.

Get-DbaInstanceProtocol

Klaas Vandenberghe (@PowerDbaKlaas)

Get-DbaInstanceProtocol View Source Klaas Vandenberghe (@PowerDbaKlaas) Windows, Linux, macOS Synopsis Retrieves SQL Server network protocol configuration and status from target computers. Description Retrieves the configuration and status of SQL Server network protocols (TCP/IP, Named Pipes, Shared Memory, VIA) by querying the WMI ComputerManagement namespace. This is essential for troubleshooting connectivity issues, auditing network configurations for security compliance, and managing protocol settings across multiple SQL Server instances. The returned protocol objects include Enable() and Disable() methods, allowing you to manage protocol states directly without opening SQL Server Configuration Manager.