SSMS 2018 v18.7.1 - A certificate chain could not be built to a trusted root authority (0x800B010A)

download the following

1
2

http://www.microsoft.com/pki/certs/MicRooCerAut2011_2011_03_22.crt
http://www.microsoft.com/pki/certs/MicRooCerAut_2010-06-23.crt

mirror

right click each > Install certifiate > Choose manunally > Trusted Root Certification Authorities

run the damn instaler!

ref : https://community.spiceworks.com/topic/1643376-ssms-2016-install-issues https://social.msdn.microsoft.com/Forums/sqlserver/en-US/5ed119ef-1704-4be4-8a4f-ef11de7c8f34/a-certificate-chain-processed-but-terminated-in-a-root-certificate-which-is-not-trusted-by-the

origin - https://www.pipiscrew.com/?p=19354 ssms-2018-v18-7-1-a-certificate-chain-could-not-be-built-to-a-trusted-root-authority-0x800b010a