This driver is not configured for integrated authentication

Hi,

We need to connect to MSSQL database using windows authentication from JDBC driver. when i tried the same i am getting below error. Can some one please help to resolve the error.
<status level="warning" type="app-connection">
<description>Unable to connect. There is a connectivity-related problem.</description>
<jdbc:exception jdbc:class="com.microsoft.sqlserver.jdbc.SQLServerException" jdbc:error-code="0" jdbc:sql-state="08S01">
<jdbc:message>This driver is not configured for integrated authentication. ClientConnectionId:634c759d-e8a7-41e3-8a04-de4fa6e67ede</jdbc:message>
</jdbc:exception>

<authentication-info>
<server>jdbc:sqlserver://Pobxxx.aaa.aa:1433;databaseName=ServiceNow_xx;integratedSecurity=true;</server>
<user>abcd</user>

I have placed the sqljdbc_auth.dll and sqljdbc42.jar files under nds lib and restarted eDirectory but still same error occurs.

Thanks
Siva ram T
  • On 2/21/2019 1:24 PM, sivaramtm wrote:
    >
    > Hi,
    >
    > We need to connect to MSSQL database using windows authentication from
    > JDBC driver. when i tried the same i am getting below error. Can some
    > one please help to resolve the error.
    > <status level="warning" type="app-connection">
    > <description>Unable to connect. There is a connectivity-related
    > problem.</description>
    > <jdbc:exception
    > jdbc:class="com.microsoft.sqlserver.jdbc.SQLServerException"
    > jdbc:error-code="0" jdbc:sql-state="08S01">
    > <jdbc:message>This driver is not configured for integrated
    > authentication.
    > ClientConnectionId:634c759d-e8a7-41e3-8a04-de4fa6e67ede</jdbc:message>
    > </jdbc:exception>
    >
    > <authentication-info>
    >
    > <server>jdbc:sqlserver://Pobxxx.aaa.aa:1433;databaseName=ServiceNow_xx;integratedSecurity=true;</server>
    > <user>abcd</user>
    >
    > I have placed the sqljdbc_auth.dll and sqljdbc42.jar files under nds lib
    > and restarted eDirectory but still same error occurs.


    You can consider using the JTDS driver instead of the MS SQL JDBC
    driver. MS is a bit odd about this JDBC driver in terms of features.
    JTDS seems better some f the time.

    In that case it is domain=DomainName, and useNTLMv2=true (I think on the
    last one, check for yourself) on the connect string.


  • Hi,

    Thank you so much it worked. Here is the configuraiton jdbc:jtds:sqlserver://Pobxxxxxx.pob.sys:1433/ServiceNow_1234;domain=xxx

    Thanks
    Sivaram T
  • On 2/23/2019 6:14 AM, sivaramtm wrote:
    >
    > Hi,
    >
    > Thank you so much it worked. Here is the configuraiton
    > jdbc:jtds:sqlserver://Pobxxxxxx.pob.sys:1433/ServiceNow_1234;domain=xxx


    Glad that worked, I was just working through this in Validator and
    remembered the answer.