sqlserver template not active in ump mcs

Document ID : KB000123491
Last Modified Date : 21/12/2018
Show Technical Document Details
sqlserver_mcs_templates deployed from archive to primaryHub but profile does not come available in UMP Monitoring (MCS)

Message in UMP/MCS :
Profile Type unavailable because the sqlserver probe is not in the local archive, does not have a valid license, or is missing other dependencies.

SQLserver probe requires the visual studio 2008 redistributable packages (x86 and x64) to be in the archive
In this case only the x64 package was in the archive and thus MCS could not find the pre-requisites.
Ensure both x86 and x64 packages are in the archive