"The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption" when trying to connect to a database

Troubleshooting

Problem

Customer tries to connect to a Microsoft SQL database. An error appears. Problem may only affect some SQL database server targets.

Symptom

com.compositesw.cdms.webapi.WebapiException: Unable to connect to data
source "/shared/test" at "<servername>:51288@<xxxxxx>". Make sure
the URL information, user name and password are correct. [datasrc-3961025]
Cause: The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: "SQL Server did not return a response. The connection has been closed.

[{"Product":{"code":"SSEP7J","label":"Cognos Business Intelligence"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Virtual View Manager","Platform":[{"code":"PF033","label":"Windows"}],"Version":"10.1.1","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}},{"Product":{"code":"SS6G84","label":"IBM Cognos Analytics on Cloud"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Was this topic helpful?

Document Information

More support for:
Cognos Business Intelligence

Software version:
10.1.1

Operating system(s):
Windows

Document number:
531739

Modified date:
08 May 2025

UID

swg21961769

IBM Support

Tips