This driver is not configured for integrated authentication

[sivaramtm]

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

[geoffc]

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.

[sivaramtm]

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

[geoffc]

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.