Establish SQL Server connection encryption for Sitecore 10.4.1 successful connectivity
Sitecore 10.4.1 released last month. Prior to XM Cloud, one of the age-old practices of setting up a local Sitecore instance is by running the Sitecore Install Assistant(SIA). Good that Sitecore still supports running latest releases locally (apart from the Dockerised approach) in spite of maintaining XM Cloud with latest features/updates/hotfixes and is also a compelling reason to move your projects to the SaaS-based XM Cloud setup. The SIA tool also has a Quick Install Guide for XP Developer Workstation with hardware/software details apart from other pre-requisites. In those lines, Sitecore 10.4.1 supports SQL Server 2022 and 2019. One of the most important pre-requisites is to enable sql server ssl for secure connection between Sitecore instance and SQL Server. Although the Quick Install Guide for XP Developer Workstation has a workaround to bypass this secured connection in case of local setup, in this blog note, I’m going to cover the cleaner approach...
