SqlDataSourceEnumerator.Instance.GetDataSources() does not locate local SQL server 2008 instance

by

You are skipping over servers that are not named instances. Modify your code:

public class SqlServerInstance
{
    public string ServerInstance { get; set; }
    public string Version { get; set; } 
}

public static List<SqlServerInstance> LocateSqlInstances()
{
    List<SqlServerInstance> results = new List<SqlServerInstance>();

    using (DataTable sqlSources = SqlDataSourceEnumerator.Instance.GetDataSources())
    {
        foreach (DataRow source in sqlSources.Rows)
        {
            string servername;
            string instancename = source["InstanceName"].ToString();

            if (!string.IsNullOrEmpty(instancename))
            {
                servername =  source["ServerName"].ToString() + '\\' + instancename;
            }
            else
            {
                servername = source["ServerName"].ToString();
            }

            results.Add(new SqlServerInstance (){ ServerInstance = servername, Version = source["Version"].ToString() });
        }
    }

    return results;
}

Please Note: SqlDataSourceEnumerator.Instance.GetDataSources() has drawbacks:

  • Subject to firewall rules (Blocked TCP/IP 1433 and UDP 1434)
  • Doesn’t find SQL Servers if the SQL Browser is off
  • Doesn’t find SQL Servers if they are hidden
  • List contents not guaranteed to be repeatable (due to timeouts). In fact, a subsequent call is quite likely to give a different list depending on the network I/O, server performance, number of servers on the network and other time-dependent constraints

Several sources say you have to make 2 calls to SqlDataSourceEnumerator.Instance.GetDataSources() …

Refs:

More Related Contents:

  1. Adding multiple parameterized variables to a database in c#
  2. How to connect to database from Unity
  3. What represents a double in sql server?
  4. SQL WHERE clause matching values with trailing spaces
  5. SqlParameter does not allows Table name – other options without sql injection attack?
  6. MultipleActiveResultSets=True or multiple connections?
  7. What’s the fastest way to bulk insert a lot of data in SQL Server (C# client)
  8. ‘datetime2’ error when using entity framework in VS 2010 .net 4.0
  9. Received an invalid column length from the bcp client for colid 6
  10. How can I convert ticks to a date format?
  11. 'Must declare the scalar variable "@thisuser".' [closed]
  12. I want to insert a record in DB and then need to return a row
  13. ExecuteReader requires an open and available Connection. The connection’s current state is Connecting
  14. What are the pros and cons to keeping SQL in Stored Procs versus Code [closed]
  15. How to monitor SQL Server table changes by using c#?
  16. Why use the INCLUDE clause when creating an index?
  17. What is the connection string for localdb for version 11
  18. How to find current transaction level?
  19. Mapping composite keys using EF code first
  20. SqlBulkCopy from a List
  21. Is there any way to embed power bi reports and dashboards in vb.net or C# desktop application with sql server 2008 database?
  22. EXISTS vs JOIN and use of EXISTS clause
  23. How can I retrieve a list of parameters from a stored procedure in SQL Server
  24. DateTime’s representation in milliseconds?
  25. What’s the best way to test SQL Server connection programmatically?
  26. Entity Framework 6 transaction rollback
  27. Can’t get sql server compact 3.5 / 4 to work with ASP .NET MVC 2
  28. How to pass string array in SQL parameter to IN clause in SQL
  29. Should the order of LINQ query clauses affect Entity Framework performance?
  30. How do I connect to a SQL database from C#?

Leave a Comment