Authentification Windws SQL Server

Hi,
I know the subject is known and I have already set windows authentification for SQL Server in wM 9.10.
But actually we migrate on 10.5 and during the installation we encountered some problems about this topic.
I explain : I download the latest version of sql jdbc driver from Microsoft.
And in the folder there is 2 files I think I have to paste in <SAG_Install> directory :

  • I put the sqljdbc_auth file in <SAG_Install>\common\security\ssx_64\bin directory
  • I put the sqljdbc42.jars (actually in wM 9.10 I used the sqljdbc4.jars) in the following directories
    – IntegrationServer\lib\jars\custom
    – IntegrationServer\Instances\default\lib\jars\custom
    – IntegrationServer\instances\default\packages\WmJDBCAdapter\code\jars

But I have the following error :
[SoftwareAG][SQLServer JDBC Driver]Kerberos Authentication is not supported by this SQLServer. The driver attempted Kerberos authentication because the AuthenticationMethod connect option was “auto” and no username/password was specified

What did I miss ?

Hi Vital,

You need to set the below properties in connection other properties.

integratedSecurity=true; authenticationScheme=NativeAuthentication