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
Results :
ServerName local_tcp_port local_net_address
DEVENV\2008R2 59663 192.168.63.223
Leave a Reply