I'm trying to connect from webmethodsV10.7 (runs in Linux) to a remote hosted SQL Server via Windows authentication (that is user setup is done in Windows authentication using Active Directory for the SQL Server database). The SQL driver I use supports the database version. I have copied the driver and *.dll files in
wm107/IntegrationServer/instances/DEV/packages/WmJDBCAdapter/code/jars
wm107/IntegrationServer/instances/DEV/packages/WmJDBCAdapter/code/jars/static
wm107/IntegrationServer/instances/DEV/lib/jars
I have set the following properties:
encrypt=false;trustServerCertificate=true;integratedSecurity=true;authenticationScheme=javaKerberos;authentication=NotSpecified;
but still I get the following error:
Adapter Runtime (Connection): Unable to create new connection supervisionOrders:somssqlDBConn. [ADA.1.204] Cannot connect to the database with DataSource class "com.microsoft.sqlserver.jdbc.SQLServerDataSource". Integrated authentication failed.
ClientConnectionId:ba9f0b27-f875-439d-84e6-77787d6e5a4e
Does anyone know what is wrong here?
UPDATE
If I add following properties:
encrypt=false;trustServerCertificate=true;integratedSecurity=true;authentication=NotSpecified;
I then get the following error:
This driver is not configured for integrated authentication.Caused by: java.lang.UnsatisfiedLinkError: Unable to load authentication DLL mssql-jdbc_auth-12.8.1.x64
I use sqljdbc_12.8.1.0 driver for SQL Server 2016 which is supported
Can we use that *.dll file in linux OS ?
I made it to work with following properties;
encrypt=false;trustServerCertificate=true;authenticationScheme=NTLM;integratedSecurity=true;useNTLMv2=true