IBM Support

DataStage ODBC Connection to SQL Server failing due to missing SSL configuration

Troubleshooting


Problem

ODBC driver Connection from DataStage job to SQL Server fails with "SSL is required, but was not requested" error, this means that SQL Server is SSL configured but DataStage Engine is not SSL configured to connect to SQL Server. SQLConnect error: Status = -1 SQLState = 08001 Natcode = 0 [ODBC] [IBM(DataDirect OEM)][ODBC SQL Server Wire Protocol driver]SSL is required, but was not requested.

[{"Product":{"code":"SSZJPZ","label":"IBM InfoSphere Information Server"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"--","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"}],"Version":"9.1;8.7;8.5","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.

Document Information

More support for:
IBM InfoSphere Information Server

Software version:
9.1, 8.7, 8.5

Operating system(s):
AIX, HP-UX, Linux, Solaris

Document number:
513729

Modified date:
25 April 2025

UID

swg21676239

Manage My Notification Subscriptions