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.
Author |
Topic |
kmetic
Starting Member
3 Posts |
Posted - 2008-07-28 : 07:51:32
|
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 - 2008-07-28 : 08:04:47
|
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? |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-28 : 22:09:10
|
Try telnet to ip address and port number, or use odbcing. |
|
|
steel
Posting Yak Master
107 Posts |
Posted - 2008-07-29 : 12:01:29
|
hi Just try to telnet the sql server astelnet ipaddress 1433and also ping the server through command prompt that whether it is present on your network or not.Thank you. |
|
|
kmetic
Starting Member
3 Posts |
Posted - 2008-08-02 : 04:49:35
|
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. |
|
|
krishnarajeesh
Yak Posting Veteran
67 Posts |
Posted - 2008-08-04 : 01:17:02
|
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 |
|
|
|
|
|