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
Posted At : Jul 07, 2010 17:26 PM
| Posted By : Ed Tabara
Related Categories: SQL
Related Categories: SQL
This hsould help you determine on which port(s) connections were coming through from the client to the database server:
Comments



