I'm trying to setup a JDBC connection from Websphere V8.5.5 to Microsoft SQL server v2014. Currently I have to specify a db local login for this to work. I would like to know hot to get Websphere to login to SQL 2014 with LDAP credentials rather than local db users.

Can anyone provide a link listing the steps/requirements to achieve this. Global Security is has been configured to allow LDAP credentials for login etc on the console.

Any help is greatly appreciated.

Thank You,
Paul Russell

------------------------------
Paul Russell
------------------------------

I once had a similar issue and had to follow these steps- my notes might be a bit rough and ready but hopefully point you in the right direction:

• Do not enter any J2C authentication manually in WAS (and don't change any of the dropdowns on the datastore)
• Set WAS to run as the windows account who has SQL access 
• Copy Microsoft JDBC Driver 4.0 for SQL Server\sqljdbc_4.0\enu\auth\x64\sqljdbc_auth.dll to
  • was.install.root/java/lib  (C:\IBM\WebSphere\AppServer\java_1.7_64\lib)
  • was.install.root/java/jre/bin (C:\IBM\WebSphere\AppServer\java_1.7_64\jre\bin)
• In datastore/Custom properties change the value of integratedSecurity to true
• Restart Cell/Node
• Test connection

• Similar question here: 

https://www.ibm.com/mysupport/s/question/0D50z000062kHeg/how-to-authenticate-the-ms-sql-server-jdbc-driver-without-using-sql-server-authentication?

• more info here: 

https://www.ibm.com/support/pages/connect-sql-server-using-windows-authentication

------------------------------
Kevyn Williams
------------------------------

Original Message:
Sent: Mon June 01, 2020 01:27 PM
From: Paul Russell
Subject: LDAP Credentials for authentication with JDBC connection to SQL

I'm trying to setup a JDBC connection from Websphere V8.5.5 to Microsoft SQL server v2014. Currently I have to specify a db local login for this to work. I would like to know hot to get Websphere to login to SQL 2014 with LDAP credentials rather than local db users.

Can anyone provide a link listing the steps/requirements to achieve this. Global Security is has been configured to allow LDAP credentials for login etc on the console.

Any help is greatly appreciated.

Thank You,
Paul Russell

------------------------------
Paul Russell
------------------------------