Use of Graphical Interface to Install Sitecore
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!
Meet Karan Patel
Sitecore Developer
🚀🎸🎮
Karan is a Sitecore Certified Developer with over 2 years of experience building and implementing Sitecore solutions using ASP .NET MVC, React, Azure and AWS. He's an avid fan of Counter-Strike and can usually be found playing it if he is not developing. In his spare time, he likes to play guitar and cook Indian food.