Smo does not show 2008 SQL Server instances when 2005 instances exist

Question

I am trying to enumerate all SQL Server instances installed on a local machine. I am using SmoApplication.EnumAvailableSqlServers(true). However, only SQL Server Express 2005 instances are shown. Default 2008 instance is not shown at all!

I tried 2 other solutions with SqlServerRegistrations.EnumRegisteredServers() and SqlDataSourceEnumerator.Instance.GetDataSources() but they do not work either.

There is another question regarding this (http://stackoverflow.com/questions/1433435/cant-enumerate-sql-server-2008-registered-servers-with-smo) but it unfortunately has no answer.

Answer 1

Here's another alternative you could try using the ManagedComputer Class (Namespace: Microsoft.SqlServer.Management.Smo.Wmi).

ManagedComputer mc = new ManagedComputer();

foreach (ServerInstance si in mc.ServerInstances)
{
      Console.WriteLine(si.Name);
}