Microsoft SQL Server database backup task ends with a "DV0270:User-defined script failed" error.
Some newer versions of Microsoft SQL Server use the ODBC driver 18, which enforces encryption by default and may therefore cause the error described above.
ODBC driver 18 encrypted connections requirement can be met by using a self-signed certificate.
The step-by-step instructions below describe how to generate, configure, and install the certificate in Microsoft SQL Server.