IBM webMethods Hybrid Integration

IBM webMethods Hybrid Integration

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.

 View Only
Expand all | Collapse all

Authentification Windws SQL Server

  • 1.  Authentification Windws SQL Server

    Posted Thu March 19, 2020 09:33 AM

    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 ?


    #Integration-Server-and-ESB
    #webMethods
    #Adapters-and-E-Standards


  • 2.  RE: Authentification Windws SQL Server

    Posted Wed November 04, 2020 12:07 AM

    Hi Vital,

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

    integratedSecurity=true; authenticationScheme=NativeAuthentication


    #Adapters-and-E-Standards
    #Integration-Server-and-ESB
    #webMethods