tsql - Connection Details - sys.dm_exec_connections

Show properties of current connection -

select session_id, auth_scheme, net_transport , client_net_address
from sys.dm_exec_connections
where @@SPID = session_id