דצמ23
Written by:
ronen ariely
23/12/2020 11:41 
Introduction
SQL Server Configuration Manager and SQL Server Management Studio display the status of services by using the different icons. The service status directly depends on the account which is sued to connect the service, which means the use that is launching the tool (SSMS or SSCM).
In this post I will summarize the different options. Part of the information in this post was taken from the official documentation while several scenario are not documented and the information is based on my tests and research.
If you find any mistake or if you have more information then please contact me and help me fill the information to share it with the community. Thanks.
SQL Server Configuration Manager and SQL Server Management Studio icons
SQL Server Configuration Manager (SSCM) and SQL Server Management Studio (SSMS) use WMI to query for information about the status of the services.
| Sample | Description | Status | Tool |
 | Green arrow on the icon | service is running well
| SQL Server Configuration Manager
|
 | Red square on the icon
| service is stopped
| SQL Server Configuration Manager |
 | Two vertical blue lines on the icon | service is paused
| SQL Server Configuration Manager
|
 | A white arrow on a green circle icon
| service is started
| SQL Server Management Studio |
 | A white square on a red circle icon
| service is stopped
| SQL Server Management Studio
|
 | Two vertical white lines on a blue circle icon
| service is paused
| SQL Server Management Studio
|
| white question mark on blue circle icon (same as white circle as much as I found)
| Status Unknown | SQL Server Management Studio
|
| white circle (same as above)
If the status is "un-known" then (1) Make sure “Windows Management Instrumentation” service is running, (2) Make sure that the firewall is not blocking WMI communication, (3) Make sure that you are able to open SQL Server Configuration Manager, which uses WMI. (4) Make sure the user have permission to all the entities which the tool try to present. Try to connect as administrator.
| Status Unknown
| SQL Server Management Studio
|
| Blue service icon | Remote connection to azure
| SQL Server Management Studio
|
| White Cloud | Connecting Azure Analysis Services | SQL Server Management Studio
|
| | | | |
| | | | |
| | | | |
| | | | |
find the status using SSMS GUI
We can change or find the status by right click on the service:
Find the status using Transact SQL
select * from sys.dm_server_services
Recourses and more to read
https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/start-stop-pause-resume-restart-sql-server-services?view=sql-server-2017
.