Submit a ticketCall us

Solarwinds & Cisco Live! Barcelona
Join us from the 29th of January to the 2nd of February at Cisco Live 2018 in Barcelona, where we will continue to show how monitoring the network with SolarWinds will keep you ahead of the game. At our booth (WEP 1A), we will demonstrate how SolarWinds network solutions can help. As a bonus, we are also hosting a pre-event webinar - Blame the Network, Hybrid IT Edition with our SolarWinds Head Geek™, Patrick Hubbard on January 24th - GMT (UTC+0): 10:00 a.m. to 11:00 a.m. There's still time to RSVP.

Home > Success Center > Server & Application Monitor (SAM) > AppInsight for SQL status is grey or red for the sqlserver.exe process but is green for all other components

AppInsight for SQL status is grey or red for the sqlserver.exe process but is green for all other components

Updated May 8, 2017

Overview

The AppInsight for SQL status shows as grey or red for a process, yet all the components show as green.

For example: When using the RPC method, the sqlserver.exe process shows as grey. When using the WMI method, the same process shows as red. However, the icon for the components shows as green.

 

When debugging the application and inserting the command into wbemtest, the command line value is empty. When displaying the command line for the sqlserver.exe process in Windows Task Manager, the command line is filled out.

Environment

  • All SAM versions
  • Use of AppInsight for SQL to monitor SQL Servers

Cause 

The WMI account used in the command line does not have administrator access at the host level.  

Resolution

Verify that the user account credentials used to log into AppInsight for SQL have local administrator rights at the host level.

 

Please see the following references for additional information:

 

Last modified

Tags

Classifications

Public