Searching for installed SQL Server Instances

[Ekjon]

Hi, In my application - I need to search for installed SQL Server instances on the wotkstation or network; so I can create the appropriate connection string and also for allowing the user to install sql server express if no sql server is installed. Is there any way? Thanks, Ekjon

[dan sh]

Check out SqlDataSourceEnumerator class. That will help you getting the list of SQL server instances on the network.

It's not necessary to be so stupid, either, but people manage it. - Christian Graus, 2009 AD

[Dambod]

u can use sqldatasourceenumerator to get the available sql instances like Dim dt As New DataTable dt= Sql.SqlDataSourceEnumerator.Instance.GetDataSources DataGridView1.DataSource = dt.AsDataView

[Ekjon]

Thanks d@nish and Dambod - it was very helpful.