Find the port a connection is using

SELECT c.session_id, c.local_tcp_port, s.login_name, s.host_name, s.program_name

FROM sys.dm_exec_connections AS c INNER JOIN

sys.dm_exec_sessions AS s on c.session_id = s.session_id

WHERE c.local_tcp_port <> 1433

order by login_name