Powershell script to determine which IP Address is the SQL Server instance running on the box is listening on.
Read this post on troubleshootingsql.com