Discover All Instances of SQL Server on Your Network - CSharp Database

CSharp examples for Database:Connection

  1. HOME
  2. CSharp
  3. Database
  4. Connection

Description

Discover All Instances of SQL Server on Your Network

Demo Code


using System;//from   w  w w.  ja va  2s  .co m
using System.Data;
using System.Data.Sql;

class MainClass
    {
        public static void Main(string[] args)
        {
            using (DataTable SqlSources = SqlDataSourceEnumerator.Instance.GetDataSources())
            {
                Console.WriteLine("Discover SQL Server Instances:");
                foreach (DataRow source in SqlSources.Rows)
                {
                    Console.WriteLine(" Server Name:{0}", source["ServerName"]);
                    Console.WriteLine("   Instance Name:{0}", source["InstanceName"]);
                    Console.WriteLine("   Is Clustered:{0}", source["IsClustered"]);
                    Console.WriteLine("   Version:{0}", source["Version"]);
                }
            }

        }
    }

Result


Related Tutorials