sivaramtm

Vice Admiral
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
2019-02-21
18:22
4556 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
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
3 Replies


Knowledge Partner
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
2019-02-22
16:20
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,
>
> 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

Vice Admiral
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
2019-02-23
11:07
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
Thank you so much it worked. Here is the configuraiton jdbc:jtds:sqlserver://Pobxxxxxx.pob.sys:1433/ServiceNow_1234;domain=xxx
Thanks
Sivaram T


Knowledge Partner
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
2019-02-24
01:21
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.
>
> 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.