webMethods

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

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

What happens when you experiment using "authenticationScheme=JavaKerberos" instead of "authenticationScheme=NativeAuthentication"?

Hi Uday,

Can you have a look at : 

https://empower.softwareag.com/sl24sec/SecuredServices/KCFullTextASP/viewing/view.asp?KEY=146730-7449741&DSN=PIVOTAL&DST=TCD&HL=1&QUERY=%5BADA.1.204%5D%7CCannot%7Cconnect%7Cthe%7Cdatabase%7Cwith%7CDataSource%7Cclass%7Ccom.microsoft.sqlserver.jdbc.SQLServerDataSource.%7CThis%7Cdriver%7Cnot%7Cconfigured%7Cfor%7Cintegrated%7Cauthentication.&SessionID=695551637

Getting the following error when trying to configure a JDBC connection with Windows authentication:

"[ART.118.5042] Adapter Runtime (Connection): Unable to enable connection resource ghConnections.adapters:dimentions.
[ART.118.5063] Adapter Runtime (Connection): Unable to start connection AAAA.adapters:xxxx: after 1 attempt(s).
[ADA.1.204] Cannot connect to the database with DataSource class "com.microsoft.sqlserver.jdbc.SQLServerDataSource".
This driver is not configured for integrated authentication. ClientConnectionId:952d271d-4c49-4897-9b6b-d40a521a8f29"

To resolve this issue get the appropriate sqljdbc_auth.dll file(as per JDK version) from the vendor.

The issue is thrown because of an incompatibility between the JVM and sqljdbc_auth.dll file.

Make sure you are not using JDBC Adapter on UNIX instead of Windows. 

It's not possible to use Windows Authentication from a JVM running on UNIX.

The sqljdbc_auth.dll file is specific to the Windows Platform and won't work with UNIX. 

You would need to use something like Kerberos Authentication for UNIX,.

You can find more information on how to set it up with Kerberos using link below:

http://documentation.softwareag.com/webmethods/wmsuites/wmsuite9-7/SysReqs_Installation_and_Upgrade/9-7_Using_Kerberos_with_webMethods_Products.pdf

https://empower.softwareag.com/sl24sec/SecuredServices/KCFullTextASP/viewing/view.asp?KEY=116015-10779493&DSN=PIVOTAL&DST=TCD&HL=1&QUERY=%5BADA.1.204%5D%7CCannot%7Cconnect%7Cthe%7Cdatabase%7Cwith%7CDataSource%7Cclass%7Ccom.microsoft.sqlserver.jdbc.SQLServerDataSource.%7CThis%7Cdriver%7Cnot%7Cconfigured%7Cfor%7Cintegrated%7Cauthentication.&SessionID=695551637

Regards,

Hi Uday,
this issue is persisting due to the connector (missing) and driver which you're not using for mssql, you're using extension dll not the driver which is needed please find connectors and other jar to create a connection between mssql and integration from mysql website, these are available there.
after placing all jars you'll be able to encounter this issue.



------------------------------
Zainul Abideen
webMethods Developer (Assistant Consultant)
Innovation Team
Hyderabad
------------------------------