Using Encrypt=yes in a Sql Server connection string -> “provider: SSL Provider, error: 0 – The certificate’s CN name does not match the passed value.”

Your database connection can be configured to encrypt traffic and to accept any certificate from your server. Not a grand solution, but it worked for me.

The resulting connection string should look like this:

"[...];Encrypt=True;TrustServerCertificate=True"