configure-wmi-to-show-server-status-in-sql-server-tools.md

title	description	author	ms.author	ms.date	ms.service	ms.subservice	ms.topic	helpviewer_keywords
Configure WMI to Show Server Status in SQL Server Tools	Configure WMI to Show Server Status in SQL Server Tools	markingmyname	maghan	01/19/2017	sql	ssms	conceptual	WMI Provider for Server Events, setting permissions WMI permissions [SQL Server]

Configure WMI to Show Server Status in SQL Server Tools

[!INCLUDESQL Server Azure SQL Database Synapse Analytics PDW]

This topic describes how to configure WMI to show the server status in SQL Server tools in [!INCLUDEssnoversion]. When connecting to servers, both the Registered Servers and Object Explorer components of [!INCLUDEssManStudioFull], as well as [!INCLUDEssNoVersion] Configuration Manager, use Windows Management Instrumentation (WMI) to obtain the status of the [!INCLUDEssNoVersion] (MSSQLSERVER) and [!INCLUDEssNoVersion] Agent (MSSQLSERVER) services. To display the status of the service, the user must have rights to remotely access the WMI object. The server must have WMI installed to configure this permission.

To configure WMI permission

1. On the Start menu on the remote server, click Run.

2. In the Open box type wmimgmt.msc, and then click OK.

3. In the Windows Management Infrastructure program, right-click WMI Control (Local), and then click Properties.

4. In the WMI Control (Local) Properties dialog box, on the Security tab, expand Root, and then click CIMV2.

5. Click Security to open the Security for ROOT\CIMV2 dialog box.

6. Add a group or user to the Group or user names box and select it.

7. In the Permissions for<group or user> box, select the Allow column, for the Remote Enable permission, for users whom you wish to remotely detect the service status.

See Also

Start, Stop, or Pause the SQL Server Agent Service