Sitecore installation issue : The certificate chain was issued by an authority that is not trusted

 

Sitecore installation issue : The certificate chain was issued by an authority that is not trusted

While installing Sitecore 10.x, there is a high change we encounter this issue specially on Windows 11.

The certificate chain was issued by an authority that is not trusted.

After doing some investigation I found that the setting we will require to add the setting “TrustServerCertificate” : true in the following places in the installation JSON files:

xconnect-xp0.json
a. CreateShardApplicationDatabaseServerLoginInvokeSqlCmd

b. CreateShardManagerApplicationDatabaseUserInvokeSqlCmd

c. CreateShard0ApplicationDatabaseUserInvokeSqlCmd

d. CreateShard1ApplicationDatabaseUserInvokeSqlCmd

sitecore-XP0.json

a. AddSqlDatabasesToElasticPool

Here are the snapshots of the sections of the file xconnect-xp0.json

a. CreateShardApplicationDatabaseServerLoginInvokeSqlCmd

b. CreateShardManagerApplicationDatabaseUserInvokeSqlCmd

c. CreateShard0ApplicationDatabaseUserInvokeSqlCmd

d. CreateShard1ApplicationDatabaseUserInvokeSqlCmd

Here is the snapshot of the section of the file sitecore-XP0.json

a. AddSqlDatabasesToElasticPool