C# all SQL Server list that are visible

by Roland Schumacher alias GENiALi 15. Oktober 2007 -- 164 words -- 1 mal gelesen

This could be something you could use every now and then.
A list of SQL servers that are visible in the network.

Using c#, this is pretty simple.

a DataGridView is dgv. On the form a button (cmdSearchSqlServers) there is so
and a DataGridView (dgv).

   1:  using System;

   2:  using System.data.SQL;

   3:  using System.Windows.Forms;

4:

   5:  namespace SqlServerBrowser

   6:  {

   7:     public partial class Form1: form

   8:     {

   9:        public Form1()

  10:        {

  11:           InitializeComponent();

  12:        }

13:

  14:        private void cmdSearchSqlServers_Click(object_sender,_EventArgs_e)

  15:        {

  16:           SqlDataSourceEnumerator sqlServers SqlDataSourceEnumerator.Instance; =

  17:           dgv.DataSource sqlServers.GetDataSources(); =

  18:        }

  19:     }

  20:  }

To get a list of all SQL Server that are visible in the network.
That mean that the SQL Server and the network must also join.

Port 1433 (Standartport for SQL Server communication) cannot
locked (firewall and network) and the SQL Browser service on the
SQL Server must be running.

Tags: SQL Server, port 1433

It runs: Judas Priest - live in London CD2 - living after midnight

9d50910b-74f1-4633-be28-abefff502dfd|0|.0

Tags:

GENiALi's Blog