webMethods

 View Only

 JDBC Connection issue

Uday kiran Kondi's profile image
Uday kiran Kondi posted Mon March 10, 2025 09:14 AM

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.

Java version

17.0.13 (61.0)

Java VM name

OpenJDK 64-Bit Server VM


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

image

Please find the below connection properties.

Can somebody please help us with the above issue.

 

Thanks & Regards,

Uday Kiran Kondi

Sourabh Harkawat's profile image
Sourabh Harkawat posted Tue March 11, 2025 02:34 AM

Hi Uday,
Have you tried providing port number while creating connection?

Holger von Thomsen's profile image
Holger von Thomsen posted Tue March 11, 2025 12:09 PM

Hi Uday,

the dll belongs under lib/jars/custom as shown your screenshot.
the jar file belongs under packages/WmJDCAdapter/code/jars/static in this case and not under packages/WmJDCAdapter/code/jars/ as usual.
Due to the native part (the auth dll) it is required to shutdown and restart the IS, otherwise the dll will not be loaded and recognized correctly.

Regards,
Holger