Pentaho

 View Only

How to add "Instance Name" field when connecting Pentaho BI to MS SQL Server?

This thread has been viewed 9 times
  • 1.  How to add "Instance Name" field when connecting Pentaho BI to MS SQL Server?

    Posted 19 days ago

    In Pentaho Data Integration 9.2 CE (Spoon) I succesfully connect to MS SQL Server 2022 like the image below:

    When I try to do the same with Pentaho Server 9.2 CE I cannot insert the instance name like in the image below:

    At the same time, I got insance parameter in the options tab of the server connections since it's has been passed by the PDI like the image below:

    I already have the jtds-1.3.1.jar driver. How can I insert the instance name in Pentaho Server?

    Thanks a lot in advance!



    ------------------------------
    Giovanni Trinca
    none
    ------------------------------