Sidebar
public:edition:cloudbacko_pro:mssql_server_backup_shared_memory_ssl_security_error
Table of Contents
ISSUE: [Microsoft][ODBC SQL Server Driver][Shared Memory] SSL Security error (MS SQL backup)
Article ID:
8068
Reviewed:
20/03/2020
Product Version:
CloudBacko Pro: 4.1 or above
OS: Windows
Problem Description
When performing either a scheduled or manual MS SQL database backup job. The following backup error is received in the backup report:
| No. | Type | Timestamp | Log |
| * | ... | ... | ... |
| * | info | ... | Using Temporary Directory ... |
| * | erro | YYYY/MM/DD hh:mm:ss |
[Microsoft][ODBC SQL Server Driver][Shared Memory] SSL Security error
[Microsoft][ODBC SQL Server Driver][Shared Memory] ConnectionOpen (SECDoClientHandshake()). |
| * | ... | ... | ... |
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.
Keywords
MS SQL Server, TLS, Transport Layer Security
public/edition/cloudbacko_pro/mssql_server_backup_shared_memory_ssl_security_error.txt · Last modified: 2021/04/19 11:42 by ronnie.chan
