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.



#Automation


#Applicationintegration
#webMethods
#Integration
 View Only
  • 1.  Issue creating database components from Linux

    Posted 04/24/21 08:33 AM

    Hi All,

    I am facing an issue while installing DB components from Linux command line for SQL server.
    Using the below command:
    ./dbConfigurator.sh -a create -d sqlserver –pr MwS -v latest -l jdbc:wm:sqlserver://:1433;databaseName=;integratedSecurity=true; authenticationScheme=NativeAuthentication -u -p

    Below is the error message:
    Database Connection 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.

    I have installed only the Database Component Configurator at this stage, and plan to install products once create the DB components.

    Thanks


    #Integration-Server-and-ESB
    #Application-Platform
    #webMethods


  • 2.  RE: Issue creating database components from Linux

    Posted 04/24/21 11:51 AM

    Is your SQL Server on Linux or Windows? I see that Native Authentication works only with Windows.

    I haven’t encountered this issue, so these are trial and error options -

    1. In some references, I see “nativeAuthentication” even though Microsoft has “NativeAuthentication” - worth a try.
    2. Append the username and password to the connection string, instead of CLI params. userName=user;password=yourPass
    3. Depending on what OS your database is on, refer this link

    Hope this helps.


    #Application-Platform
    #webMethods
    #Integration-Server-and-ESB


  • 3.  RE: Issue creating database components from Linux

    Posted 04/24/21 10:35 PM

    (post withdrawn by author, will be automatically deleted in 24 hours unless flagged)


    #Integration-Server-and-ESB
    #Application-Platform
    #webMethods


  • 4.  RE: Issue creating database components from Linux

    Posted 04/25/21 03:22 AM

    (post withdrawn by author, will be automatically deleted in 24 hours unless flagged)


    #Application-Platform
    #webMethods
    #Integration-Server-and-ESB


  • 5.  RE: Issue creating database components from Linux

    Posted 04/25/21 03:24 AM

    Could find a way out by tweaking the connection properties.

    Thanks


    #Application-Platform
    #Integration-Server-and-ESB
    #webMethods


  • 6.  RE: Issue creating database components from Linux

    Posted 04/25/21 11:10 AM

    Can you share the resolution for the benefit of the community?


    #webMethods
    #Integration-Server-and-ESB
    #Application-Platform


  • 7.  RE: Issue creating database components from Linux

    Posted 04/26/21 09:41 AM

    Used the below URL:

    “jdbc:wm:sqlserver://:1433;databaseName=;integratedSecurity=true;authenticationScheme=NativeAuthentication;user=;password=”

    Thanks


    #Integration-Server-and-ESB
    #webMethods
    #Application-Platform


  • 8.  RE: Issue creating database components from Linux

    Posted 04/26/21 12:43 PM

    Glad that passing the credentials in the string directly, solved it!

    KM


    #webMethods
    #Application-Platform
    #Integration-Server-and-ESB