Symptom
You get the following message on OMS (SQL Assessment) when you click its tile:
“This computer is successfully connected, but it is not being assessed by this solution pack because it does not meet the requirements to be a valid assessment target. Review the documentation for this solution pack to verify the Microsoft server role(s) and/or software required to assess a target. You can still view assessment results from other computers that meet the requirements.”
Cause
This is related to the update of the SQL Assessment solution.
Resolution
We need to enable logging on the agents to figure out what was going on but also checking the. Eventually, you can follow this procedure to fix the issue:
- Stop the ‘Microsoft Monitoring Agent‘ service
- Cleared the agent cache by deleting or renaming the ‘C:\Program Files\Microsoft Monitoring Agent\Agent\Health Service State‘ directory
- Changing the timestamp of the bellow registry, so that the assessment would run again (if not, you have to wait seven days):
Computer\HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\HealthService\Parameters\Management Groups\AOI-9519a7c6-f9d9-42c2-bca7-8cd8bed49692\Solutions\SQLAssessment |
- Starting the agent and waiting for it to download all the management packs again and rerun the SQL Assessment