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.
- Export the ConfigMgr SQL Server Identification Certificate from the database server and copy it to the management server.
- Right-click the copied certificate and select Install Certificate.
- Follow the wizard…
After importing the certificate CEViewer works without errors.