Ping Another Server's IP???

[David Lozzi]

I need to determine from ASP if the database server is up and running, and
if it isn't ping another database server. I posted this before about a
different client, and I was told to request a file from the IIS server, and
if I cannot retrieve it, the server is not there. I cannot use this method
due to one database box being Solaris and the other UNIX, so I need to ping.

Thanks!
David Lozzi

[Aaron Bertrand - MVP]

Couldn't you simply try establishing a database connection to the other
database server? That's what it's there for, after all?

Besides, pinging the server only tells you that the external nic is enabled
and it is accepting traffic. Never mind that the server might be set to
"hide" from pings (e.g. ping www.microsoft.com, you know it exists, right?),
even if a ping is positive, that doesn't tell you whether the database
service is running, or if it will accept your credentials when you log on.

--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/


"David Lozzi" <dl****@delphi-ts.com> wrote in message
news:OD**************@TK2MSFTNGP11.phx.gbl...

I need to determine from ASP if the database server is up and running, and
if it isn't ping another database server. I posted this before about a
different client, and I was told to request a file from the IIS server, and if I cannot retrieve it, the server is not there. I cannot use this method
due to one database box being Solaris and the other UNIX, so I need to ping.
Thanks!
David Lozzi

[David Lozzi]

WOW, thank you. Its been a rough day for me ;)

Thanks,
David Lozzi
"Aaron Bertrand - MVP" <aa***@TRASHaspfaq.com> wrote in message
news:%2****************@TK2MSFTNGP10.phx.gbl...

Couldn't you simply try establishing a database connection to the other
database server? That's what it's there for, after all?

Besides, pinging the server only tells you that the external nic is enabled and it is accepting traffic. Never mind that the server might be set to
"hide" from pings (e.g. ping www.microsoft.com, you know it exists, right?), even if a ping is positive, that doesn't tell you whether the database
service is running, or if it will accept your credentials when you log on.

--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/


"David Lozzi" <dl****@delphi-ts.com> wrote in message
news:OD**************@TK2MSFTNGP11.phx.gbl...

I need to determine from ASP if the database server is up and running, and if it isn't ping another database server. I posted this before about a
different client, and I was told to request a file from the IIS server,

and

if I cannot retrieve it, the server is not there. I cannot use this method due to one database box being Solaris and the other UNIX, so I need to

ping.

Thanks!
David Lozzi