Sidebar
public:8068_issue:mssql_server_backup_shared_memory_ssl_security_error
Table of Contents
[V8] ISSUE: [Microsoft][ODBC SQL Server Driver][Shared Memory] SSL Security error (MS SQL backup)
Article ID:
8068
Reviewed:
2020-03-20
Product Version:
AhsayOBM: 8.1.0.0 to 8.x
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.
http://download.ahsay.com/support/document/v8/guide_obm_user_mssql_v8.pdf
Keywords
MS SQL Server, TLS, Transport Layer Security
public/8068_issue/mssql_server_backup_shared_memory_ssl_security_error.txt · Last modified: 2021/12/13 10:36 by anna.olalia