User Tools

Site Tools


Sidebar

Announcement

Ahsay Backup Software

Backup Set Types

Supported Storage

Features in OBM / ACB

Features in CBS

Brand and Customize

License

Documentation

Performance Testing

FAQs and Known Issues

Can't Find What You Need?

public:8068_issue:mssql_server_backup_shared_memory_ssl_security_error

ISSUE: [Microsoft][ODBC SQL Server Driver][Shared Memory] SSL Security error (MS SQL backup)

Article ID: 8068
Reviewed: 20/03/2020

Product Version:
AhsayOBM: 8.1.0.0 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:

  1. 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.
  2. 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:

https://www.ahsay.com/download/download_document_v8_obm-user-guide-sql.jsp

Keywords

MS SQL Server, TLS, Transport Layer Security

public/8068_issue/mssql_server_backup_shared_memory_ssl_security_error.txt · Last modified: 2020/11/17 19:50 by edward.chan