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