使用 WMI 提供程序来管理服务和网络设置

2017-03-06

WMI 提供程序是Microsoft管理控制台（MMC）用来管理 SQL Server 服务和网络协议的已发布接口。在 SMO 中，对象 ManagedComputer 表示 WMI 提供程序。

该 ManagedComputer 对象独立于与 SQL Server Server 实例建立的连接独立运行，并使用 Windows 凭据连接到 WMI 服务。

示例：

若要使用提供的任何代码示例，必须选择要在其中创建应用程序的编程环境、编程模板和编程语言。有关详细信息，请参阅 SQL Server 联机丛书中的“如何：在 Visual Studio .NET 中创建 Visual Basic SMO 项目”或“如何：在 Visual Studio .NET 中创建 Visual C# SMO 项目”。

对于使用 SQL Server WMI 提供程序的程序，必须包含 Imports 该语句才能限定 WMI 命名空间。将语句插入到其他 Imports 语句之后，再插入应用程序中的任何声明，例如：

Imports Microsoft.SqlServer.Management.Smo

Imports Microsoft.SqlServer.Management.Common

Imports Microsoft.SqlServer.Management.Smo.Wmi

在 Visual Basic 中停止和重启 SQL Server 服务Microsoft SQL Server 实例

此代码示例演示如何使用 SMO ManagedComputer 对象停止和启动服务。这提供了用于配置管理的 WMI 提供程序的接口。

在 Visual Basic 中使用 URN 字符串启用服务器协议

该代码示例演示如何使用 URN 对象标识服务器协议，然后启用协议。

'This program must run with administrator privileges.  
        'Declare the ManagedComputer WMI interface.  
        Dim mc As New ManagedComputer()  
  
        'Create a URN object that represents the TCP server protocol.  
        Dim u As New Urn("ManagedComputer[@Name='V-ROBMA3']/ServerInstance[@Name='MSSQLSERVER']/ServerProtocol[@Name='Tcp']")  
  
        'Declare the serverProtocol variable and return the ServerProtocol object.  
        Dim sp As ServerProtocol  
        sp = mc.GetSmoObject(u)  
  
        'Enable the protocol.  
        sp.IsEnabled = True  
  
        'propagate back to the service  
        sp.Alter()

在 PowerShell 中使用 URN 字符串启用服务器协议

该代码示例演示如何使用 URN 对象标识服务器协议，然后启用协议。

#This example shows how to identify a server protocol using a URN object, and then enable the protocol  
#This program must run with administrator privileges.  
  
#Load the assembly containing the classes used in this example  
[reflection.assembly]::LoadWithPartialName("Microsoft.SqlServer.SqlWmiManagement")  
  
#Get a managed computer instance  
$mc = New-Object -TypeName Microsoft.SqlServer.Management.Smo.Wmi.ManagedComputer  
  
#Create a URN object that represents the TCP server protocol  
#Change 'MyPC' to the name of the your computer   
$urn = New-Object -TypeName Microsoft.SqlServer.Management.Sdk.Sfc.Urn -argumentlist "ManagedComputer[@Name='MyPC']/ServerInstance[@Name='MSSQLSERVER']/ServerProtocol[@Name='Tcp']"  
  
#Get the protocol object  
$sp = $mc.GetSmoObject($urn)  
  
#enable the protocol on the object  
$sp.IsEnabled = $true  
  
#propagate back to actual service  
$sp.Alter()

在 Visual C 中启动和停止服务#

代码示例演示如何停止和启动 SQL Server 实例。

{   
   //Declare and create an instance of the ManagedComputer   
   //object that represents the WMI Provider services.   
   ManagedComputer mc;   
   mc = new ManagedComputer();   
   //Iterate through each service registered with the WMI Provider.   
  
   foreach (Service svc in mc.Services)  
   {   
      Console.WriteLine(svc.Name);   
   }   
//Reference the Microsoft SQL Server service.   
  Service Mysvc = mc.Services["MSSQLSERVER"];   
//Stop the service if it is running and report on the status  
// continuously until it has stopped.   
   if (Mysvc.ServiceState == ServiceState.Running) {   
      Mysvc.Stop();   
      Console.WriteLine(string.Format("{0} service state is {1}", Mysvc.Name, Mysvc.ServiceState));   
      while (!(string.Format("{0}", Mysvc.ServiceState) == "Stopped")) {   
         Console.WriteLine(string.Format("{0}", Mysvc.ServiceState));   
          Mysvc.Refresh();   
      }   
      Console.WriteLine(string.Format("{0} service state is {1}", Mysvc.Name, Mysvc.ServiceState));   
//Start the service and report on the status continuously   
//until it has started.   
      Mysvc.Start();   
      while (!(string.Format("{0}", Mysvc.ServiceState) == "Running")) {   
         Console.WriteLine(string.Format("{0}", Mysvc.ServiceState));   
         Mysvc.Refresh();   
      }   
      Console.WriteLine(string.Format("{0} service state is {1}", Mysvc.Name, Mysvc.ServiceState));  
      Console.ReadLine();  
   }   
   else {   
      Console.WriteLine("SQL Server service is not running.");  
      Console.ReadLine();  
   }   
}

在 PowerShell 中启动和停止服务