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

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Register Now and get your question answered!
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 How to ping remote SQL server
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Starting Member

3 Posts

Posted - 07/28/2008 :  07:51:32  Show Profile  Reply with Quote

I'd like to know how to ping remote SQL server (2000). I can connect to it via Sql Query Analyzer and it works ok (server name is IP and SQL Server Authentication).

But sometimes the connection is broken, so i would like to ping it somehow, to see when and for how long this happens.

If I write to cmd 'ping -n 100000' it has 100% loss. Should I ping server's port also?

Thanks in advance,

Starting Member

3 Posts

Posted - 07/28/2008 :  08:04:47  Show Profile  Reply with Quote
I can also connect to it through Remote Desktop, but still no ping.

Maybe I could use some asp script or something to ping this server and save data for analyses?
Go to Top of Page

Flowing Fount of Yak Knowledge

7266 Posts

Posted - 07/28/2008 :  22:09:10  Show Profile  Reply with Quote
Try telnet to ip address and port number, or use odbcing.
Go to Top of Page

Posting Yak Master

107 Posts

Posted - 07/29/2008 :  12:01:29  Show Profile  Reply with Quote

Just try to telnet the sql server as

telnet ipaddress 1433

and also ping the server through command prompt that whether it is present on your network or not.

Thank you.
Go to Top of Page

Starting Member

3 Posts

Posted - 08/02/2008 :  04:49:35  Show Profile  Reply with Quote
telnet ip port works ok.
but i'm not familiar with telnet, how can I check if server is available like every second and write it to log file?

This server isn't in my network.

I will also try odbcping, when I get it.
Go to Top of Page

Yak Posting Veteran

67 Posts

Posted - 08/04/2008 :  01:17:02  Show Profile  Visit krishnarajeesh's Homepage  Reply with Quote
You can't ping a port as ping and TCP operate at different layers.

telnet <IP><port> will be a better option in this case.

Thanks & Best Regards,
Go to Top of Page
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.08 seconds. Powered By: Snitz Forums 2000