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

Results :
ServerName local_tcp_port local_net_address
DEVENV\2008R2 59663 192.168.63.223

Leave a Reply

Your email address will not be published. Required fields are marked *

*