CODEWITHSUNDEEP
c#sql-serverado.net
shamim
shamim

Reputation: 6768

How to get SQL Server names without connection string

Work on C#, in one of my application I need to get the SQL Server names. In network I have SQL Server 2000, 2005, 2008. For my application I want to get the server names.

private string strConnection = @"Data Source=xxx;Initial Catalog=xxx;Integrated Security=True";

SqlConnection objConnection = new SqlConnection(strConnection);
objConnection.Open();
SqlCommand objCommand = new SqlCommand(“xxxxxxx”);
objCommand.ExecuteNonQuery();
objConnection.Close();

If I know strConnection then I can use the above syntax. But I don’t know the server name. In my application first I need to know the server name. I need help to get the server names.

Upvotes: 3

Views: 2492

Answers (3)

bilash.saha
bilash.saha

Reputation: 7316

You can use Use SmoApplication.EnumAvailableSqlServers method to Enumerate a list of available instances of SQL Server.

Upvotes: 0

marc_s
marc_s

Reputation: 755227

There are quite a few options how to find those in code - see:

There are quite a few more ways to find your SQL Servers - do these options work for you??

Upvotes: 5

SQLMenace
SQLMenace

Reputation: 135141

Take a look at Scan network for SQL Server instances to get some ideas about SQL Ping

Upvotes: 0

Related Questions