Please use the following steps on [Microsoft][ODBC SQL Server Driver][Shared Memory] SSL Security error (MS SQL backup).
Symptom:
When performing either a scheduled or manual MS SQL database backup job. The following backup error is received in the backup report:
[Microsoft][ODBC SQL Server Driver][Shared Memory] SSL Security error
[Microsoft][ODBC SQL Server Driver][Shared Memory] ConnectionOpen (SECDoClient Handshake())
Cause:
The Transport Layer Security (TLS) version has not been enabled on the MS SQL Server.
Resolution:
To resolve this issue, either:
- For MS SQL Server 2005, 2008, 2012, and 2014 database, backup in either ODBC and VSS backup mode, enable TLS version 1.0 on the SQL Server.
- For MS SQL Server 2016, 2017, and 2019 database, backup in either ODBC and VSS backup mode, enable TLS version 1.2 on the SQL Server.
Refer to the Requirements section in the Microsoft SQL Server Database Backup & Restore Guide for more details:
Microsoft SQL Backup and Restore Guide