Manager does not connect to server with "certificate chain was issued by an authority that is not trusted" message

Problem

In version 5.3, Manager reports an error when connecting to site and application cannot connect.

Solution

Starting in version 5.3 a new connection mechanism is introduced in order to support several deploy scenarios and security aspects, including AzureSQL, increasing requirements on certificates.

When running in a protected environment, it is possible to define to trust server certificates by using the tag TrustServerCertificate.

<SqlServerDatabaseDefaults>
    <Enabled>true</Enabled>
    <Authentication>NotSpecified</Authentication>
    <CommandTimeout>600</CommandTimeout>
    <ConnectTimeout>30</ConnectTimeout>
    <IntegratedSecurity>true</IntegratedSecurity>
    <MultipleActiveResultSets>true</MultipleActiveResultSets>
    <!-- define to trust server certificate -->
    <TrustServerCertificate>true</TrustServerCertificate>
</SqlServerDatabaseDefaults>