Home Forums Article Discussions Article Discussions by Author Discuss content posted by Dan Hess Find which port SQL Server is using to establish connections RE: Find which port SQL Server is using to establish connections

  • September 8, 2011 at 2:22 am

    #1378401

    How about using this for a TSQL based solution?:

    SELECT DISTINCT(local_tcp_port) FROM sys.dm_exec_connections

    WHERE net_transport='TCP'