Intel® Endpoint Management Assistant (Intel® EMA) Version 1.7 Certificate Chaining Issue
Content Type: Troubleshooting | Article ID: 000090529 | Last Reviewed: 05/04/2022
Support Knowledge Base
Environment
Operating System
Windows Server 2016 Family*, Windows Server 2022 Family, Windows® 10 family, Windows Server 2012 family*
Intel® EMA v1.7
Description
Error Message: Unable to get activation certificate chain from the database.
Resolution
Corrective Steps: Update SQL Stored Procedure:
- Launch Microsoft SQL Server Management Studio.
- Expand the EMADatabase.
- Expand Programmability > Stored Procedures.
- Scroll down to Security.Certificates_GetCertificatesByTenantId.
- Right-click and select Modify.
- Add Order By [CertificateId] and click Execute to update the stored procedure.
- Close Microsoft SQL Server Management Studio.