Sitecore has provided a graphical interface to install Sitecore 10, which makes the installation process more straightforward than it used to be. We have a step-by-step guide on “How to install Sitecore 10.3 using SIA”, which you can follow to install Sitecore on your machine. However, you may be haunted by an error stating, “SQL Provider, error: 0 - The certificate chain was by an authority that is not trusted.” In this blog, we will go through the changes you need to make in order to resolve the error.
The Cause of the Error
Sitecore’s installer generates a self-signed certificate in order to secure your instance. SQL uses an encrypted connection with Sitecore, and as we are using a self-signed certificate, which is not trusted, hence, the error.
Modify Files for Install
There are two files that you’ll need to modify, xconnect-xp0.json and sitecore-xp0.json. Search for "Type": "InvokeSqlcmd" in both, and wherever you find a match, add "TrustServerCertificate": true to its "Params" property. In total, there will 4 or 5 matches inside xconnect-xp0.json and 1 in sitecore-xp0.json where you’ll need to make this change.
Summary
That’s all, folks! A few changes, and you’re all set. DO NOT forget to delete the databases from your SQL Server installed by your previous installation before retrying the installation. You can check out our other blog if you’re facing issues while installing XM Scaled.
Happy decoding!
