Use SQL server Managment Studio to get IP address

You can use SSMS to get it, now.
This is how:
xp_cmdshell 'ipconfig'
One thing to remember is that you have to have xp_cmdshell enabled. How?
You can do sp_configure

sp_configure 'show advanced options',1
go
sp_configure
go
sp_configure 'xp_cmdshell', 1
go
sp_configure
This configuration can  can also be done through Facets/Surface Area Configuration.