IBM Support

Make Global Connections from Cloud Pak for Data to MS SQL Server with Windows Auth enabled.

How To


Summary

This document talks about setting up connections from Cloud Pak for data v2.5 connection to MS SQL Server which is configured for Integrated security (Windows authentication)

Environment

The native JDBC driver for MS SQL does support windows auth based connections but needs specific DLLs in the JDBC classpath for windows based installations. For linux based systems (CPD is linux based containers), kerberose options are provided  (by setting authenticationScheme=JavaKerberos) but they need additional setups and would require kinits and keytab file management. With container environment, where containers can get scheduled in one of the many nodes, this requirement adds to the complexity.
The solution to workaround this is to use jTDS JDBC  (http://jtds.sourceforge.net/) driver which is 100% pure Java (type 4) JDBC 3.0 driver for Microsoft SQL Server (6.5, 7, 2000, 2005, 2008 and 2012) and Sybase Adaptive Server Enterprise (10, 11, 12 and 15). Please be aware that since this is an open source software, please ensure you are in compliance with your corporate security policies.

Steps

1. Obtain the JDBC driver from the above mentioned site and upload it in Cloud Pak for Data via Upload Driver button in create connection page
2.  Fill the below details  -
   
   Driver class name  - net.sourceforge.jtds.jdbc.Driver   JDBC URL prefix     - jdbc:jtds:sqlserver
image 4003
3. Click Upload
4.  Create a connection using the type you created above and enter the URL in the below format
  jdbc:jtds:sqlserver://host:port/databaseName;domain=domainName;useNTLMv2=true;
5.  Test Connection
image 4004

Document Location

Worldwide

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSHGYS","label":"IBM Cloud Pak for Data"},"ARM Category":[{"code":"a8m50000000ClViAAK","label":"Organize->Data Connections"}],"ARM Case Number":"TS003703506","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Version(s)","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
07 August 2020

UID

ibm16220280