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

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

kmetic
Starting Member

3 Posts

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

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 xxx.xxx.xxx.xxx' it has 100% loss. Should I ping server's port also?

Thanks in advance,
Simon

kmetic
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

rmiao
Flowing Fount of Yak Knowledge

USA
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

steel
Posting Yak Master

107 Posts

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

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

kmetic
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

krishnarajeesh
Yak Posting Veteran

India
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,
Krishna
Go to Top of Page
  Previous Topic Topic Next Topic  
 New 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