Open nullbind opened 6 years ago
Add the listening TCP port to the Get-SQLServerInfo function output.
Option #1: https://docs.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-exec-connections-transact-sql?view=sql-server-2017
select local_tcp_port from sys.dm_exec_connections where local_net_address is not null
Option #2 xp_regread from the mssql service settings.
Add the listening TCP port to the Get-SQLServerInfo function output.
Option #1: https://docs.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-exec-connections-transact-sql?view=sql-server-2017
select local_tcp_port from sys.dm_exec_connections where local_net_address is not null
Option #2 xp_regread from the mssql service settings.