WebSphere Application Server & Liberty

 View Only
Expand all | Collapse all

LDAP Credentials for authentication with JDBC connection to SQL

  • 1.  LDAP Credentials for authentication with JDBC connection to SQL

    Posted Tue June 02, 2020 11:15 AM
    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
    ------------------------------


  • 2.  RE: LDAP Credentials for authentication with JDBC connection to SQL

    Posted Wed June 03, 2020 03:47 AM
    Edited by Kevyn Williams Wed June 03, 2020 03:47 AM
    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
    ------------------------------