Applicable to:
- Plesk Onyx 17.8 for Windows
Symptoms
-
TLS 1.0 protocol is disabled as described in How to disable TLS 1.0 protocol in Windows for Plesk Onyx server?
-
Plesk Onyx 17.8 is in use.
-
When clicking Test Connection for any SQL ODBC in Plesk, the following error is displayed:
CONFIG_TEXT: Error: Unable to connect to the data source using the defined settings. Server has returned the following error:
ODBCError 08001: [Microsoft][ODBC SQL Server Driver][DBMSLPCN]SSL Security error
ODBCError 01000: [Microsoft][ODBC SQL Server Driver][DBMSLPCN]ConnectionOpen (SECCreateCredentials())
Cause
An outdated MSSQL ODBC Driver is used.
Resolution
Note: The ability to create ODBC DSN for ODBC Driver 17 for SQL Server in Plesk is a feature request.
Consider voting on the corresponding feature request at Plesk UserVoice. The top-ranked suggestions are likely to be implemented in future product updates.
As a workaround:
-
Connect to the server via RDP;
-
Copy
%plesk_dir%admin\bin\odbc.conf.xml
file to%plesk_dir%admin\bin\odbc.conf.xml.backup
. -
Change
%plesk_dir%admin\bin\odbc.conf.xml
file to the attached one (click here to download it) or modify%plesk_dir%admin\bin\odbc.conf.xml
duplicating<cstring driver="SQL Server Native Client 11.0" driverType="mssql">
section and modify the duplicated section to define ODBC Driver 17 for SQL Server:CONFIG_TEXT: <cstring driver="ODBC Driver 17 for SQL Server" driverType="mssql">
<param>
<key>DRIVER</key>
<key_human></key_human>
<required>true</required>
<curly>true</curly>
<type>string</type>
<value>ODBC Driver 17 for SQL Server</value>
</param>Warning: do not remove SQL Server Native Client 11.0 section since it is used by Plesk.
-
Go to Tools & Settings > ODBC Data Sources > click Add ODBC DSN:
-
Select ODBC Driver 17 for SQL Server:
Comments
0 comments
Please sign in to leave a comment.