webMethods

Hi Everyone,

We have encountered a below error for a JDBC connection in our server.

Error:

[ADA.1.204] Cannot connect to the database with DataSource class "com.microsoft.sqlserver.jdbc.SQLServerDataSource".

This driver is not configured for integrated authentication.

Please find below JDK version of the 10.15 IS server.

Please also find the below screenshot of jar file which is updated in the server VM.

Please find the below connection properties.

Can somebody please help us with the above issue.

Thanks & Regards,

Uday Kiran Kondi

Hi Uday,

please check if you can switch to a newer version of the driver as version 9 is 4 years old now.
Might be that the version 9 driver was not supporting integrated authentication via JDBC connection.
Driver version should be equal to or greater than 12.6.

Regards,
Holger

Hi Everyone,

We have encountered a below error for a JDBC connection in our server.

Error:

[ADA.1.204] Cannot connect to the database with DataSource class "com.microsoft.sqlserver.jdbc.SQLServerDataSource".

This driver is not configured for integrated authentication.

Please find below JDK version of the 10.15 IS server.

Please also find the below screenshot of jar file which is updated in the server VM.

Please find the below connection properties.

Can somebody please help us with the above issue.

Thanks & Regards,

Uday Kiran Kondi

Hi Holger,

We have tried with the new version 12.8 file. But still facing the same error as earlier.

Error:

[ADA.1.204] Cannot connect to the database with DataSource class "com.microsoft.sqlserver.jdbc.SQLServerDataSource".

This driver is not configured for integrated authentication.

Thanks & Regards,

Uday Kiran Kondi

Hi Uday,

please check if you can switch to a newer version of the driver as version 9 is 4 years old now.
Might be that the version 9 driver was not supporting integrated authentication via JDBC connection.
Driver version should be equal to or greater than 12.6.

Regards,
Holger

Hi Everyone,

We have encountered a below error for a JDBC connection in our server.

Error:

[ADA.1.204] Cannot connect to the database with DataSource class "com.microsoft.sqlserver.jdbc.SQLServerDataSource".

This driver is not configured for integrated authentication.

Please find below JDK version of the 10.15 IS server.

Please also find the below screenshot of jar file which is updated in the server VM.

Please find the below connection properties.

Can somebody please help us with the above issue.

Thanks & Regards,

Uday Kiran Kondi

Hi Uday,

when exchanging the native auth dll for the driver, this requires a complete shutdown and restart of the IS instance.
Additionally, the matching jar files should be placed under packages/WmJDBCAdapter/code/jars/static instead of packages/WmJDBCAdapter/code/jars/ in this case.

You might find this link helpful: Building the connection URL to MS SQL with integrated auth.

Regards,
Holger

Hi Holger,

We have tried with the new version 12.8 file. But still facing the same error as earlier.

Error:

[ADA.1.204] Cannot connect to the database with DataSource class "com.microsoft.sqlserver.jdbc.SQLServerDataSource".

This driver is not configured for integrated authentication.

Thanks & Regards,

Uday Kiran Kondi

Hi Uday,

please check if you can switch to a newer version of the driver as version 9 is 4 years old now.
Might be that the version 9 driver was not supporting integrated authentication via JDBC connection.
Driver version should be equal to or greater than 12.6.

Regards,
Holger

Hi Everyone,

We have encountered a below error for a JDBC connection in our server.

Error:

[ADA.1.204] Cannot connect to the database with DataSource class "com.microsoft.sqlserver.jdbc.SQLServerDataSource".

This driver is not configured for integrated authentication.

Please find below JDK version of the 10.15 IS server.

Please also find the below screenshot of jar file which is updated in the server VM.

Please find the below connection properties.

Can somebody please help us with the above issue.

Thanks & Regards,

Uday Kiran Kondi

Hi Holger,

We have tried placing the dll file under the path packages/WmJDBCAdapter/code/jars/static.

A complete shutdown and restart of the IS instance was also followed.

But the issue is not yet resolved.

Thanks & Regards,

Uday Kiran Kondi

Hi Uday,

when exchanging the native auth dll for the driver, this requires a complete shutdown and restart of the IS instance.
Additionally, the matching jar files should be placed under packages/WmJDBCAdapter/code/jars/static instead of packages/WmJDBCAdapter/code/jars/ in this case.

You might find this link helpful: Building the connection URL to MS SQL with integrated auth.

Regards,
Holger

Hi Holger,

We have tried with the new version 12.8 file. But still facing the same error as earlier.

Error:

[ADA.1.204] Cannot connect to the database with DataSource class "com.microsoft.sqlserver.jdbc.SQLServerDataSource".

This driver is not configured for integrated authentication.

Thanks & Regards,

Uday Kiran Kondi

Hi Uday,

please check if you can switch to a newer version of the driver as version 9 is 4 years old now.
Might be that the version 9 driver was not supporting integrated authentication via JDBC connection.
Driver version should be equal to or greater than 12.6.

Regards,
Holger

Hi Everyone,

We have encountered a below error for a JDBC connection in our server.

Error:

[ADA.1.204] Cannot connect to the database with DataSource class "com.microsoft.sqlserver.jdbc.SQLServerDataSource".

This driver is not configured for integrated authentication.

Please find below JDK version of the 10.15 IS server.

Please also find the below screenshot of jar file which is updated in the server VM.

Please find the below connection properties.

Can somebody please help us with the above issue.

Thanks & Regards,

Uday Kiran Kondi

Hi Uday,

the dll belongs under lib/jars/custom and the jar belongs under packages/WmJDBCAdapter/code/jars/static.
Usually, the jar would belong under packages/WmJDBCAdapter/code/jars, but due to neccessity of the dll it needs to be under the static subdirectory.

Regards,
Holger

Hi Holger,

We have tried placing the dll file under the path packages/WmJDBCAdapter/code/jars/static.

A complete shutdown and restart of the IS instance was also followed.

But the issue is not yet resolved.

Thanks & Regards,

Uday Kiran Kondi

Hi Uday,

when exchanging the native auth dll for the driver, this requires a complete shutdown and restart of the IS instance.
Additionally, the matching jar files should be placed under packages/WmJDBCAdapter/code/jars/static instead of packages/WmJDBCAdapter/code/jars/ in this case.

You might find this link helpful: Building the connection URL to MS SQL with integrated auth.

Regards,
Holger

Hi Holger,

We have tried with the new version 12.8 file. But still facing the same error as earlier.

Error:

[ADA.1.204] Cannot connect to the database with DataSource class "com.microsoft.sqlserver.jdbc.SQLServerDataSource".

This driver is not configured for integrated authentication.

Thanks & Regards,

Uday Kiran Kondi

Hi Uday,

please check if you can switch to a newer version of the driver as version 9 is 4 years old now.
Might be that the version 9 driver was not supporting integrated authentication via JDBC connection.
Driver version should be equal to or greater than 12.6.

Regards,
Holger

Hi Everyone,

We have encountered a below error for a JDBC connection in our server.

Error:

[ADA.1.204] Cannot connect to the database with DataSource class "com.microsoft.sqlserver.jdbc.SQLServerDataSource".

This driver is not configured for integrated authentication.

Please find below JDK version of the 10.15 IS server.

Please also find the below screenshot of jar file which is updated in the server VM.

Please find the below connection properties.

Can somebody please help us with the above issue.

Thanks & Regards,

Uday Kiran Kondi