SSMS Object Explorer Icons

• Phil Parkin

  SSC Guru

  Points: 247180

  More actions

  February 21, 2020 at 1:56 pm

  Go to Answer

  #3727686

  After so many years of working with SQL Server, I should know the answer to this one, but I don't.

  I'm connected to QA and Prod servers, and, in Object Explorer, the icons look like this

  

  The connection to QA seems to be in a 'known' good state, whereas the connection to Prod has a blue question mark against it.

  Each of these connections is to a different SQL Server instance on different VMs.

  Any ideas what needs to happen to make my Prod connection icon turn green?

  Thanks!

  ---

• DinoRS

  SSCrazy

  Points: 2683

  More actions

  February 21, 2020 at 2:04 pm

  Answer

  #3727690

  Yes it's about wether WMI Service State queries work or not.

   

  Enabling these Windows Firewall rules

  Windows Management Instrumentation (WMI-In)

  Windows Management Instrumentation (DCOM-In)

  on your prod environment should turn the Icon green.

• Phil Parkin

  SSC Guru

  Points: 247180

  More actions

  March 3, 2020 at 9:22 pm

  #3730717

  DinoRS wrote:

  Yes it's about wether WMI Service State queries work or not.

  Enabling these Windows Firewall rules

  Windows Management Instrumentation (WMI-In)

  Windows Management Instrumentation (DCOM-In)

  on your prod environment should turn the Icon green.

  Thank you very much for the assistance, this worked!

  ---