Article ID: 000090529 Content Type: Troubleshooting Last Reviewed: 05/04/2022

Intel® Endpoint Management Assistant (Intel® EMA) Version 1.7 Certificate Chaining Issue

Environment

Intel® EMA v1.7

Windows Server 2016 Family*, Windows Server 2022 Family, Windows® 10 family, Windows Server 2012 family*

BUILT IN - ARTICLE INTRO SECOND COMPONENT
Summary

Steps to resolve Intel® EMA v1.7 Certificate Chaining Issue

Description

Error Message: Unable to get activation certificate chain from the database.
 

example image

example image

Resolution

Corrective Steps: Update SQL Stored Procedure:

  1. Launch Microsoft SQL Server Management Studio.
  2. Expand the EMADatabase.
  3. Expand Programmability > Stored Procedures.
  4. Scroll down to Security.Certificates_GetCertificatesByTenantId.
  5. Right-click and select Modify.
    example image
  6. Add Order By [CertificateId] and click Execute to update the stored procedure.
    example image
  7. Close Microsoft SQL Server Management Studio.

Related Products

This article applies to 1 products