Microsoft SQL Server database backup ends with "DV0270:User-defined script failed" error

⚠️ Issue

Microsoft SQL Server database backup task ends with a "DV0270:User-defined script failed" error.

---

💡 Cause

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.

---

✅ Resolution

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.

1MB

Generating a self-signed certificate for Microsoft SQL Server.pdf

PDF

Open