Pentaho

 View Only

  • 1.  Support for connection to Microsoft SQL Server 2019

    Posted 09-29-2022 12:08
      |   view attached
    We are using the OEM version of Pentaho shipped with BMC Remedy 6.0.1.0-386

    Our developers have successfully been able to connect to a MS SQL server 2016 database using using the latest version of JDBC driver 11.2.0.0

    We have recently tried connecting to a MS SQL server 2019 database but are receiving the attached login error (credentials masked to xxx)

    Since we can connect to this DB with the ID and PW from MS SQL Server Studio (v 18.x) we are wondering of this dated version of Pentaho and the JDBC driver will support a connection to MS SQL Server 2019?

    I am asking this for a few reasons:

    1. We ask this because we did have to update MS SQL Server Studio or MS SQL server 2019.
    2. We also haven't found any examples that reference MS SQL Server 2019.
    3. We have located different versions of the Pentaho component list, but nothing as far back as our 6.0 version.
    4. Even in the documentation for later versions don't reference support / compatibility for MS SQL DB versions as far as a data source connection They do reference MS SQL DB versions for a repository (not a data source) and the latest I have seen was 2016. 

    So, is there any definitive documentation about Pentaho support for a MS SQL server 2019 datasource?

    It could be for our 6.0 version, or perhaps even a later version that does (or does not) support MS SQL server 2019


    ------------------------------
    Jeff Henke
    Systems Engineer
    We Energies
    ------------------------------

    Attachment(s)

    txt
    connectionerror.txt   5 KB 1 version


  • 2.  RE: Support for connection to Microsoft SQL Server 2019

    Posted 09-30-2022 06:40
    Hi Jeff,
    IMHO it's problem of JDBC driver.
    In stacktrace of error is used jTDS driver but your developers used MS JDBC driver. Change connection type in Spoon or update jTDS driver to latest (lib dir in installation of Spoon) and test again.

    ------------------------------
    Petr Prochazka
    Systems Engineer
    P.V.A. systems s.r.o.
    ------------------------------

    Original Message


  • 3.  RE: Support for connection to Microsoft SQL Server 2019

    Posted 09-30-2022 08:39
    After some testing we have resolved the issue and have our working connection to MS SQL Server 2019.

    For us this was the first SQL Server 2019 DB, but it was also the first connection to any MS SQL DB where the permissions were maintained by an active directory group and ID.  Every other connection we have uses SQL server authentication with a local MS SQL server ID

    In this case, the AD authentication and permissions worked fine through MS SQL Server Studio, but from Pentaho.

    To get around this we simply created a local ID in MS SQL server and our Pentaho connection works.

    Under ideal circumstances we'd spend time to get to the root cause but we have this in place in our developers are off and running.


    ------------------------------
    Jeff Henke
    Systems Engineer
    We Energies
    ------------------------------

    Original Message


Related Content