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

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
====== ISSUE: [Microsoft][ODBC SQL Server Driver][Shared Memory] SSL Security error (MS SQL backup)  ======

<html>
 <b>
  Article ID:
 </b>
 8068
 <br/>
 <b>
  Reviewed:
 </b>
 20/03/2020
 <br/>
 <br/>
 <b>
  Product Version:
 </b>
 <br/>
 CloudBacko Pro: 4.1 or above
 <br/>
 OS: Windows
</html>


===== Problem Description =====
<html>
When performing either a scheduled or manual MS SQL database backup job. The following backup error is received in the backup report:
 <br/>
 <table border="0" cellpadding="0" cellspacing="0" width="850">
  <tr>
   <td bgcolor="#E8E8E8" style="BORDER-LEFT: #C0C0C0 1px solid; BORDER-TOP: #C0C0C0  1px solid; BORDER-BOTTOM: #C0C0C0 1px solid" valign="middle">
    No.
   </td>
   <td bgcolor="#E8E8E8" style="BORDER-LEFT: #C0C0C0 1px solid; BORDER-TOP: #C0C0C0  1px solid; BORDER-BOTTOM: #C0C0C0 1px solid" valign="middle">
    Type
   </td>
   <td bgcolor="#E8E8E8" style="BORDER-LEFT: #C0C0C0 1px solid; BORDER-TOP: #C0C0C0  1px solid; BORDER-BOTTOM: #C0C0C0 1px solid" valign="middle">
    Timestamp
   </td>
   <td bgcolor="#E8E8E8" style="BORDER-LEFT: #C0C0C0 1px solid; BORDER-TOP: #C0C0C0 1px solid; BORDER-RIGHT: #C0C0C0 1px solid; BORDER-BOTTOM: #C0C0C0 1px solid" valign="middle">
    Log
   </td>
  </tr>
  <tr>
   <td bgcolor="#ffffff" style="BORDER-LEFT: #C0C0C0 1px solid; BORDER-BOTTOM: #C0C0C0 1px solid" valign="top">
    *
   </td>
   <td bgcolor="#ffffff" style="BORDER-LEFT: #C0C0C0 1px solid; BORDER-BOTTOM: #C0C0C0 1px solid" valign="top">
    ...
   </td>
   <td bgcolor="#ffffff" style="BORDER-LEFT: #C0C0C0 1px solid; BORDER-BOTTOM: #C0C0C0 1px solid" valign="top">
    ...
   </td>
   <td bgcolor="#ffffff" style="BORDER-LEFT: #C0C0C0 1px solid; BORDER-RIGHT: #C0C0C0 1px solid; BORDER-BOTTOM: #C0C0C0 1px solid" valign="middle">
    ...
   </td>
  </tr>
  <tr>
   <td bgcolor="#ffffff" style="BORDER-LEFT: #C0C0C0 1px solid; BORDER-BOTTOM: #C0C0C0 1px solid" valign="top">
    *
   </td>
   <td bgcolor="#ffffff" style="BORDER-LEFT: #C0C0C0 1px solid; BORDER-BOTTOM: #C0C0C0 1px solid" valign="top">
    info
   </td>
   <td bgcolor="#ffffff" style="BORDER-LEFT: #C0C0C0 1px solid; BORDER-BOTTOM: #C0C0C0 1px solid" valign="top">
    ...
   </td>
   <td bgcolor="#ffffff" style="BORDER-LEFT: #C0C0C0 1px solid; BORDER-RIGHT: #C0C0C0 1px solid; BORDER-BOTTOM: #C0C0C0 1px solid" valign="middle">
    Using Temporary Directory ...
   </td>
  </tr>
  <tr>
   <td bgcolor="#ffffff" style="BORDER-LEFT: #C0C0C0 1px solid; BORDER-BOTTOM: #C0C0C0 1px solid" valign="top">
    *
   </td>
   <td bgcolor="#ffffff" style="BORDER-LEFT: #C0C0C0 1px solid; BORDER-BOTTOM: #C0C0C0 1px solid" valign="top">
    <font color=#FF0000>
     erro
    </font>
   </td>
   <td bgcolor="#ffffff" style="BORDER-LEFT: #C0C0C0 1px solid; BORDER-BOTTOM: #C0C0C0 1px solid" valign="top">
    <font color=#FF0000>
     YYYY/MM/DD
     hh:mm:ss
     </font>
   </td>
   <td bgcolor="#ffffff" style="BORDER-LEFT: #C0C0C0 1px solid; BORDER-RIGHT: #C0C0C0 1px solid; BORDER-BOTTOM: #C0C0C0 1px solid" valign="middle">
    <font color=#FF0000>
     [Microsoft][ODBC SQL Server Driver][Shared Memory] SSL Security error
<br>
[Microsoft][ODBC SQL Server Driver][Shared Memory] ConnectionOpen (SECDoClientHandshake()).
     <br/>
    </font>
   </td>
  </tr>
  <tr>
   <td bgcolor="#ffffff" style="BORDER-LEFT: #C0C0C0 1px solid; BORDER-BOTTOM: #C0C0C0 1px solid" valign="top">
    *
   </td>
   <td bgcolor="#ffffff" style="BORDER-LEFT: #C0C0C0 1px solid; BORDER-BOTTOM: #C0C0C0 1px solid" valign="top">
    ...
   </td>
   <td bgcolor="#ffffff" style="BORDER-LEFT: #C0C0C0 1px solid; BORDER-BOTTOM: #C0C0C0 1px solid" valign="top">
    ...
   </td>
   <td bgcolor="#ffffff" style="BORDER-LEFT: #C0C0C0 1px solid; BORDER-RIGHT: #C0C0C0 1px solid; BORDER-BOTTOM: #C0C0C0 1px solid" valign="middle">
    ...
   </td>
  </tr>
 </table>
</html>


===== Cause =====
<html>
The Transport Layer Security (TLS) version has not been enabled on the MS SQL Server.
</html>


===== Resolution =====
<html>
To resolve this issue, either:
<ol>
 <li><font color=black> 
  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.</font>
 </li>

 <li><font color=black> 
 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.</font>
 </li>
</ol></html>
 Refer to this [[public:module:microsoft_sql_database:requirements]] section in the Microsoft SQL Server Database Backup & Restore Guide for more details.


===== Keywords =====
MS SQL Server, TLS, Transport Layer Security
User Tools

Site Tools

Page Tools
