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.


#TechXchangePresenter
 View Only
Expand all | Collapse all

Webmethods 10.1 designer workstation installation, can't run DB Configurator on local MSSQL Database

  • 1.  Webmethods 10.1 designer workstation installation, can't run DB Configurator on local MSSQL Database

    Posted Thu May 03, 2018 01:22 PM

    I have 9.6 designer workstation installed locally.which uses an OracleXE localDB successfully.

    I am installing 10.1 Designer workstation installation with with local MSSQL database on the same machine.

    Following steps taken:

    • install MSSQL
    • create dbs in MSSQL for IS and TN

    After the db is created, WM 10.1 install is then completed. For info different ports have been specified for the various products e.g. 4444 for integration server.

    Can’t run dbConfigurator post webMethods installation on local MSSQL db with error

    “Database Connection error: No suitable driver found for jdbc.wm.sqlserver:”

    Could there be an issue with the two versions installed on the same machine?

    Many thanks for any input.


    #webMethods
    #Integration-Server-and-ESB


  • 2.  RE: Webmethods 10.1 designer workstation installation, can't run DB Configurator on local MSSQL Database

    Posted Thu May 03, 2018 02:54 PM

    Hi,

    hopefully you have choosen a different installation directory for the second installation.
    Then there should be no issue with the different versions.

    Please check if there need any fixes to be applied, i.e. SCG_DataDirect.

    On the other side you can try to use the existing Oracle XE Database by just specifying different user/schema names.

    Regards,
    Holger


    #Integration-Server-and-ESB
    #webMethods


  • 3.  RE: Webmethods 10.1 designer workstation installation, can't run DB Configurator on local MSSQL Database

    Posted Thu May 03, 2018 02:56 PM

    Many thanks, yes there are in separate directories. If I have no futher luck with MSSQL will try your suggestion


    #Integration-Server-and-ESB
    #webMethods


  • 4.  RE: Webmethods 10.1 designer workstation installation, can't run DB Configurator on local MSSQL Database

    Posted Tue May 08, 2018 01:48 PM

    Apologies for this log, the JDBC URL Used during the product installation was incorrect. However the error reported didn’t lead me to this conclusion.

    Before URL was Jdbc.wm.sqlserver://localhost:2450;instanceName=SQLEXPRESS;databaseName=WMTN
    After URL is Jdbc:wm:sqlserver://localhost:2450;instanceName=SQLEXPRESS;databaseName=WMTN


    #webMethods
    #Integration-Server-and-ESB