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.

Cause

SQL Server is SSL configured but DataStage Engine is not SSL configured to connect to SQL Server via ODBC driver from DataStage job.

Resolving The Problem

To resolve "SSL is required, but was not requested" issue, follow below steps on how to setup SSL for ODBC drivers on DataStage Engine, please engage your SQL Server DBA and system admin to setup SSL for SQL Server ODBC driver.

1) SSL can be set up using CA signed certificates or self-signed certificates. CA signed certificates are recommended in production environments.

2) Copy the certificate to a location that can be accessed by the driver. It is not required to install the certificate on client machine.

3) Create a TrustStore

4) Configure the following connection options in the .odbc.ini file under $DSHOME path for the data source.

- Configure "EncryptionMethod=" to the desired value ("1" for SSL, "6" for Request SSL, or "7" for Login SSL).
- Configure "TrustStore=" entry in the ODBC data source to point to that certificate file (full path, including the file name, with extension).
- Configure "TrustStorePassword=" entry in the ODBC data source (with the password set on the certificate, if there is one)

[{"Product":{"code":"SSZJPZ","label":"IBM InfoSphere Information Server"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"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":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
16 June 2018

UID

swg21676239