Click here to Skip to main content
15,886,724 members
Articles / Database Development / SQL Server

How to enum SQL Server instances in network

Rate me:
Please Sign up or sign in to vote.
4.96/5 (9 votes)
13 Feb 2013CPOL 60.8K   2.5K   13  
This tip is desired for those who want to list all available SQl Server instances that are in a network.
Public Class Form1

    Public Sub New()

        ' This call is required by the Windows Form Designer.
        InitializeComponent()

        ' Add any initialization after the InitializeComponent() call.
        Dim dt As Data.DataTable = Nothing, dr As Data.DataRow = Nothing

        Try
            dt = Sql.SqlDataSourceEnumerator.Instance.GetDataSources()


            For Each dr In dt.Rows
                Me.CmbSQLInstance.Items.Add(dr.Item(0).ToString)
            Next
            Me.DGVSQLInstances.DataSource = dt

        Catch ex As System.Data.SqlClient.SqlException
            MsgBox(ex.Message, MsgBoxStyle.Exclamation, "Error!")

        Catch ex As Exception
            MsgBox(ex.Message, MsgBoxStyle.Exclamation, "Error!")

        Finally
            dr = Nothing
            dt = Nothing
        End Try


    End Sub

    Protected Overrides Sub Finalize()
        MyBase.Finalize()
    End Sub
End Class

By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.

If a file you wish to view isn't highlighted, and is a text file (not binary), please let us know and we'll add colourisation support for it.

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


Written By
Team Leader
Poland Poland
I'm a lawyer, teacher/trainer and author of VBA programming book (only polish version). Programming is my hobby and the source of extra earnings!
  1. C#
  2. SQL
  3. Linq
  4. VB/VBA/VB.NET
  5. XML & XSL
  6. Python
  7. JCL


If you want to contact me... find me on LinkedIn.

Comments and Discussions