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
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