This topic describes how to configure WMI to show the server status in SQL Server tools in SQL Server. When connecting to servers, both the Registered Servers and Object Explorer components of SQL Server Management Studio, as well as SQL Server Configuration Manager, use Windows Management Instrumentation (WMI) to obtain the status of the SQL Server (MSSQLSERVER) and SQL Server 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
On the Start menu on the remote server, click Run.
In the Open box type wmimgmt.msc, and then click OK.
In the Windows Management Infrastructure program, right-click WMI Control (Local), and then click Properties.
In the WMI Control (Local) Properties dialog box, on the Security tab, expand Root, and then click CIMV2.
Click Security to open the Security for ROOT\CIMV2 dialog box.
Add a group or user to the Group or user names box and select it.
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.
This learning path covers Windows Management Instrumentation (WMI) and Common Information Model (CIM). These technologies help to access information about a computer. Additionally, both technologies provide local and remote access to management information from the operating system, computer hardware, and installed software.
Administer an SQL Server database infrastructure for cloud, on-premises and hybrid relational databases using the Microsoft PaaS relational database offerings.
Find out how to set an instance of SQL Server to start automatically. Learn about the default configuration, and see how to set the start mode to automatic.
Learn how to set options that the SQL Server Database Engine uses when it starts. View limitations and restrictions on making changes to startup parameters.
