“The certificate chain was issued by an authority that is not trusted” when connecting DB in VM Role from Azure website

2022 Update – This answer (as comments point out) provides an explanation and stop gap, but also offers some better recommendations including purchasing and installing a proper cert (thanks to numerous community edits). Please see also the other highly voted answers in this thread, including the one by @Alex From Jitbit below about a breaking … Read more