69 lines
2.1 KiB
C#
69 lines
2.1 KiB
C#
using System;
|
|
using System.Collections.Generic;
|
|
using System.Linq;
|
|
using System.Text;
|
|
using System.Threading.Tasks;
|
|
|
|
namespace CheckRemoteeDosLocal
|
|
{
|
|
class Program
|
|
{
|
|
|
|
static System.Net.NetworkInformation.Ping nip;
|
|
static System.Data.SqlClient.SqlConnectionStringBuilder cb;
|
|
static System.Data.SqlClient.SqlConnection coeDosLocal;
|
|
|
|
static void init()
|
|
{
|
|
cb = new System.Data.SqlClient.SqlConnectionStringBuilder()
|
|
{
|
|
DataSource = "192.168.113.160",
|
|
InitialCatalog = "eDosLocal",
|
|
IntegratedSecurity = false,
|
|
NetworkLibrary = "dbmssocn",
|
|
TrustServerCertificate = true,
|
|
Authentication = System.Data.SqlClient.SqlAuthenticationMethod.SqlPassword,
|
|
UserID = "sa",
|
|
Password = "HPHEdos"
|
|
};
|
|
|
|
}
|
|
static bool openCon(int ipLastByte)
|
|
{
|
|
bool rv = false;
|
|
cb.DataSource = $"192.168.113.{ipLastByte}";
|
|
|
|
nip = new System.Net.NetworkInformation.Ping();
|
|
var pr = nip.Send(cb.DataSource);
|
|
if (pr.Status == System.Net.NetworkInformation.IPStatus.Success)
|
|
{
|
|
coeDosLocal = new System.Data.SqlClient.SqlConnection(cb.ConnectionString);
|
|
try
|
|
{
|
|
coeDosLocal.Open();
|
|
rv = true;
|
|
}
|
|
catch (System.Exception ex)
|
|
{
|
|
System.Console.WriteLine($"No sql open from ${cb.DataSource} : {ex.Message}");
|
|
}
|
|
}
|
|
else
|
|
System.Console.WriteLine($"No answer from ${cb.DataSource}");
|
|
return rv;
|
|
}
|
|
|
|
static void Main(string[] args)
|
|
{
|
|
init();
|
|
for (int ix = 160; ix <= 170; ix++)
|
|
{
|
|
if (openCon(ix))
|
|
{
|
|
System.Console.WriteLine($"sql ok from ${cb.DataSource} ");
|
|
coeDosLocal.Close();
|
|
}
|
|
}
|
|
}
|
|
}
|
|
}
|