sql-servermssql-jdbcwebmethods

Connect to the database with DataSource class "com.microsoft.sqlserver.jdbc.SQLServerDataSource". Integrated authentication failed


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

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 ?


Solution

  • I made it to work with following properties;

    encrypt=false;trustServerCertificate=true;authenticationScheme=NTLM;integratedSecurity=true;useNTLMv2=true