更新WMI实例属性

Question

我正在尝试使用C#将TcpPort更新为"1433"，将TcpDynamicPorts更新为"，但我所做的任何更改都不会生效。我可以在C#中找到我想要更新的实例，然后确认实例中存在属性，但任何更新方法都会被忽略，不会出错。

try
{
    var searcher = new ManagementObjectSearcher(@"\.rootMicrosoftSqlServerComputerManagement10",
        "select * from ServerNetworkProtocolProperty where InstanceName='SQLEXPRESS' and ProtocolName='Tcp' and IPAddressName='IPAll'");
    foreach (ManagementObject instance in searcher.Get())
    {
        PutOptions options = new PutOptions();
        options.Type = PutType.UpdateOnly;
        foreach (var property in instance.Properties)
        {
            if (property.Name == "PropertyName" && (string)property.Value == "TcpPort")
            {
                instance.SetPropertyValue("PropertyStrVal", "1433");
            }
            if (property.Name == "PropertyName" && (string)property.Value == "TcpDynamicPorts")
            {
                instance.SetPropertyValue("PropertyStrVal", "");
            }
        }
        instance.Put(options);
    }
}
catch (ManagementException e)
{
    Console.WriteLine("An error occurred setting the WMI data: " + e.Message);
}

有人能告诉我做错了什么吗？当我通过WMI Explorer 2.0查询属性时，一切都保持不变。

Answer 1

如前所述，我认为写入注册表比访问WMI执行此任务更快，也更容易。所以你所要做的就是

private static void registryChangeSqlServerPort()
{
    /// SQL Server 2012 registry values
    ///      default instance
    ///          HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQL ServerMSSQL11.MSSQLSERVERMSSQLServerSuperSocketNetLibTCPIPAll
    ///
    ///      named instance
    ///          HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQL ServerMSSQL11.(InstanceName)MSSQLServerSuperSocketNetLibTCPIPAll
    string instanceName = "SQLEXPRESS";
    string key =
                string.Format("SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL11.{0}\MSSQLServer\SuperSocketNetLib\Tcp\IPAll",
                            instanceName);
    RegistryKey regKey = Registry.LocalMachine.OpenSubKey(key, true);
    /// change TcpPort settings 
    string valueName = "TcpPort";
    string value = "1433";            
    regKey.SetValue(valueName, value, RegistryValueKind.String);
    /// change TcpDynamicPort settings 
    valueName = "TcpDynamicPorts";
    value = "";
    regKey.SetValue(valueName, value, RegistryValueKind.String);
}

请参阅此SO问题以了解有关sql server的更多密钥。

请注意，在重新启动计算机之前，注册表中的任何更改都不会显示，因为它在启动时只加载一次。即使在观看regedit.exe时使用F5刷新也无法显示更改的值！