Integration with MSSQL breaks in Plesk Onyx 17.8 when PCI compliance settings in use: ODBCError 08001: [Microsoft][ODBC SQL Server Driver][DBMSLPCN]SSL Security error

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

Outdated MSSQL ODBC Driver is used.

Resolution

Note: Ability to create ODBC DSN for ODBC Driver 17 for SQL Server in Plesk is a feature request. Feel free to vote for it via the following link - https://plesk.uservoice.com/forums/184549-feature-suggestions/suggestions/34750087. Most demanded requests are likely to be implemented in future Plesk versions.

1. Connect to the server via RDP.

2. Copy %plesk_dir%admin\bin\odbc.conf.xml file to %plesk_dir%admin\bin\odbc.conf.xml.backup.

3. Change %plesk_dir%admin\bin\odbc.conf.xml file to the attached one or modify %plesk_dir%admin\bin\odbc.conf.xml duplicating <cstring driver="SQL Server Native Client 11.0" driverType="mssql"> section and modifying 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.

4. Select ODBC Driver 17 for SQL Server: