How to discover the client IP connected to SQL Server

This query gives you details of who is connected to an instance of SQL Server:

SELECT * FROM sys.dm_exec_connections

In my case, this helped me when I was trying to setup the security access to an Amazon RDS with SQL Server and the IP I was getting, no matter which method I used, did not match the one it was being connected to the database.