Sunday, February 24, 2019

How to find the tcp port number on SQL Server ?

SELECT
suser_sname() as username
,local_tcp_port
,session_id
,connect_time
,net_transport
,protocol_type
,encrypt_option
,auth_scheme
,last_read
,last_write
FROM   sys.dm_exec_connections

No comments:

Post a Comment