• Duplicate post: http://www.sqlservercentral.com/Forums/FindPost1672886.aspx

    In SQL Server 2012 you can query a DMV that was absent in 2008 to discover tcp ports:

    SELECT *

    FROM sys.dm_tcp_listener_states

    -- Gianluca Sartori