SqlDataSourceEnumerator.Exemple.GetDataSources() ne permet pas de localiser local instance de SQL server 2008

Un grand merci à Mitch pour la grande réponse qu'il met de l'ensemble. Cependant, ce que j'ai fait finalement, c'est comme le suivant:

J'ai deux méthodes distinctes pour obtenir des serveurs locaux et distants instance respectivement. Les instances locales sont extraites de la base de registre. Vous avez besoin de rechercher à la fois WOW64 et WOW3264 ruches à obtenir à la fois de SQL server 2008 (64bit) et SQL server Express (32 bits)

voici le code que j'utilise:

///<summary>
  /// get local sql server instance names from registry, search both WOW64 and WOW3264 hives
  ///</summary>
  ///<returns>a list of local sql server instance names</returns>
  public static IList<string> GetLocalSqlServerInstanceNames()
  {
     RegistryValueDataReader registryValueDataReader = new RegistryValueDataReader();

     string[] instances64Bit = registryValueDataReader.ReadRegistryValueData(RegistryHive.Wow64,
                                                                             Registry.LocalMachine,
                                                                             @"SOFTWARE\Microsoft\Microsoft SQL Server",
                                                                             "InstalledInstances");

     string[] instances32Bit = registryValueDataReader.ReadRegistryValueData(RegistryHive.Wow6432,
                                                                             Registry.LocalMachine,
                                                                             @"SOFTWARE\Microsoft\Microsoft SQL Server",
                                                                             "InstalledInstances");

     FormatLocalSqlInstanceNames(ref instances64Bit);
     FormatLocalSqlInstanceNames(ref instances32Bit);

     IList<string> localInstanceNames = new List<string>(instances64Bit);

     localInstanceNames = localInstanceNames.Union(instances32Bit).ToList();

     return localInstanceNames;
  }

public enum RegistryHive
{
Wow64,
Wow6432
}
public class RegistryValueDataReader
{
private static readonly int KEY_WOW64_32KEY = 0x200;
private static readonly int KEY_WOW64_64KEY = 0x100;
private static readonly UIntPtr HKEY_LOCAL_MACHINE = (UIntPtr)0x80000002;
private static readonly int KEY_QUERY_VALUE = 0x1;
[DllImport("advapi32.dll", CharSet = CharSet.Unicode, EntryPoint = "RegOpenKeyEx")]
static extern int RegOpenKeyEx(
UIntPtr hKey,
string subKey,
uint options,
int sam,
out IntPtr phkResult);
[DllImport("advapi32.dll", SetLastError = true)]
static extern int RegQueryValueEx(
IntPtr hKey,
string lpValueName,
int lpReserved,
out uint lpType,
IntPtr lpData,
ref uint lpcbData);
private static int GetRegistryHiveKey(RegistryHive registryHive)
{
return registryHive == RegistryHive.Wow64 ? KEY_WOW64_64KEY : KEY_WOW64_32KEY;
}
private static UIntPtr GetRegistryKeyUIntPtr(RegistryKey registry)
{
if (registry == Registry.LocalMachine)
{
return HKEY_LOCAL_MACHINE;
}
return UIntPtr.Zero;
}
public string[] ReadRegistryValueData(RegistryHive registryHive, RegistryKey registryKey, string subKey, string valueName)
{
string[] instanceNames = new string[0];
int key = GetRegistryHiveKey(registryHive);
UIntPtr registryKeyUIntPtr = GetRegistryKeyUIntPtr(registryKey);
IntPtr hResult;
int res = RegOpenKeyEx(registryKeyUIntPtr, subKey, 0, KEY_QUERY_VALUE | key, out hResult);
if (res == 0)
{
uint type;
uint dataLen = 0;
RegQueryValueEx(hResult, valueName, 0, out type, IntPtr.Zero, ref dataLen);
byte[] databuff = new byte[dataLen];
byte[] temp = new byte[dataLen];
List<String> values = new List<string>();
GCHandle handle = GCHandle.Alloc(databuff, GCHandleType.Pinned);
try
{
RegQueryValueEx(hResult, valueName, 0, out type, handle.AddrOfPinnedObject(), ref dataLen);
}
finally
{
handle.Free();
}
int i = 0;
int j = 0;
while (i < databuff.Length)
{
if (databuff[i] == '\0')
{
j = 0;
string str = Encoding.Default.GetString(temp).Trim('\0');
if (!string.IsNullOrEmpty(str))
{
values.Add(str);
}
temp = new byte[dataLen];
}
else
{
temp[j++] = databuff[i];
}
++i;
}
instanceNames = new string[values.Count];
values.CopyTo(instanceNames);
}
return instanceNames;
}
}
SqlDataSourceEnumerator.Instance.GetDataSources() is used to get remote sql server instances. 

À la fin, je viens de fusionner l'instance distante de la liste et l'instance locale liste pour produire le résultat final.

OriginalL'auteur sean717

var registryViewArray = new[] { RegistryView.Registry32, RegistryView.Registry64 };
foreach (var registryView in registryViewArray)
{
using (var hklm = RegistryKey.OpenBaseKey(RegistryHive.LocalMachine, registryView))
using (var key = hklm.OpenSubKey(@"SOFTWARE\Microsoft\Microsoft SQL Server"))
{
var instances = (string[]) key?.GetValue("InstalledInstances");
if (instances != null)
{
foreach (var element in instances)
{
if (element == "MSSQLSERVER")
Console.WriteLine(System.Environment.MachineName);
else
Console.WriteLine(System.Environment.MachineName + @"\" + element);
}
}
}
}
Console.ReadKey();

OriginalL'auteur isxaker