Find remote server IP address - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Find remote server IP address

Author

Topic

rshivagami
Starting Member

3 Posts

Posted - 2006-03-07 : 17:07:05

I know the name of the SQL Server I need to connect to, but how do I get its IP Address?

Thanks.

twhelan1
Yak Posting Veteran

71 Posts

Posted - 2006-03-07 : 17:17:27

Try pinging it from a command prompt? Ping does a reverse lookup and gives you the IP address.

~Travis

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2006-03-07 : 17:25:21

Why do you need the IP address? If DNS resolves it for you, then there should be no reason to use it.

Tara Kizer
aka tduggan

afrika
Master Smack Fu Yak Hacker

2706 Posts

Posted - 2006-03-08 : 04:44:45

Welcome, welcome, welcome to SQLTeam.

Take note, your sql db might be on a seperate dedicated server or behind a firewall and not sitting directly on the internet. If its a remote server, your DNS would do your name resolution for you. Stick to your db name.

Afrika

rshivagami
Starting Member

3 Posts

Posted - 2006-03-08 : 09:31:02

'ping' from command prompt gives me the error 'unknown host'. I need to know the IP Addr as there is some other place that talks about servers in terms of IP Addr and I need to be able to compare them both.

AndrewMurphy
Master Smack Fu Yak Hacker

2916 Posts

Posted - 2006-03-08 : 10:47:55

Then ask the server admin/owner....and if you are it....go to the console.

rshivagami
Starting Member

3 Posts

Posted - 2006-03-08 : 10:50:28

Thats what I was thinking of doing but was curious to know if I can find it myself.

activecrypt
Posting Yak Master

165 Posts

Posted - 2006-03-08 : 22:09:18

Hi,
assuming that you are talking about remote hosted SQL Server , when you are able to ping with the name for e.g. yoursrv.com ,it will returns IP , if it says "unknown host" then recheck the network configurations... it must return IP address ... what it will return while you type nslookup at command prompt ?!

Regards

Andy Davis
Sql Shield Team
--------------------------------------------
SQL Server Encryption Software
http://www.sql-shield.com

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2006-03-09 : 12:18:34

If you can connect to the SQL Server already via its hostname and if you are are a sysadmin, then you can find out the IP address by running the following command in Query Analyzer:

EXEC master.dbo.xp_cmdshell 'ipconfig'

Tara Kizer
aka tduggan

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources