sivaramtm Honored Contributor.
Honored Contributor.
1858 views

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
Labels (1)
0 Likes
3 Replies
Knowledge Partner
Knowledge Partner

Re: This driver is not configured for integrated authentication

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.


0 Likes
sivaramtm Honored Contributor.
Honored Contributor.

Re: This driver is not configured for integrated authenticat

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
0 Likes
Knowledge Partner
Knowledge Partner

Re: This driver is not configured for integrated authentication

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.

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.