| title | WMI Provider for Configuration Management Classes | ||
|---|---|---|---|
| description | Discover and implement the functionality that Windows Management Instrumentation provides. Choose from these classes for Configuration Manager. | ||
| author | markingmyname | ||
| ms.author | maghan | ||
| ms.date | 03/06/2017 | ||
| ms.service | sql | ||
| ms.subservice | wmi | ||
| ms.topic | reference | ||
| helpviewer_keywords |
|
||
| apilocation | sqlmgmproviderxpsp2up.mof | ||
| apiname | WMI Classes |
[!INCLUDE SQL Server]
The SQL Server WMI provider for Configuration Management exposes a set of classes that administrators, automation systems, and management tools can use to query and modify SQL Server instance settings, network libraries, protocol properties, error logs, and service configuration.
This article organizes the WMI classes into functional groups so that you can quickly find the class that applies to your configuration scenario.
These classes define how SQL Server clients resolve servers, use network libraries, and determine client‑level communication settings.
| Class | Description |
|---|---|
| ClientNetLibInfo | Returns information about installed client network libraries and protocols |
| ClientNetworkProtocol | Represents a specific client network protocol configuration (such as TCP/IP or Named Pipes) |
| ClientNetworkProtocolProperty | Exposes protocol‑level settings for client network protocols |
| ClientSettings | Provides high‑level client configuration, including resolution behavior and defaults |
| ClientSettingsGeneralFlag | Represents general client flags used to toggle or control client features |
These classes control server‑side networking options such as protocol enablement, IP bindings, and advanced communication properties.
| Class | Description |
|---|---|
| ServerNetworkProtocol | Represents a server‑side network protocol (TCP/IP, Named Pipes, Shared Memory) |
| ServerNetworkProtocolIPAddress | Represents IP address‑specific bindings and configuration for SQL Server network protocols |
| ServerNetworkProtocolProperty | Exposes protocol‑level configurable settings such as ports and packet behavior |
These classes provide information you can use to query or control SQL Server instance‑level settings, flags, and server environment details.
| Class | Description |
|---|---|
| ServerSettings | Defines general SQL Server instance configuration settings |
| ServerSettingsGeneralFlag | Represents configurable flags that enable or disable server‑level features |
| CInstance | Provides details for clustered SQL Server instances in failover cluster environments |
| SInstance | Represents a standalone SQL Server instance, including identity and configuration metadata |
Use these classes to manage SQL Server services, such as starting, stopping, and configuring them. You can also manage client and server alias definitions.
| Class | Description |
|---|---|
| SqlService | Represents a SQL‑related Windows service, such as SQL Server, SQL Agent, or Browser, and allows you to manage its state |
| SqlServiceAdvancedProperty | Exposes advanced service configuration properties |
| SqlServerAlias | Represents client‑side alias definitions for redirecting SQL Server connections |
These classes expose SQL Server error log metadata and error events. By using them, you can monitor or automate log parsing.
| Class | Description |
|---|---|
| SqlErrorLogEvent | Represents individual events recorded in the SQL Server error log |
| SqlErrorLogFile | Provides metadata about SQL Server error log files, including paths, sizes, and rollover behavior |
These classes support client and server certificate management for encrypted connections.
| Class | Description |
|---|---|
| SecurityCertificate | Represents certificates that SQL Server uses for encrypted network communication |