SQL backups cannot connect to server since hardening server to accept TLS 1.2 (4044770)

立即与支持人员聊天

获得即时帮助
完成注册

登录

请求定价

联系销售人员

反馈已提交

本文是否解决了您的问题？

选择评级

标题

SQL backups cannot connect to server since hardening server to accept TLS 1.2
说明

After locking down SQL Servers to only accept SSL connections on TLS 1.2, the Plug-in for SQL Server backup fail.
NetVault trace shows:
3 MSQLODBC ??? 13308 1006 0 150838009873 Enter ODBCDriverConnect
2 MSQLODBC ??? 13308 1072 0 150853542679 Set Error code '08001' and Error message to : Failed to connect. Please start instance
2 MSQLODBC ??? 13308 718 0 150853549308 ODBC Error Number:01000, MsgState=0, Severity=0, Servername=, ProcName=, LineNumber=0, Message:[Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen (SECCreateCredentials()).
2 MSQLODBC ??? 13308 1073 0 150853549327 Not setting error, Error code '01000' Last Error set is 'Failed to connect. Please start instance '
2 MSQLODBC ??? 13308 772 0 150853556069 Failed to login to SQL Instance 'SQLSRV1'
原因

The NetVault Plug-in for SQL Server interacts with ODBC Data source (Native SQL Server Client).
It is not NetVault as such which supports or doesn't support TLS 1.2 but the Native SQL Server CLient we encounter on the SQL Server.
Ensure both SQL Server and SQL Server Native Client versions support TLS 1.2.
解决办法

Check the version of the SQL Server ODBC Driver on the SQL Server client under:
Administrative Tools --> Data Sources (ODBC) --> Drivers tab
Based on that version, the following Microsoft Web page lists the SQL Server versions that support TLS 1.2, including the Microsoft ODBC Driver for SQL Server:
https://support.microsoft.com/en-us/help/3135244/tls-1-2-support-for-microsoft-sql-server
Ensure the version of the Microsoft ODBC Driver for SQL Server support TLS 1.2 based on that Microsoft Web page.
If the SQL Server Client is running both a SQL Server version and a SQL server ODBC Driver version that support TLS 1.2, then the plug-in shall be able access SQL Server.
Key Features: Support for specifying an ODBC Driver in the SQL Server ODBC Driver field for Windows (DNPSS-1070) is added and Available for customers from Plug-in for SQL Server 12.2 patch 1

反馈已提交

本文是否解决了您的问题？

选择评级

Request a KB Article

建议的内容

产品：: NetVault
12.0.1, 12.0, 11.4.5, 11.4, 11.3, 11.2, 11.1, 11.0

主题：: Troubleshooting

文章历史记录：: 创建时间： 5/28/2018
上次更新时间： 5/7/2023

搜索所有文章

请选择您的产品：

为向您提供更好的服务，请填写'Purpose of your Chat'（联系目的）：

针对您的问题建议的解决方案

SQL backups cannot connect to server since hardening server to accept TLS 1.2 (4044770)

标题

说明

原因

解决办法

Leave a Comment