Swati Gupta (3x Sitecore MVP) | Blogs

Error: Provider: SSL Provider, error: 0 - The certificate chain was issued by an authority that is not trusted in Sitecore 10.1.2 XP0  While I was installing Sitecore 10.1.2 XP0, I was getting this error "Error: Provider: SSL Provider, error: 0 - The certificate chain was issued by an authority that is not trusted in Sitecore 10.1.2 XP0". Solution: You'll need to alter two files, namely xconnect-xp0.json and sitecore-xp0.json. Look for occurrences of "Type": "InvokeSqlcmd" in both files, and whenever you encounter a match, include "TrustServerCertificate": true within its "Params" property. Overall, you'll find around 4 or 5 matches within xconnect-xp0.json and 1 match within sitecore-xp0.json where this modification is necessary. Default JSON: Updated JSON: I hope this will solve your issue.

 While I was installing Sitecore 10.1.2 XP01, I was getting this error " A connection was successfully established with the server, but then an error occurred during the login process". Install-SitecoreConfiguration : A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - The certificate chain was issued by an authority that is not trusted.) At C:\Swati\Sitecore\Sitecore 10.1.2 rev. 006578 (WDP XP1 packages)\XP1-SingleDeveloper.ps1:152 char:1 + Install-SitecoreConfiguration @XP1Parameters *>&1 | Tee-Object XP1-Si ... + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~     + CategoryInfo          : NotSpecified: (:) [Write-Error], WriteErrorException     + FullyQualifiedErrorId : Microsoft.PowerShell.Commands.WriteErrorException,Install-SitecoreConfiguration [TIME] 00:02:21 Invoke-Sqlcmd : A connection was successfully established with the ...