en-UShe-IL
You are here:   Blog
Register   |  Login

Blog Archive:

Maximize
* Can be used in order to search for older blogs Entries

Search in blogs


Blog Categories:

Maximize
* Can be used in order to search for blogs Entries by Categories

Blog Tags:

Maximize
* Can be used in order to search for blogs by keywords

TNWikiSummit


Awared MVP

 


Microsoft® Community Contributor 


Microsoft® Community Contributor


 Read this before you use the blog! Maximize

Recent Entries

Minimize
דצמ23

Written by: ronen ariely
23/12/2020 11:41 RssIcon

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.

SampleDescription Status Tool
Green arrow on the iconservice 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 iconservice 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 UnknownSQL 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 iconRemote connection to azure
SQL Server Management Studio

White CloudConnecting Azure Analysis ServicesSQL 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

.