Deploy SQL Server Certificate to your ConfigMgr Consoles

While working with CEViewer (from the System Center 2012 R2 Configuration Manager Toolkit) I noticed an error after connecting to the Site Server: A connection was succesfully established with the server, but then an error occured during the login process. (provider: SSL Provider, error: 0 – The certificate chain was issued by an authority that is not trusted.)

I then dawned on me. I forgot to export the certificate from the database server to the management server.

  1. Export the ConfigMgr SQL Server Identification Certificate from the database server and copy it to the management server.
  2. Right-click the copied certificate and select Install Certificate.
  3. Follow the wizard…

After importing the certificate CEViewer works without errors.