Get Client and Server IP running MSSQL
SELECT client_net_address ClientIP,local_net_address ServerIP FROM sys.dm_exec_connections WHERE ...
SELECT client_net_address ClientIP,local_net_address ServerIP FROM sys.dm_exec_connections WHERE ...