Checking to see if server available

Is there way to check if the server is live or active besides writing a sql query insert, delete, or add query and you get the -40 error when the server is not available
.

Is there a command or some type of sql query to verify if the server is active?

From SQL server you can check the connectivity by following command:

=> Use osql or sqlcmd to try " osql /S /E" or "osql /S\ /E" see whether connection works.
[Full article here]

From your c# code:

using System;
using System.Net.NetworkInformation;

namespace ASPDeveloperNet_BitShopPingSample
{
class Program
{
static void Main()
{
BitShopPing("www.ASPDeveloper.Net");
}

public static int BitShopPing(string hostname)
{
Ping ping = new Ping();
PingReply reply = ping.Send(hostname);
if (reply.Status == IPStatus.Success)
{
// TODO: Remove debugging output. Sample is a console app.
Console.WriteLine("Address: {0}", reply.Address.ToString());
Console.WriteLine("RoundTrip time: {0}", reply.RoundtripTime);
Console.WriteLine("Time to live: {0}", reply.Options.Ttl);
Console.WriteLine("Don't fragment: {0}", reply.Options.DontFragment);
Console.WriteLine("Buffer size: {0}", reply.Buffer.Length);
return (1);
}
else
{
return (0);
}
}

}

}

Thanks.

Please mark the answer if it helped you.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

David Smith15y ago
I using remote server. So you saying to try to ping the host name, and that will verify if the server is connected or not.
So the value is returning a bool
Amit Choudhary15y ago
From SQL server you can check the connectivity by following command:

=> Use osql or sqlcmd to try " osql /S /E" or "osql /S\ /E" see whether connection works.
[Full article here]

From your c# code:

using System;
using System.Net.NetworkInformation;

namespace ASPDeveloperNet_BitShopPingSample
{
class Program
{
static void Main()
{
BitShopPing("www.ASPDeveloper.Net");
}

public static int BitShopPing(string hostname)
{
Ping ping = new Ping();
PingReply reply = ping.Send(hostname);
if (reply.Status == IPStatus.Success)
{
// TODO: Remove debugging output. Sample is a console app.
Console.WriteLine("Address: {0}", reply.Address.ToString());
Console.WriteLine("RoundTrip time: {0}", reply.RoundtripTime);
Console.WriteLine("Time to live: {0}", reply.Options.Ttl);
Console.WriteLine("Don't fragment: {0}", reply.Options.DontFragment);
Console.WriteLine("Buffer size: {0}", reply.Buffer.Length);
return (1);
}
else
{
return (0);
}
}

}

}

Thanks.

Please mark the answer if it helped you.