May 16, 2003 at 5:59 am
Hi all,
Can any one tell, how to find IP number of a remote system??
ThanQ....
madhusudannaidugundapaneni
Madhu
May 16, 2003 at 6:51 am
If you mean through SQL Server, there is no native way. This is on just about every DBA's wish list for Yukon.
If you mean through other methods, it depends. From the command-line:
netstat -a
This will show you all current connections to your SQL Server. If you know the port SQL Server is listening on (usually TCP/1433), you'll be able to see what clients are connecting to SQL Server. Of course, if you have a lot of connections, this might be rather difficult.
If you know the name of the system, you might even be able to get away with:
ping <computer name>
This, of course, depends on whether or not your DNS/WINS has an entry for the system (unlikely for a remote client across the Internet is therefore very unlikely but if it's inside your internal LAN, a good possibility).
If you're talking about in general, say you want to find the IP address for http://www.microsoft.com, you can use nslookup from the command-line. Ping or tracert will likely work as well, because they before a query against DNS, which is what you're doing manually with nslookup.
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
K. Brian Kelley
@kbriankelley
May 17, 2003 at 4:57 am
Hi Kelley,
Thanx a lot.
madhusudannaidugundapaneni
Madhu
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply