SQL Server : Find SQL Server TCP Port and IP Address

SQL Server : Find SQL Server TCP Port and IP Address

SELECT @@SERVERNAME AS ServerName , local_tcp_port,local_net_address
FROM   sys.dm_exec_connections
WHERE  session_id = @@SPID

SELECT @@SERVERNAME AS ServerName , local_tcp_port,local_net_address

FROM sys.dm_exec_connections

WHERE session_id = @@SPID

Results :
ServerName local_tcp_port local_net_address
DEVENV\2008R2 59663 192.168.63.223