finding the ip address of sql server

i need to find the ip address of the sql-server .....which is in a lan ...
can any one reply???

finding the ip address of sql server

try going to the DOS prompt and typing ping servername. servername being the name of the server sql server is on.

By default, SQL Server listens on TCP port 1433, IIRC. So try using a port scanner to sweep you network for servers listening on that port. I use nmap, there's a good NT port freely available at www.eeye.com. (Check the requirements -- you'll need the Winpcap driver).