Identify Local_TCP_Portand ENDPOINT used by a SQL Connection
Identify Local_TCP_Portand ENDPOINT used by a SQL Connection
SELECT a.EndPoint_Id,Name,Local_TCP_Port,Client_Net_Address FROM SYS.DM_EXEC_CONNECTIONS a INNER JOIN SYS.ENDPOINTS b ON a.Endpoint_ID=b.Endpoint_ID