How to list available instances of SQL Servers using SMO in C#?

Take a look at the following links they may be helpful:

  • Enumerate SQL Server Instances in C#, Using ODBC
  • How to get a list of available SQL Servers using C# (MSDN)
  • Populating a list of SQL Servers

Alternatively you could change your code to this:

DataTable dt = SmoApplication.EnumAvailableSqlServers(false);
if (dt.Rows.Count > 0)
{
    foreach (DataRow dr in dt.Rows)
    {
        Console.WriteLine(dr["Name"]);
    }
}

Hope this solves your problem.

Related Contents:

  1. ExecuteReader requires an open and available Connection. The connection’s current state is Connecting
  2. C# Equivalent of SQL Server DataTypes
  3. How to directly execute SQL query in C#?
  4. How to execute an SSIS package from .NET?
  5. SqlConnection SqlCommand SqlDataReader IDisposable
  6. How to deploy application with sql server database on clients
  7. Bulk Update in C#
  8. How to catch SQLServer timeout exceptions
  9. EF 6 – How to correctly perform parallel queries
  10. Code to validate SQL Scripts
  11. Queuing in OneWay WCF Messages using Windows Service and SQL Server
  12. MultipleActiveResultSets=True or multiple connections?
  13. SqlConnection.Close() inside using statement
  14. Horrible performance using SqlCommand Async methods with large data
  15. Is it better to execute many sql commands with one connection, or reconnect every time?
  16. GO statements blowing up sql execution in .NET
  17. Is there a .NET equivalent to SQL Server’s newsequentialid()
  18. How to Specify Primary Key Name in EF-Code-First
  19. Upload CSV file to SQL server
  20. How do I save a stream to a file in C#?
  21. .NET Global exception handler in console application
  22. Transactions in .net
  23. How to find the most recent file in a directory using .NET, and without looping?
  24. How do I check for nulls in an ‘==’ operator overload without infinite recursion?
  25. What strategies and tools are useful for finding memory leaks in .NET?
  26. How to make Databinding type safe and support refactoring?
  27. How can I sign a file using RSA and SHA256 with .NET?
  28. No ConcurrentList in .Net 4.0?
  29. Custom Deserialization using Json.NET
  30. ASP.NET use SqlConnection connect MySQL
  31. .NET Integer vs Int16?
  32. Inconsistency in divide-by-zero behavior between different value types
  33. Lock (Monitor) internal implementation in .NET
  34. Can a unit test project load the target application’s app.config file?
  35. ZipArchive creates invalid ZIP file
  36. C# testing to see if a string is an integer?
  37. How do I perform an insert and return inserted identity with Dapper?
  38. What happens if i return before the end of using statement? Will the dispose be called?
  39. Deserialize json object with dynamic items in C#
  40. Random slot algorithm
  41. Key Events: ProcessCmdKey
  42. What size do you use for varchar(MAX) in your parameter declaration?
  43. Does “foreach” cause repeated Linq execution?
  44. Where is HttpContent.ReadAsAsync?
  45. Is there a way to force a C# class to implement certain static functions?
  46. Add offset to IntPtr
  47. OraOLEDB.Oracle provider is not registered on the local machine
  48. What options are available for Shell32.Folder.GetDetailsOf(..,..)?
  49. what is ‘this’ constructor, what is it for
  50. Why is EF generating SQL queries with unnecessary null-checks?

Leave a Comment