IBM Support

"Connection failed ... SQL Server Error: 772 ... SQL Server Error: 18 ... SSL Security error" when trying to create ODBC connection (for FAP)

Troubleshooting


Problem

Administrator is trying to create an ODBC connection (called 'FAP') for the Controller functionality 'FAP' to work.
During the creation process, an error appears.

Symptom

image-20191218093550-1
Microsoft SQL Server Login
Connection failed:
SQLState: '0100'
SQL Server Error: 772
[Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen (SECDoClientHandshake()).
Connection failed:
SQLState: '08001'
SQL Server Error: 18
[Microsoft][ODBC SQL Server Driver][Shared Memory]SSL Security error

Cause

Both of the following are true:

(1) TLS 1.0 has been disabled on one (or both) of the following servers:
  • Planning Analytics (TM1) application server
  • Microsoft SQL server.
(2) Administrator is using the older 'SQL Server' ODBC driver (see below, circled in red)
image-20191218093811-2
This is incompatible with TLS 1.2.

Resolving The Problem

Fix:
Change the ODBC connection to use the newer "SQL Server Native Client 11.0" driver (highlighted in green below):
image-20191218094339-1
  
Workaround:
Re-enable TLS 1.0 on the Planning Analaytics (TM1) and/or SQL servers.
  • TIP: For more details, see separate IBM Technote #728129.

Document Location

Worldwide

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SS9S6B","label":"IBM Cognos Controller"},"Component":"","Platform":[{"code":"PF033","label":"Windows"}],"Version":"10.4.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
18 December 2019

UID

ibm11138114

Page Feedback